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
(1121 downloads for this version - 42720 downloads for all versions)
Details
Version
0.3.1
A more recent valid version with binaries for Scilab 5.4 exists: 0.3.4
Authors
Allan CORNET
Antoine ELIAS
Owner Organization
Scilab
Maintainer
Antoine Elias
Category
License
Creation Date
January 23, 2013
Source created on
Scilab 5.4.x
Binaries available on
Scilab 5.4.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
            
Files (3)
[155.02 kB]
Source code archive

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

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

News (0)
Comments (5)     Leave a comment 
Comment from Alessandro Zaupa -- March 7, 2013, 12:15:47 PM    
Hello everyone,
is it possible to get the active workbook of the currently running Excel
(i. e. without creating a new workbook and without opening an Excel file)?

Thanks.

Alessandro
Comment from Antoine Elias -- March 7, 2013, 03:08:44 PM    
Hi Alessandro,

It is clearly a missing feature.

But you can reconnect an existing excel by this way : 

xls_RecoverExcel() // returns T
xls_callMethod("application", "workbooks", 1) //select first workbook
xls_SetWorksheet(1) //select first wsheet and returns T

Always run entire sequence to initialize internal structure of
application->workbook->worksehet->range.


I hope that help you.

Antoine
Comment from Alessandro Zaupa -- March 7, 2013, 04:43:24 PM    
It works perfectly,
thanks a lot.

Alessandro
Comment from Alessandro Zaupa -- March 7, 2013, 05:32:06 PM    
This comment has been deleted.
Comment from Ben Reily -- March 23, 2013, 12:17:56 AM    
I have a bad issue with the x86 version.
I'll expain:
- I create a program with Scilab 5.4 64 bit plus xls_link_0.3.1-1.bin.x64.windows.zip ,
Windows 7 and Excel 2003: I use a lot the function  SetWorksheet

- Now I have to port my program on a Pc that have only 32 bit so I use Scilab 5.4 32 bit
and xls_link_0.3.1-1.bin.windows.zip. Win 7 and Excel 2003 are unchanghed.

When I try my program it crash on function  SetWorksheet so I cannot change sheet! 
I try  SetWorksheet alone on an opened xls file it only works on the x64 version, the x86
always crash.

I'm not dong anything special also the SetGet demo crash when using  SetWorksheet !

So please if you can fix it up I would appreciate a lot.
Thanks! ^^
Leave a comment
You must register and log in before leaving a comment.
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.