[Scilab-users] determining the amount of excelsheets in an xls(mlist)-variable
Rafael Guerra
jrafaelbguerra at hotmail.com
Thu Nov 3 23:50:24 CET 2016
Hi Christoph,
Please try:
--> ExcelFile =readxls('test.xls');
--> size(ExcelFile.sheets)
Regards,
Rafael
-----Original Message-----
From: users [mailto:users-bounces at lists.scilab.org] On Behalf Of christophk
Sent: Thursday, November 03, 2016 8:49 PM
To: users at lists.scilab.org
Subject: [Scilab-users] determining the amount of excelsheets in an xls(mlist)-variable
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.
_______________________________________________
users mailing list
users at lists.scilab.org
http://lists.scilab.org/mailman/listinfo/users
More information about the users
mailing list