Operations on Excel using Scilab ( Text Tutorials)


Scilab Can read text and numbers from excel file as well as .csv (comma separated values)  file.

It can read .xls  and .csv files  not xlsx files.

Scilab uses  readxls() Command for reading Excel file into scilab environment. 

     Syntax:  variable_name=readxls(“file_name.xls”)

Data from  individual sheet can be read using fields like text and  values.

when we are using readxls() command, it will display all sheets available from excel file.
Individual sheets can be accessed as follows:
e.g. for sheet 1 :                  sh1=sheets(1),
       for sheet 2:                   sh2=sheets(2)               and so on


•Text and numbers can be separated from sheets.
•E.g. from sheet 1 : sh1.text()  --text will be separated 
                                 :  sh1.value()—numbers will be separated