Scilab Website | Contribute with GitLab | Mailing list archives | ATOMS toolboxes
Scilab Online Help
6.0.0 - Français

Change language to:
English - 日本語 - Português - Русский

Please note that the recommended version of Scilab is 2024.0.0. This page might be outdated.
See the recommended documentation of this function

Aide de Scilab >> Tableur > xls_read

xls_read

reads a sheet in an Excel file

Syntax

[Value,TextInd] = xls_read(fd,Sheetpos)

Arguments

fd

a number: the logical unit on the Excel stream returned by xls_open.

Sheetpos

a number: the position of the beginning of the sheet in the Excel stream. This position is one of those returned by xls_open.

Value

a matrix of numbers: the numerical data found in the sheet. The cells without numerical data are represented by NaN values.

TextInd

a matrix of indices with the same size as Value. The 0 indices indicates that no string exists in the corresponding Excel cell. A positive index i points to the string SST(i) where SST is given by xls_open.

Description

This function reads an Excel sheet given a logical unit on an Excel stream and 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.

Only BIFF8 Excel files (last Excel file version (2003)) are handled.

Examples

//Decode ole file, extract and open Excel stream
[fd,SST,Sheetnames,Sheetpos] = xls_open('SCI/modules/spreadsheet/demos/xls/Test1.xls')
//Read first data sheet
[Value,TextInd] = xls_read(fd,Sheetpos(1))
//close the spreadsheet stream
mclose(fd)

See also

  • xls_open — opens an Excel file for reading
  • readxls — reads an Excel file

Bibliography

This function is based on Excel stream description from OpenOffice (http://sc.openoffice.org/spreadsheetfileformat.pdf).

Used Functions

This function uses the xls.c file which can be found in a Scilab source version in the directory SCIDIR/modules/spreadsheet/src/c.

Report an issue
<< xls_open Tableur Console >>

Copyright (c) 2022-2023 (Dassault Systèmes)
Copyright (c) 2017-2022 (ESI Group)
Copyright (c) 2011-2017 (Scilab Enterprises)
Copyright (c) 1989-2012 (INRIA)
Copyright (c) 1989-2007 (ENPC)
with contributors
Last updated:
Tue Feb 14 15:06:51 CET 2017