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

(7781/11849 downloads)
xls_link (Automation link with Excel) A easy way to call excel(TM) from Scilab
Details
Version
0.2-2
Most recent version: 0.3.3
Author(s)
Allan CORNET
Entity
Scilab
Package maintainer
Antoine Elias
Category
License
Supported Scilab Versions
<= 5.3
Creation Date
28th of June 2010
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
Files (2)
[139.59 Ko] xls_link-0.2-2-src.zip
XLS link sources
[398.36 Ko] xls_link_0.2-2.bin.windows.zip
Windows version (i686)
Automatically generated by the ATOMS compilation chain

News (0)
Comments (17)
    Leave a comment 
Comment from Allan Cornet -- 29th of June 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 -- 29th of June 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 -- 14th of November 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 -- 15th of November 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 -- 19th of January 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 -- 20th of January 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 -- 25th of January 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 -- 26th of January 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 -- 24th of February 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 -- 11th of April 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 -- 29th of July 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 -- 4th of August 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 -- 4th of August 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 -- 1st of February 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 -- 1st of February 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 -- 21st of February 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 -- 8th of May 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 -- 18th of May 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 -- 4th of August 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 -- 5th of August 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 need to log in before you can leave a comment.