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

xls link

xls_link (Automation link with Excel) A easy way to call excel(TM) from Scilab
(11214 downloads for this version - 60645 downloads for all versions)
Details
Version
0.2
A more recent valid version exists: 0.6.0
Author
Allan CORNET
Owner Organization
Scilab
Maintainer
Antoine ELIAS
Category
License
Creation Date
June 28, 2010
Source created on
Scilab 5.3.x
Binaries available on
Scilab 5.3.x:
Windows 32-bit
Install command
--> atomsInstall("xls_link")
Description
            xls_link (Automation link with Excel) A easy way to call excel(TM) from Scilab
            
Files (2)
[142.94 kB]
Source code archive
XLS link sources
[407.92 kB]
Windows 32-bit binary for Scilab 5.3.x
Windows 32-bit
Automatically generated by the ATOMS compilation chain

News (0)
Comments (17)     Leave a comment 
Comment from Allan CORNET -- June 29, 2010, 05:04:20 PM    
xls_link 0.2 beta version to show that we can do between excel and scilab

Enjoy !

Allan
Comment from Allan CORNET -- June 29, 2010, 06:21:49 PM    
xls_link 0.2 beta version to show that we can do between excel and scilab

Enjoy !

Allan
Comment from Peter Cusack -- November 14, 2010, 11:39:40 PM    
Hi Allan.

Looking for download of windows zip. No link on this page or sourceforge page.

Peter.
Comment from Allan CORNET -- November 15, 2010, 08:01:55 AM    
xls_link 0.2 available in ATOMS client for Scilab 5.3 on Windows 32 & 64 bits

source are available here:http://forge.scilab.org/index.php/p/xls-link/
do not hesitate to send me your feedback.

Allan
Comment from david adams -- January 19, 2011, 11:20:25 PM    
There was no help in the help files.  That is there was only the headers.

There is no way to use the functions in this toolbox without even basic information about
function calls or descriptions of the function.

This module should be removed until this basic information is provided.



Answer from Allan CORNET -- January 20, 2011, 06:10:59 AM    
> There was no help in the help files.  That is there was only the headers.
> 
> There is no way to use the functions in this toolbox without even basic information
> about
> function calls or descriptions of the function.
> 
> This module should be removed until this basic information is provided.
> 
> 
> 

Hi,

It is a BETA (xls_link 0.2 beta) version

You can see demos and tests

Allan ;)
Comment from Hanh Pham -- January 25, 2011, 12:15:49 AM    
Hi Allan,

It would be very useful to have a function that calls Excel to execute a macro. Do you plan

to add this to the toolbox in the near future?

Thanks,
Hanh
Comment from Yann Laurant -- January 26, 2011, 09:01:54 AM    
Hi Allan,

I'm using windows XP 64 bits, and I can't manage to use your toolbox because the 
xls_link_x64.dll file is not provided in your package. But your toolbox looks to be very 
powerfull, thanks for your work.

Yann
Comment from Jose Volta -- February 24, 2011, 12:25:20 AM    
Great idea!
 
This will be a very useful toolbox for Scilab. 
Although incomplete and without help pages yet, the demos are impressive, running in 
Excel 2003 or 2007.
I suppose these functions use COM interface of Windows Office to comunicate Excel with 
Scilab. Good job to simplify the access and control of Excel application. (could also be 
some others Windows apps)

J.L.V.
Comment from Pascal Buehler -- April 11, 2011, 08:47:59 AM    
It is a very good toolbox, but can it be done also for Libre Office Worksheets for linux?
Comment from Pascal Buehler -- July 29, 2011, 10:27:26 AM    
Hello my name is Pascal Bühler, 

i wanted to know, if this Toolbox works also for Libre Office?

When yes, how do i make this?

M.f.G. Pascal 
Comment from Marinus van Holst -- August 4, 2011, 04:13:02 PM    
I have loade Scilab_XLL 0.1-0. This is confirmed when I open the command window.
I have registered XLL with Exel according to the instructions.

I have tried the following command, copied from the Scilab help file

[fd,SST,Sheetnames,Sheetpos] = xls_open('SCI/modules/spreadsheet/demos/xls/Test1.xls')

It works. The response is:  Sheetpos = etc.

Then I have tried the following command with a path to an Exel file on my C-drive:

[fd,SST,Sheetnames,Sheetpos] = xls_open('c:\aaa\ScilabEx\OefEx1.xlsx')

The response is:

xls_open: File c:\aaa\ScilabEx\OefEx1.xlsx is not an ole2 file. ????

What can I do?

Marinus
Answer from Allan CORNET -- August 4, 2011, 04:37:23 PM    
> I have loade Scilab_XLL 0.1-0. This is confirmed when I open the command window.
> I have registered XLL with Exel according to the instructions.
> 
> I have tried the following command, copied from the Scilab help file
> 
> [fd,SST,Sheetnames,Sheetpos] =
xls_open('SCI/modules/spreadsheet/demos/xls/Test1.xls')
> 
> It works. The response is:  Sheetpos = etc.
> 
> Then I have tried the following command with a path to an Exel file on my C-drive:
> 
> [fd,SST,Sheetnames,Sheetpos] = xls_open('c:\aaa\ScilabEx\OefEx1.xlsx')
> 
> The response is:
> 
> xls_open: File c:\aaa\ScilabEx\OefEx1.xlsx is not an ole2 file. ????
> 
> What can I do?
> 
> Marinus

Hi,

xls_open is not a function of xls_link but of Scilab.

In your case, xls_open (scilab function) does not read a office 2010 file (only xls)

Allan




Comment from marie-laure nauleau -- February 1, 2012, 06:17:52 PM    
Hello,

I am trying to install Scilab_XLL 0.1-0 on Scilab 5.3.3.

It seems that it is loaded because I read 
“Start Scilab_XLL
Load help “,
when I open the command window.

I have registered XLL with Excel (in 2007 version) according to the instructions and I can
find the formula =SLGetMatrix(),=SLPutMatrix(), etc but when I try with a variable just
created in the command window (in interactive mode), it is written
“System.TypeinitializationException:” in the cell.

Do know what is my problem? How can I solve it?

Thank you very much in advance for your help.

Marie


Answer from Allan CORNET -- February 1, 2012, 07:07:03 PM    
> Hello,
> 
> I am trying to install Scilab_XLL 0.1-0 on Scilab 5.3.3.
> 
> It seems that it is loaded because I read 
> “Start Scilab_XLL
> Load help “,
> when I open the command window.
> 
> I have registered XLL with Excel (in 2007 version) according to the instructions and
I
> can
> find the formula =SLGetMatrix(),=SLPutMatrix(), etc but when I try with a variable
just
> created in the command window (in interactive mode), it is written
> “System.TypeinitializationException:” in the cell.
> 
> Do know what is my problem? How can I solve it?
> 
> Thank you very much in advance for your help.
> 
> Marie
> 
> 

Please notice that this module is not XLL but it is XLS_link.

Allan
Comment from Yann Laurant -- February 21, 2012, 03:12:10 PM    
Hi Allan,

This toolbox works pretty nice, but I have some issues when I use the xls_AddWorksheet 
function. As we don't know the number of this worksheet neither its name, it is hard to 
select it and modify it. Is there a solution for that ?
Thanks for your help.

Yann
Comment from Eric Strauss -- May 8, 2012, 10:44:11 PM    
Hi Allan,

I'm new to SciLab.  Looking for an alternative to Matlab.  Quite a bit of experience with 
the Spreadsheet Link EX with Matlab, so I was excited to find your toolbox.

I am however having a lot of trouble installing.  I don't see this available through the 
ATOMS GUI in Scilab.

Is there a set of written instructions on how to install this so that it loads when I open

SciLab?  And are there then associated macros from Excel to send variables to SciLab?

Eric
Comment from Eric Strauss -- May 18, 2012, 09:23:01 PM    
This does not work with SciLab 5.4.0 Alpha.  I did get it to install on 5.3.3.
Comment from Mustafa Daif -- August 4, 2012, 04:55:57 PM    
Dear Allan

Thank you for the toolbox. I have a question. 

I received this error message 

'NULL IDispatch passed to XLS_LINK_Wrap()'.

I went to Excel and then File ...>option...>Add Ins

but I did not see any addins.

What's the trouble?
Comment from Mustafa Daif -- August 5, 2012, 05:25:53 PM    
Dear Allan

Thank you for the toolbox. I have a question. 

I received this error message 

'NULL IDispatch passed to XLS_LINK_Wrap()'.

I went to Excel and then File ...>option...>Add Ins

but I did not see any addins.

What's the trouble?
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.