[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