--> atomsInstall("xls_link")
xls_link (Automation link with Excel) A easy way to call excel(TM) from Scilab
Upload date : 2013-01-23 10:58:44 MD5 : d7376df75b441a9f0ad98a225381af8b SHA1 : e555b4904a31a49720764652ff4823c55eb1394d Downloads : 245 File list
Windows 32-bit Automatically generated by the ATOMS compilation chain
Upload date : 2013-01-23 11:40:58 MD5 : aaa63232536495aaa66bd008e6fb8fa3 SHA1 : 88e82d656dc552d7bee2fec76e8af3842533bdaf Downloads : 321 File list
Windows 64-bit Automatically generated by the ATOMS compilation chain
Upload date : 2013-01-23 11:37:24 MD5 : 27d1fcacc6e8107c22a133719a98df73 SHA1 : ea5629e9f62d936c69f5bf79c4ca3169a2018dae Downloads : 732 File list
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
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
It works perfectly, thanks a lot. Alessandro
This comment has been deleted.
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! ^^