[Scilab-users] Function to read Excel xlsx file into SCILAB

[Rafael Guerra]

I am not aware of such direct function.

A trick that I find quite useful is the possibility to copy data from Excel directly into Scilab via the Windows clipboard.
See ones example below.

// First copy an Excel data range to clipboard then run Scilab commands:
str = clipboard("paste");
M = evstr(strsplit(str,ascii(10)));

Regards,
Rafael

From: users [mailto:users-bounces at lists.scilab.org] On Behalf Of Samuel Enibe
Sent: Tuesday, March 13, 2018 6:19 PM
To: users at lists.scilab.org
Subject: [Scilab-users] Function to read Excel xlsx file into SCILAB

Dear SCILAB users,

is there a direct function available in SCILAB to read an Excel .xlsx file (Excel 2007 or later) into SCILAB.
I know I could open it in Excel and use the SaveAs menu to first convert it to .xls file, but a direct SCILAB function would be faster when handling many files.
Thank you very much.
God bless you.

Samuel  Enibe
University of Nigeria, Nsukka, Nigeria
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.scilab.org/pipermail/users/attachments/20180313/5eaf0bb0/attachment.htm>