Scilab Website | Contribute with GitLab | Mailing list archives | ATOMS toolboxes
Scilab Online Help
5.3.2 - English

Change language to:
Français - 日本語 - Português

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

Scilab help >> Spreadsheet > readxls


reads an Excel file

Calling Sequence

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
s1=Sheets(1) //get the first sheet
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

editvar s1

See Also

  • xls_open — Open an Excel file for reading
  • xls_read — read a sheet in an Excel file


Pierrick Mode


Serge Steer


Used Functions

This function is based on the Scilab functions xls_open and xls_read

<< read_csv Spreadsheet write_csv >>

Copyright (c) 2022-2024 (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:
Thu May 12 11:44:29 CEST 2011