xls link

Comment from Allan CORNET -- May 15, 2013, 03:13:39 PM    

Please modify:

Entity: DIGITEO - Scilab Enterprises

Comment from Antoine ELIAS -- May 15, 2013, 03:23:20 PM    

hahaha

Comment from Egabro Egabro -- August 1, 2013, 08:34:47 PM    

Excuse me if the question is stupid but...

How the **** do I use this?
I see no help or documentation.

Is there a set of functions that xls-link makes available to me? How do I use those
functions? I see that the Atom is loaded, but I have no clue how to use it.
thanks

Comment from Egabro Egabro -- August 1, 2013, 08:49:55 PM    

Now I see the help.
It wasn't there initially. I copied it from 'xls_link-0.3.3-1-src.zip'. I think it is
missing in the installation package (?)

Comment from Egabro Egabro -- August 1, 2013, 10:20:54 PM    

This comment has been deleted.

Comment from Antoine ELIAS -- August 9, 2013, 11:37:53 AM    

Hi Egabro,

Documentation is generated during compilation process, so source package does not contain 
help jar file, only help sources ( xml files ).
If you install package via atoms, you can use help like "help xls_Open"

Antoine

Comment from Egabro Egabro -- August 13, 2013, 08:29:11 AM    

Thanks.
As is turns out, the help files for the ATOMS don't load properly if the previous Scilab
session was closed while the help window was still open. All I had to do to get the help
for xls_link back was to close the help window and open it again.

Thanks for xls_link

Comment from Eric Strauss -- August 29, 2013, 07:24:55 PM    

the "xls_SetData" function does not behave consistently when rows greater than 2
are used.  
I particularly have a problem when it's target is "A8".  Sometimes it is anything
except 
"A1" or in one trial, I tried A1-7 and they were fine, then A8 crashes.  A10-A16
checked 
out ok on that trial.

It was a problem in my code, but then I tried running the example file as a check:
xls_link_setget_datas.dem.sce

Changing line 31 from:
xls_SetData("A2", A);
to
xls_SetData("A8", A);

I get the following error:
Warning !!!
Scilab has found a critical error (EXCEPTION_ACCESS_VIOLATION)
with "xls_setProperty" function.
Save your data and restart Scilab.

Also, is there perhaps a way to create another function that would take the destination 
coordinates as integers A1 = 1,1 and A8 = 8,1?

Windows 7 64-bit
Office 2010 32-bit
Scilab 5.4.1 32-bit

Comment from Rodrigo Martin -- September 6, 2013, 10:24:57 AM    

the "xls_SetData" function does not behave consistently when columns are between
670 and 
705. The function ret = xls_ExtendRange(i, j) doesn?t work correctyl 
!--error 999 
xls_SetData: Unable to extend range
at line      23 of function xls_SetData called by :  
at line     126 of function imp_country called by :

Windows 7 2-bit
Office 2010 32-bit
Scilab 5.4.1 32-bit  

Comment from Ivaylo Kolev -- September 12, 2013, 01:43:31 PM    

They also not working correct for me! :(
The command sequence generates Sheets but not put on them the names, and not saves the 
data string in the cells.
Only for the last one it fills the cells with data. 
I mean the last sheet from the sequence for i=1:10. Also it not put the correct name on 
the sheet. It puts the name that should be, but when it generate the next sheet the old 
sheet, become Sheet1, again!  
I don't know, may be I'm doing something wrong. Here is the sequence:

xls_NewExcel();
xls_AddWorkbook();
xls_SetVisible()
for i=1:10
    x = xls_AddWorksheet();
    xls_SetWorksheet(x);
    xls_SetWorksheetName("My Worksheet " + string(i));
    xls_SetData("A1", "Sheet " + string(i));
    sleep(1000);
end
xls_SetSave(%f);
xls_SaveAs('/test')
xls_Close();
xls_Quit();

Please guide me!

Comment from Ivaylo Kolev -- September 12, 2013, 03:47:17 PM    

This comment has been deleted.

Comment from Roland Lihl -- July 12, 2016, 04:46:07 PM    

I tried to install the package, but there seems to be a problem.

I stardet to install the Package with Atoms, but the error "WARNING: xls_link gateways
not 
loaded." showes up.

The xls_link folder with all the data is in  the contrib folder, so it should be instaled.

I use win7x64

Roland

Answer from Florent Rochette -- September 23, 2016, 07:55:02 PM    

Roland,
have you found a solution to this problem since 12th July?

Comment from Florent Rochette -- September 23, 2016, 07:53:57 PM    

I have the same problem as Roland Lihl...

Comment from Samuel Gougeon -- September 25, 2016, 05:04:58 PM    

This module is out of work.
The DLL defining built-in functions is not shipped in the binary file.

Comment from Alex Miller -- October 3, 2016, 11:40:33 PM    

Posting this here and on the XLL 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! 

Comment from Simon MARCHETTO -- October 6, 2016, 05:32:26 PM    

I am on the issue.

Comment from Yann DEBRAY -- October 10, 2016, 10:58:03 AM    

Dear Alex, 

I have to admit I am quite disappointed of your reaction:
"Reached out to Scilab Enterprises. They quoted me a few thousand $ to develop a 
functioning 'excel live link' toolbox to perform the above "

My colleagues and I from the Scilab Team gave efforts to come up with an industrial grade
solution for 
your need, as we do for all of our clients. I don't think that it is unappropriate to
propose additional services 
for industrial users, as it is a way for us to finance the development of Scilab.

If you just wanted a quick and dirty hack, you should have been clearer on that.

Comment from Alex Miller -- October 10, 2016, 11:56:01 PM    

Yann, 

In all of our communications I was very clear on what we wanted to do: call scilab from 
excel, import values, do math, and export. Those were the only goals or requirements 
ever presented...

I am highly confident that your industrial grade solution would have been 'better' or 
'cleaner' with a proper toolbox. 

I have nothing against Scilab enterprises or your development services; should have been 
clearer on 'quick and dirty'

-Alex