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

Scilab Xll Add in for Excel (97 to 2007)
(5269 downloads for this version - 9880 downloads for all versions)
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
January 25, 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 -- January 25, 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 -- March 29, 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 -- March 30, 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 -- March 29, 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 -- March 30, 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 -- March 29, 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 -- March 30, 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 -- March 25, 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 -- March 25, 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 -- August 4, 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 -- August 5, 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 -- August 9, 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 -- August 9, 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 -- October 23, 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 -- May 18, 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 -- May 19, 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.