Scilab Home Page | Wiki | Bug Tracker | Forge | Mailing List Archives | Scilab Online Help | File Exchange
ATOMS : xlreadwrite toolbox details
Login with GitLab

xlreadwrite toolbox

read and write xls and xlsx files
(7663 downloads for this version - 19075 downloads for all versions)
Details
Version
1.2.4
Author
Stéphane Mottelet
Owner Organization
Université de Technologie de Compiègne
Maintainer
Stéphane MOTTELET
Category
License
Creation Date
April 13, 2021
Source created on
Scilab 6.1.x
Binaries available on
Scilab 6.1.x:
Windows 64-bit Windows 32-bit Linux 64-bit Linux 32-bit macOS
Scilab 2023.1.x:
Windows 64-bit Windows 32-bit Linux 64-bit Linux 32-bit macOS
Scilab 2024.0.x:
Windows 64-bit Windows 32-bit Linux 64-bit Linux 32-bit macOS
Scilab 2025.0.x:
Windows 64-bit Windows 32-bit Linux 64-bit Linux 32-bit macOS
Install command
--> atomsInstall("xlreadwrite")
Description
            This toolbox allows to read and write Excel BIFF8 .xls files and .xslx files in
a transparent way, with the same syntax as the Matlab functions xlsread and
xlswrite. It is based on the Apache POI Java library.
            
Files (6)
[656 bytes]
Miscellaneous file

[20.72 MB]
OS-independent binary for Scilab 6.1.x

[20.72 MB]
OS-independent binary for Scilab 2023.1.x

[41.39 MB]
OS-independent binary for Scilab 2024.0.x

[20.72 MB]
OS-independent binary for Scilab 2025.0.x

[20.65 MB]
Source code archive

News (0)
Comments (1)     Leave a comment 
Comment from David Chèze -- February 17, 2025, 11:37:04 AM    
Hi, 
I'm using succesfully the xlreadwrite module to retrieve tabular data among several
sheets 
(4) from xlsx experimental files, about 1-5 Mo size. I'm wondering about the required
time 
to import the data into scilab, several minutes (~3). The import of the same data copied in

csv file would last only a few ms in comparison.
The amount of data is not that high (output value= xlread(myfile,4) is 30000x4 matrix of 
doubles).
I'm running scilab 2025.0.0 on WIN10-64bits machine.

Thank you for any clue to understand this behaviour,

David

  
Answer from Stéphane MOTTELET -- February 17, 2025, 01:21:05 PM    
Hello,

xlreadwrite has always been slow as it is based on a Java library and on pure Scilab code.

If you have raw matrices of numeric data, the xlsx format is definitely not convenient.

S.

> Hi, 
> I'm using succesfully the xlreadwrite module to retrieve tabular data among
several
> sheets 
> (4) from xlsx experimental files, about 1-5 Mo size. I'm wondering about the
> required time 
> to import the data into scilab, several minutes (~3). The import of the same data
copied
> in 
> csv file would last only a few ms in comparison.
> The amount of data is not that high (output value= xlread(myfile,4) is 30000x4 matrix
of
> 
> doubles).
> I'm running scilab 2025.0.0 on WIN10-64bits machine.
> 
> Thank you for any clue to understand this behaviour,
> 
> David
> 
>   
Leave a comment
You must register and log in before leaving a comment.
Login with GitLab
Email notifications
Send me email when this toolbox has changes, new files or a new release.
You must register and log in before setting up notifications.