readxls — reads an Excel file
sheets = readxls(file_path)
a character string: the path of the Excel file.
an mlist of type xls, with one field named sheets
Given an Excel file path this function returns an mlist data structure
of type xls, with one field named sheets. The
sheets field itself contains a list of sheet data structure.
sheet=mlist(['xlssheet','name','text','value'],sheetname,Text,Value) where
sheetname is a character string containing the name of the sheet,
Text is a matrix of string which contains the cell's
strings and Value is a matrix of numberswhich contains the cell's
values.
Warning only BIFF8 Excel files (last Excel file version) are handled
Sheets = readxls('SCI/modules/spreadsheet/demos/xls/t1.xls')
// some basic operations on Sheets
typeof(Sheets)
s1=Sheets(1) //get the first sheet
typeof(s1)
s1.value //get the first sheet value field
s1.text //get the first sheet text field
s1(2,:) //get the 2 row of the sheet
typeof(s1(2,:))
editvar s1