Re: Excel .xla in Octave

[PhilipNienhuis]

mspitoni wrote
> Hello everybody!
> 
> I am starting using Octave with the aim to replace Matlab in doing
> essentially the same work. However, I am having some troubles here. I have
> an add-in (.xla file) in excel, which allows to compute some specific
> fluid
> thermodynamic properties by knowing just two variables (for example,
> enthalpy from temperature and pressure).
> My purpose is as follows:
> - write the needed string on an excel sheet using Octave xlswrite
> function;
> - read the result computed in excel by using Octave xlsread function.
> At this stage, I am able to write the string on excel, but when I try to
> read the result, Octave gives empty matrix. But if I open the excel file,
> the result is calculated in the specified cell.
> I don't know if it could be a matter of saving the file after writing from
> Octave.

To me it is a it unclear exactly what you are doing.
Obviously you need to save a changed file before you can read the changes.
xlswrite does save a file to disk, so that should be covered.
However, if you want the add-in to do its work while reading it with
xlsread, I'm afraid that may not work as you want. Things like formula
evaluation and add-in operation generally don't work in functions like
xlsread/xlswrite that merely do plain data exchange.

Only if you run octave on Windows, and you have Excel installed, and you
have the octave-forge windows package loaded, then you have a chance that
you can get somewhere as then excel itself is used to read the file. But
still I don't know if add-ins will do their work then. Maybe you need to
load and rewrite the file with Excel in between.

Philip




--
Sent from: http://octave.1599824.n4.nabble.com/Octave-General-f1599825.html