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.
Parameters:
|
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("T1.xlsx").xlswrite(A1) |
Write the Excel file object into T1.xlsx |
|
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 |