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 retrieved in non-@r@w method. |
|
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. |