You are here: home | xls link | 0.3.1

xls link

xls_link (Automation link with Excel) A easy way to call excel(TM) from Scilab

(1216 downloads for this version - 60963 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

Windows Tools

Website

http://forge.scilab.org/index.php/p/xls-link/

License

CeCILL

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")

Report a bug

GitLab's issues for xls_link

Description

            xls_link (Automation link with Excel) A easy way to call excel(TM) from Scilab

Files (3)

[155.02 kB]

xls_link-0.3.1-1-src.zip

Source code archive

Upload date : 2013-01-23 10:58:44
MD5         : d7376df75b441a9f0ad98a225381af8b
SHA1        : e555b4904a31a49720764652ff4823c55eb1394d
Downloads   : 215
 File list

[223.49 kB]

xls_link_0.3.1-1.bin.windows.zip

Windows 32-bit binary for Scilab 5.4.x

Windows 32-bit
Automatically generated by the ATOMS compilation chain

Upload date : 2013-01-23 11:40:58
MD5         : aaa63232536495aaa66bd008e6fb8fa3
SHA1        : 88e82d656dc552d7bee2fec76e8af3842533bdaf
Downloads   : 296
 File list

[225.52 kB]

xls_link_0.3.1-1.bin.x64.windows.zip

Windows 64-bit binary for Scilab 5.4.x

Windows 64-bit
Automatically generated by the ATOMS compilation chain

Upload date : 2013-01-23 11:37:24
MD5         : 27d1fcacc6e8107c22a133719a98df73
SHA1        : ea5629e9f62d936c69f5bf79c4ca3169a2018dae
Downloads   : 705
 File list

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! ^^