Scilab Home Page | Wiki | Bug Tracker | Forge | Mailing List Archives | Scilab Online Help | File Exchange
ATOMS : xls link details
Please login or create an account

xls link

xls_link (Automation link with Excel) A easy way to call excel(TM) from Scilab
(7550 downloads for this version - 19530 downloads for all versions)
Antoine ELIAS
Scilab Enterprises
Package maintainer
Antoine Elias
Supported Scilab Versions
>= 5.4.1
Creation Date
May 15, 2013
ATOMS packaging system
Available on
Install command
--> atomsInstall('xls_link')
xls_link (Automation link with Excel) A easy way to call excel(TM) from Scilab xls-link (0.3.3) - 2013 * fix trouble in xls_SetData with row range ("A1:D1") and string data * fix bad allocation size in sci_XLS_setProperty
Files (3)
[232.99 Ko]
Windows 64-bit
Automatically generated by the ATOMS compilation chain

[230.95 Ko]
Windows 32-bit
Automatically generated by the ATOMS compilation chain

News (0)
Comments (11)
    Leave a comment 
Comment from Allan Cornet -- May 15, 2013, 03:13:39 PM    
Please modify:

Entity: DIGITEO - Scilab Enterprises
Comment from Antoine Elias -- May 15, 2013, 03:23:20 PM    
Comment from Egabro Egabro -- August 1, 2013, 08:34:47 PM    
Excuse me if the question is stupid but...

How the **** do I use this?
I see no help or documentation.

Is there a set of functions that xls-link makes available to me? How do I use those
functions? I see that the Atom is loaded, but I have no clue how to use it.
Comment from Egabro Egabro -- August 1, 2013, 08:49:55 PM    
Now I see the help.
It wasn't there initially. I copied it from ''. I think it is
missing in the installation package (?)
Comment from Antoine Elias -- August 9, 2013, 11:37:53 AM    
Hi Egabro,

Documentation is generated during compilation process, so source package does not contain 
help jar file, only help sources ( xml files ).
If you install package via atoms, you can use help like "help xls_Open"

Comment from Egabro Egabro -- August 13, 2013, 08:29:11 AM    
As is turns out, the help files for the ATOMS don't load properly if the previous Scilab
session was closed while the help window was still open. All I had to do to get the help
for xls_link back was to close the help window and open it again.

Thanks for xls_link
Comment from Eric Strauss -- August 29, 2013, 07:24:55 PM    
the "xls_SetData" function does not behave consistently when rows greater than 2
are used.  
I particularly have a problem when it's target is "A8".  Sometimes it is anything
"A1" or in one trial, I tried A1-7 and they were fine, then A8 crashes.  A10-A16
out ok on that trial.

It was a problem in my code, but then I tried running the example file as a check:

Changing line 31 from:
xls_SetData("A2", A);
xls_SetData("A8", A);

I get the following error:
Warning !!!
Scilab has found a critical error (EXCEPTION_ACCESS_VIOLATION)
with "xls_setProperty" function.
Save your data and restart Scilab.

Also, is there perhaps a way to create another function that would take the destination 
coordinates as integers A1 = 1,1 and A8 = 8,1?

Windows 7 64-bit
Office 2010 32-bit
Scilab 5.4.1 32-bit

Comment from Rodrigo Martin -- September 6, 2013, 10:24:57 AM    
the "xls_SetData" function does not behave consistently when columns are between
670 and 
705. The function ret = xls_ExtendRange(i, j) doesnt work correctyl 
!--error 999 
xls_SetData: Unable to extend range
at line      23 of function xls_SetData called by :  
at line     126 of function imp_country called by :

Windows 7 2-bit
Office 2010 32-bit
Scilab 5.4.1 32-bit  
Comment from Ivaylo Kolev -- September 12, 2013, 01:43:31 PM    
They also not working correct for me! :(
The command sequence generates Sheets but not put on them the names, and not saves the 
data string in the cells.
Only for the last one it fills the cells with data. 
I mean the last sheet from the sequence for i=1:10. Also it not put the correct name on 
the sheet. It puts the name that should be, but when it generate the next sheet the old 
sheet, become Sheet1, again!  
I don't know, may be I'm doing something wrong. Here is the sequence:

for i=1:10
    x = xls_AddWorksheet();
    xls_SetWorksheetName("My Worksheet " + string(i));
    xls_SetData("A1", "Sheet " + string(i));

Please guide me!
Leave a comment
You need to log in before you can leave a comment.