Scilab Home Page | Wiki | Bug Tracker | Forge | Mailing List Archives | Scilab Online Help | File Exchange
ATOMS : Scilab_XLL details
Login with GitLab

Scilab_XLL

Scilab Xll Add in for Excel (97 to 2007)
(8369 downloads for this version - 14037 downloads for all versions)
Details
Version
0.1.1
Author
allan.cornet@scilab.org
Owner Organization
Consortium Scilab - DIGITEO
Maintainer
Allan CORNET
Category
License
Creation Date
September 27, 2012
Source created on
Scilab 5.4.x
Binaries available on
Scilab 5.4.x:
Windows 32-bit Windows 64-bit
Install command
--> 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 (3)
[41.20 kB]
Source code archive
makes it available for Scilab 5.4
[54.99 kB]
Windows 32-bit binary for Scilab 5.4.x
Windows 32-bit
Automatically generated by the ATOMS compilation chain

[55.03 kB]
Windows 64-bit binary for Scilab 5.4.x
Windows 64-bit
Automatically generated by the ATOMS compilation chain

News (0)
Comments (4)     Leave a comment 
Comment from Jason Nicholson -- December 26, 2012, 02:11:12 AM    
Great idea!  However, the built plugins are missing:

Scilab_XLL.xll
Scilab_XLLC.dll
Scilab_XLL.NET.dll
xlwDotNet-vc90-mt-4_0_0f0.dll

Answer from Eric Strauss -- August 5, 2013, 09:31:16 PM    
> Great idea!  However, the built plugins are missing:
> 
> Scilab_XLL.xll
> Scilab_XLLC.dll
> Scilab_XLL.NET.dll
> xlwDotNet-vc90-mt-4_0_0f0.dll
> 

Did you get it to work after adding those files?  I can't seem to get the link to work.

I'm running:
W7 - 64 bit
Office 2010 - 32 bit
SciLab - 32 bit (tried SciLab 64 bit as well)

I installed Scilab_XLL from the "Module manager - ATOMS" within SciLab, then
downloaded the 
zip file and copied all of those files over manually to the bin folder
C:\Program Files (x86)\scilab-5.4.1\contrib\Scilab_XLL\0.1.1-1\bin

I also got the add-in loaded properly through Excel and it shows up and so do the
functions.
Comment from Mister Shadow -- February 17, 2016, 01:22:30 AM    
Hi,

Where are those add-ins? They did not come with the .zip file.

Thanks,
Comment from Alex Miller -- October 3, 2016, 11:40:55 PM    
Posting this here and on the xls link page
I had an issue that I believe is very common, and as a novice programmer - took a 
minute to iron out:

Need to run a scilab script from Excel
Script imports values from Excel
Does math
Results are sent back to Excel

Reached out to Scilab Enterprises. They quoted me a few thousand $ to develop a 
functioning 'excel live link' toolbox to perform the above 

I managed to do it rather simply, and thought this should be public

~9 line macro is all it takes

VBA Shell function to execute script (requires full path to scilex.exe and your 
script. See the introtoscilab.pdf for "-f" syntax)

Use readxls to get values from excel to scilab (works great)

Do math

Write results to a temp csv with csvWrite

Have script exit scilab

Have macro wait till your temp csv exists

Then refresh data connection that pulls values into proper places

Then Kill the csv.

Done with 1 button click! 
Leave a comment
You must register and log in before leaving a comment.
Login with GitLab
Email notifications
Send me email when this toolbox has changes, new files or a new release.
You must register and log in before setting up notifications.