--> atomsInstall("xls_link")
xls_link (Automation link with Excel) A easy way to call excel(TM) from Scilab
XLS link sources
Upload date : 2010-06-29 13:42:54 MD5 : 928b1774365415b724e034b8b67bc2ff SHA1 : 787029c8a4af951448dc59df4e8ff1f603229d2d Downloads : 2195 File list
Windows 32-bit Automatically generated by the ATOMS compilation chain
Upload date : 2010-06-29 13:45:54 MD5 : 8c8a2d2da52398a824784fa70ac33b40 SHA1 : f6feb8b81ab863ea45f021afa80e41011e7f5e0f Downloads : 9086 File list
xls_link 0.2 beta version to show that we can do between excel and scilab Enjoy ! Allan
Hi Allan. Looking for download of windows zip. No link on this page or sourceforge page. Peter.
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
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.
> 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 ;)
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
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
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.
It is a very good toolbox, but can it be done also for Libre Office Worksheets for linux?
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
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
> 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
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
> 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
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
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
This does not work with SciLab 5.4.0 Alpha. I did get it to install on 5.3.3.
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?
