Re: Writing to .xlsm files with COM-Interface

[PhilipNienhuis]

PhilipNienhuis wrote
> TimotheusNemitz wrote
>> Hello,
>> I would like to write to .xlsm files with xlswrite. The COM interface is
>> available. 
>> https://wiki.octave.org/IO_package says, that the COM interface is the
>> only
>> interface which might be able to write to xlsm-files, but not for every
>> EXCEL version. 
>> I'm using Octave 5.1.0, IO Package 2.4.12 and Office 365. 
>> However, writing to a xlsm-file with xlswrite results in a xlsx file and
>> not
>> in a xlsm file.
>> 
>> Should writing to xlsm files be possible with my Office version? Is there
>> a
>> list somewhere which EXCEL versions support writing to xlsm?
> 
> There needs to be some additional code in the io package to convince Excel
> to write other file formats than just .xlsx. I hit this myself when trying
> to write to .xls formats.
> I'm busy with tackling that issue but it'll take some time. I hope it'll
> be
> in io-2.4.13, to be released this fall and hopefully a bit earlier.

I've pushed a few fixes for the io package [*], AFAICS writing to .xlsm
should be possible now. At least that works now on my Win7 box.

Philip

[*] http://hg.code.sf.net/p/octave/io/rev/695263c67597




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