Please note that the recommended version of Scilab is 6.0.0. This page might be outdated.
See the recommended documentation of this function
read a sheet in an Excel file
[Value,TextInd] = xls_read(fd,Sheetpos)
a number, the logical unit on the Excel stream returned by xls_open.
a number: the position of the beginning of the sheet in the Excel stream. This position is one of those returned by xls_open.
a matrix of numbers, the numerical data found in the sheet. The cell without numerical data are represented by
a matrix of indices with the same size as
Value. The 0 indices indicates that no string exists in the correspondin Excel cell. a positive index
ipoints to the string
SSTis given by xls_open.
This function reads an Excel sheet given a logical unit on an Excel stream ant the position of the beginning of the sheet within this stream. It returns the numerical data and the strings contained by the Excel cells.
The readxls function can be used to read all an Excel file in one function with a single function call.
Warning only BIFF8 Excel files (last Excel file version) are handled
- Pierrick Mode
- Serge Steer
This function is based on Excel stream description from OpenOffice (http://sc.openoffice.org/spreadsheetfileformat.pdf).
This function uses the xls.c file which can be found in a Scilab source version in the directory SCIDIR/modules/spreadsheet/src/c