Scilab Home Page | Wiki | Bug Tracker | Forge | Mailing List Archives | Scilab Online Help | File Exchange
ATOMS : Scilab_XLL details
Please login or create an account

Scilab_XLL

(4988/7483 downloads)
Scilab Xll Add in for Excel (97 to 2007)
Details
Version
0.1
Most recent version: 0.1.1
Author(s)
allan.cornet@scilab.org
Entity
Consortium Scilab - DIGITEO
Package maintainer
Allan Cornet
Category
License
Supported Scilab Versions
>= 5.2
Creation Date
25th of January 2010
ATOMS packaging system
Available on
How To Install
atomsInstall('Scilab_XLL')
Description
Scilab Xll Add in for Excel (2007 to 2010 32 bits) It connects the Excel® interface to the Scilab workspace, enabling you to use Excel worksheet to leverage the numerical and computational power of Scilab. This version requires .NET 3.5 framework installed on your Windows
Files (2)
[317.46 Ko] Scilab_XLL_0.1-1.bin.i686.windows.zip
Windows Version (32 bits)
[39.62 Ko] scilab-xll-0.1.zip
source files 
News (0)
Comments (11)
    Leave a comment 
Comment from Allan Cornet -- 25th of January 2010, 04:32:46 PM    
To know where you can found Scilab_XLL.xll from Scilab:

packages=atomsGetInstalled();disp(packages(find(packages(:,1)=="Scilab_XLL"),4)+'\bin')

Allan
Comment from Edward Lizotte -- 29th of March 2010, 07:23:03 PM    
I installed your excel data program.  I'm new to SCI-Lab and I'm trying to generate plots 
of 3D beam data from Excel.  I have Windows7x64.  I installed the x64 version of SCI-
Lab.  I realize your version is x32.  The excel portion is fine and the help file in SCI-
Lab is fine.

I tried from the SCI-Lab text editor to:
Load and this is what I get,
root_tlbx = get_absolute_file_path('loader.sce');
                                                 !--error 999 
get_absolute_file_path: The file loader.sce is not opened in scilab.
at line      11 of exec file called by :    
exec('C:\Users\Ed\AppData\Local\Temp\SCI_TMP_1412_\LOAD_INTO_SCILAB-0150d176-7f0b-4499-
9f99-986da593c430.sce', 2)
while executing a callback
 

I tried from the SCI-Lab text editor to:
Execute and this is what I get,
-->exec('D:\Ed Library's Downloads\csdb\SCILAB\Scilab_XLL_0.1-
1.bin.i686.windows\Scilab_XLL\loader.sce', -1)
                       !--error 3 
Waiting for right parenthesis.
root_tlbx = get_absolute_file_path('loader.sce');
                                                 !--error 999 

 I'm sure the problem is obvious to the experienced user.  If you think I need to I will 
load the x32 version of SCI-Lab
Thanks for your time;
Ed
Answer from Allan Cornet -- 30th of March 2010, 10:35:57 AM    
> I installed your excel data program.  I'm new to SCI-Lab and I'm trying to generate
> plots 
> of 3D beam data from Excel.  I have Windows7x64.  I installed the x64 version of SCI-
> Lab.  I realize your version is x32.  The excel portion is fine and the help file in
> SCI-
> Lab is fine.
> 
> I tried from the SCI-Lab text editor to:
> Load and this is what I get,
> root_tlbx = get_absolute_file_path('loader.sce');
>                                                  !--error 999 
> get_absolute_file_path: The file loader.sce is not opened in scilab.
> at line      11 of exec file called by :    
> exec('C:\Users\Ed\AppData\Local\Temp\SCI_TMP_1412_\LOAD_INTO_SCILAB-0150d176-7f0b-4499-
> 9f99-986da593c430.sce', 2)
> while executing a callback
>  
> 
> I tried from the SCI-Lab text editor to:
> Execute and this is what I get,
> -->exec('D:\Ed Library's Downloads\csdb\SCILAB\Scilab_XLL_0.1-
> 1.bin.i686.windows\Scilab_XLL\loader.sce', -1)
>                        !--error 3 
> Waiting for right parenthesis.
> root_tlbx = get_absolute_file_path('loader.sce');
>                                                  !--error 999 
> 
>  I'm sure the problem is obvious to the experienced user.  If you think I need to I
> will 
> load the x32 version of SCI-Lab
> Thanks for your time;
> Ed



Yes, you need to use Excel & scilab 32 bits


Allan
Comment from Edward Lizotte -- 29th of March 2010, 07:35:31 PM    
I also tried putting the your module in the same directory under 3rd party.
I execute and loaded from there I use the example text.  this is what I get.


-->SLEvalString("A = ones(3,3);")
                               !--error 4 
Undefined variable: SLEvalString

thanks Ed
Answer from Allan Cornet -- 30th of March 2010, 11:03:22 AM    
> I also tried putting the your module in the same directory under 3rd party.
> I execute and loaded from there I use the example text.  this is what I get.
> 
> 
> -->SLEvalString("A = ones(3,3);")
>                                !--error 4 
> Undefined variable: SLEvalString
> 
> thanks Ed


Hi,

SLEvalString is a excel macro not a scilab macro.

With this toolbox, you can call scilab from excel.

Allan
Comment from Edward Lizotte -- 29th of March 2010, 10:27:42 PM    
Well I read the instructions above about using Atom.  The problem continues though as 
Atom for some reason is in a strange language.  Intalled reinstall, even installed x32 
but  No luck?
Comment from Edward Lizotte -- 30th of March 2010, 05:17:25 AM    
Atom is in some foreign language.  I used command prompts and got you module installed 
but it still won't establish a variable in SCILab for me.
Comment from Roston Simene -- 25th of March 2011, 02:45:41 AM    
i have a problem in putting excel data into scilab array. the sl_putmatrix functions
returns 0, but when i call the variable on scilab, it says undefined variable. . need
help! Can someone show me how to do it? thanks....
Answer from Allan Cornet -- 25th of March 2011, 07:04:14 AM    
> i have a problem in putting excel data into scilab array. the sl_putmatrix functions
> returns 0, but when i call the variable on scilab, it says undefined variable. . need
> help! Can someone show me how to do it? thanks....


Hi,

please send to me a small example to reproduce your trouble or opens a ticket @ 
http://forge.scilab.org/index.php/p/scilab-xll/issues/

Allan
Comment from Tere Mv -- 4th of August 2011, 11:26:00 PM    
Hi, I’m trying to use SLGetMatrix in Excel, but it gets only de first value of de matrix

(1,1). Do you know what happen?
Thanks
Answer from Allan Cornet -- 5th of August 2011, 06:08:26 AM    
> Hi, I’m trying to use SLGetMatrix in Excel, but it gets only de first value of de
> matrix 
> (1,1). Do you know what happen?
> Thanks

Hi,

You must select a range of cells 

{=SLGetMatrix("R")}

Allan
Comment from Tere Mv -- 9th of August 2011, 01:01:02 AM    
Hi Allan, thanks for your reply. Sorry, but I'm new in SCILab and I put {=SLGetMatrix
("R")} in some cells (dim of de matrix), but it doesn't work. I need do anything
else?

Thanks
Answer from Allan Cornet -- 9th of August 2011, 06:16:55 AM    
> Hi Allan, thanks for your reply. Sorry, but I'm new in SCILab and I put {=SLGetMatrix
> ("R")} in some cells (dim of de matrix), but it doesn't work. I need do
> anything else?
> 
> Thanks


Hi,

it is not a scilab feature but of Excel

Select some cells in excel and press CTRL + SHIFT + ENTER 
see http://www.cpearson.com/excel/ArrayFormulas.aspx

Allan
Comment from Jim Regan -- 23rd of October 2011, 06:47:00 AM    
I am using Windows XP/SP3, SCILAB v5.2.2 (32-bit) and Excel 2000. I downloaded from above,
Scilab_XLL_0.1-1.bin.i686.windows.zip and extracted the files. I installed
"Scilab_xll" as
an addin to Excel. I then opened the included file "example.xls". If I try to
execute the
cell "D3", Excel throws an "Unexplained error" 

"Microsoft Excel for Windows has encountered a problem and needs to close.  We are
sorry
for the inconvenience."

for which Microsoft helpfully suggests buying a newer version of Excel as the only
solution. Excel vanishes as soon as I dismiss the Microsoft Excel for Windows crash
window.

Thank you.
Comment from Eric Strauss -- 18th of May 2012, 09:28:13 PM    
Excel 2007
Windows XP
SciLab 5.3.3

The only function I can get to work from "examples.xls" is the
"=SLGetMatrix("WSCI")"
And it seems it only works for variables that were created upon SciLab startup (or 
internally created variables).  

If I create some dummy variable "a = 2;" from within SciLab

I get this result when executing the formula "=SLGetMatrix("a")" in the
Excel cell:
"System.NullReferenceException:"
Comment from Eric Strauss -- 19th of May 2012, 02:57:21 PM    
I see there is an update to xls_link.  Does that mean an update to Scilab_XLL is 
forthcoming?  I'm hopeful that development hasn't been abandoned.

Scilab_XLL is perfect for developing Excel based applications for engineers that are 
unfamiliar with the Scilab programming environment.

If there is an update, can you provide the syntax to call the commands directly in VBA?
Leave a comment
You need to log in before you can leave a comment.