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

(3476/13101 downloads)
xls_link (Automation link with Excel) A easy way to call excel(TM) from Scilab
Details
Version
0.3.3-1
Author(s)
Allan CORNET
Antoine ELIAS
Entity
Scilab Enterprises
Package maintainer
Antoine Elias
Category
License
Supported Scilab Versions
>= 5.4.1
Creation Date
15th of May 2013
ATOMS packaging system
Available on
How To Install
atomsInstall('xls_link')
Description
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] xls_link_0.3.3-1.bin.x64.windows.zip
Windows version (x64)
Automatically generated by the ATOMS compilation chain

[230.95 Ko] xls_link_0.3.3-1.bin.windows.zip
Windows version (i686)
Automatically generated by the ATOMS compilation chain

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

Entity: DIGITEO - Scilab Enterprises
Comment from Antoine Elias -- 15th of May 2013, 03:23:20 PM    
hahaha
Comment from Egabro Egabro -- 1st of August 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.
thanks
Comment from Egabro Egabro -- 1st of August 2013, 08:49:55 PM    
Now I see the help.
It wasn't there initially. I copied it from 'xls_link-0.3.3-1-src.zip'. I think it is
missing in the installation package (?)
Comment from Antoine Elias -- 9th of August 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"

Antoine
Comment from Egabro Egabro -- 13th of August 2013, 08:29:11 AM    
Thanks.
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 -- 29th of August 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
except 
"A1" or in one trial, I tried A1-7 and they were fine, then A8 crashes.  A10-A16
checked 
out ok on that trial.

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

Changing line 31 from:
xls_SetData("A2", A);
to
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 -- 6th of September 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 -- 12th of September 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:

xls_NewExcel();
xls_AddWorkbook();
xls_SetVisible()
for i=1:10
    x = xls_AddWorksheet();
    xls_SetWorksheet(x);
    xls_SetWorksheetName("My Worksheet " + string(i));
    xls_SetData("A1", "Sheet " + string(i));
    sleep(1000);
end
xls_SetSave(%f);
xls_SaveAs('/test')
xls_Close();
xls_Quit();

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