xlswrite()

Read(2449) Label: excel object, save, file,

Description:

Save an Excel file object into an Excel file.

Syntax:

f.xlswrite(xo,p)

Note:

The function saves an Excel file object into the Excel file f.

Parameter:

f

Name of the Excel file into which data is written

xo

An Excel object read in non-@r@w way

p

The password for opening an Excel file; by default, there isn’t one

Example:

 

A

 

1

=file("E1.xls").xlsopen()

Read the E1.xls file and return it.

2

=file("E2.xlsx").xlsopen()

Read E2.xlsx and return an Excel object.

3

=file("T2.xls").xlswrite(A1,"123")

Write the Excel file object into T2.xlsx, and set a password, which is 123, for the latter.

4

=file("T1.xlsx").xlswrite(A2)

Write the Excel file object into T1.xlsx.