xlswrite()

Read(253) 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.

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