xls2csv(InpFile)
xls2csv(InpFile,OutpFile,...)
InpFile
[ char ] - Name of an XLS input file that will be converted to CSV.
OutpFile
[ empty | char ] - Name of the CSV output file; if not supplied or empty, the CSV file name will be derived from the XLS input file name.
'sheet='
[ numeric | char | 1
] - Worksheet in the XLS file that will be saved; can be either the sheet number or the sheet name.This function calls a third-party JavaScript (courtesy of Christopher West). The script uses an MS Excel application on the background, and hence MS Excel must be installed on the computer.
Only one worksheet at a time can be saved to CSV. By default, it is the first worksheet found in the input XLS file; use the option 'sheet='
to control which worksheet will be saved.
See also $irisroot/+thirdparty/xls2csv.js for copyright information.
Save the first worksheets of the following XLS files to CSV files.
xls2csv('myDataFile.xls');
xls2csv('C:\Data\myDataFile.xls');
Save the worksheet named 'Sheet3' to a CSV file; the name of the CSV file will be 'myDataFile.csv'
.
xls2csv('myDataFile.xls',[],'sheet=','Sheet3');
Save the second worksheet to a CSV file under the name 'myDataFile_2.csv'
.
xls2csv('myDataFile.xls','myDataFile_2.csv,'sheet=',2);