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

(8900 downloads for this version - 21124 downloads for all versions)
Details
Version
0.3.3
Authors
Allan CORNET
Antoine ELIAS
Entity
Scilab Enterprises
Maintainer
Antoine Elias
Category
License
Creation Date
May 15, 2013
Source created on
Scilab 5.4.x
Binaries available on
Scilab 5.4.x:
Windows 32-bit Windows 64-bit
Scilab 5.5.x:
Windows 32-bit Windows 64-bit
Install command
--> 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 (5)
[155.08 kB]
Source code archive

[236.49 kB]
Windows 32-bit binary for Scilab 5.4.x
Windows 32-bit
Automatically generated by the ATOMS compilation chain

[238.58 kB]
Windows 64-bit binary for Scilab 5.4.x
Windows 64-bit
Automatically generated by the ATOMS compilation chain

[183.85 kB]
Windows 32-bit binary for Scilab 5.5.x
Windows version (i686)
Automatically generated by the ATOMS compilation chain

[183.99 kB]
Windows 64-bit binary for Scilab 5.5.x
Windows version (x64)
Automatically generated by the ATOMS compilation chain

News (0)
Comments (14)     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    
hahaha
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.
thanks
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 'xls_link-0.3.3-1-src.zip'. 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"

Antoine
Comment from Egabro Egabro -- August 13, 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 -- 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
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 -- 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:

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!
Comment from Roland Lihl -- July 12, 2016, 04:46:07 PM    
I tried to install the package, but there seems to be a problem.

I stardet to install the Package with Atoms, but the error "WARNING: xls_link gateways
not 
loaded." showes up.

The xls_link folder with all the data is in  the contrib folder, so it should be instaled.

I use win7x64

Roland
Answer from Florent Rochette -- September 23, 2016, 07:55:02 PM    
Roland,
have you found a solution to this problem since 12th July?
Comment from Florent Rochette -- September 23, 2016, 07:53:57 PM    
I have the same problem as Roland Lihl...
Comment from Samuel Gougeon -- September 25, 2016, 05:04:58 PM    
This module is out of work.
The DLL defining built-in functions is not shipped in the binary file.
Leave a comment
You need to log in before you can leave a comment.