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
(725 downloads for this version - 41923 downloads for all versions)
Details
Version
0.3
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 11, 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)
[624.50 kB]
Source code archive

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

[755.82 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 Steffen Lehmann -- January 16, 2013, 04:46:31 PM    
With some functions I receive the Error message "NULL IDispatch passes to
XLS_LINK_Wrap()"
Comment from Antoine Elias -- January 16, 2013, 04:48:58 PM    
Hi Steffen, 
Can you give me a sample code to reproduce this error ?
Comment from Steffen Lehmann -- January 22, 2013, 05:04:58 PM    
Hi Antoine
I was trying the instructions in the "Help Browser"

-->xls_NewExcel();
 
-->test_path = xls_getRootPath() + 'tests' + filesep() + 'unit_tests' + filesep();
 
-->xls_Open(test_path+'xls_GetData.xls')
 ans  =
 
  T  
 
-->xls_SelectRange("A4:C5")
 ans  =
 
  F  
  
("NULL IDispatch passes to XLS_LINK_Wrap()")



With "application" instead "worksheet" the function is working.
  
-->ret = xls_callMethod("application", "Range", "A4:C5")
 ret  =
 
  T 

I tested the function with WinXP and Win7 with the same result.

Best regards
Steffen
Comment from Antoine Elias -- January 23, 2013, 10:22:56 AM    
The "xls_open" function does not select a worksheet by default.
I have a patch but I would want to test a little bit more before update the toolbox.

Thank you for your feedback.
Antoine
Comment from Antoine Elias -- January 23, 2013, 11:54:09 AM    
You can find the new version 0.3.1 here :
http://atoms.scilab.org/toolboxes/xls_link/0.3.1
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.