readxls - reads an Excel file
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/demos/excel/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