[Scilab-users] determining the amount of excelsheets in an xls(mlist)-variable

christophk christoph.knappe at gmail.com
Thu Nov 3 20:48:38 CET 2016


Hello dear Scilab fellows,
I'm new to Scilab and try to find a solution to finding the amount of
excelsheets in a an xls(mlist)-variable. I have been looking on the internet
for an entire day without getting any further.
So here is some code to clarify what I am looking for: 

// Let's assume I read the content of an excelfile into Scilab:
ExcelFile =readxls('test.xls');

// Of course I can just let Scilabs display all available Sheets from the
file by entering:
ExcelFile
// I could even let Scilab display the last sheet by entering
ExcelFile($)

//However any attempt to return the amount of sheets (i.e. the value of "$") 
//in form of an integer just like using
size(Excelfile)
//or
length(Excelfile) 
//either are not defined for mlist-variables or give a wrong answer.

My guess is that i have to define my own function to extract this but I am
held back by my limited understanding of Scilab and the mlist-type of
variable right now.
Does anyone here know a simple solution to this problem?

Thank y'all,
Christoph



--
View this message in context: http://mailinglists.scilab.org/determining-the-amount-of-excelsheets-in-an-xls-mlist-variable-tp4034904.html
Sent from the Scilab users - Mailing Lists Archives mailing list archive at Nabble.com.



More information about the users mailing list