how to read data form excel sheet

Submitted by saikiran6 on Mon, 07/11/2011 - 15:52

Dear all,

I am new to scilab. how to read data from excel sheet. My data contains 10 rows and 8 coloumns. 

In matlab this is the syntax:

train_path=xlsread('C:\Users\saikiran\Documents\MATLAB\SVM LATEST\finaltrain4.xlsx','sheet2','a1:i32');

 

Please tell me the syntax for the same in scilab. I am struck here.

Thanks in Advance..

Saikiran

Taxonomy upgrade extras: 
General

sudarson

Wed, 08/17/2011 - 04:23

1. Use :

sheets = readxls(file_path)

or

[fd,SST,Sheetnames,Sheetpos] = xls_open(file_path)

2. You can first save the excel file as csv format and the formatted file can easily be handled in Scilab.

Hope this will help.