Re: Create an XLSX using the COM interface

[Philip Nienhuis]

ijourneaux wrote
> 
> Philip Nienhuis wrote
>> All I can say is that at that very moment Excel tries to create the file
>> on disk (until then all data are in memory only). It is clearly (for me)
>> an Excel problem.
> I now agree. Per my earlier email this is an Excel "bug" Changing from
> SaveAs to SaveCopyAs seems to solve the problem.

Ian,

Thanks for sorting this out.

Googleing for "Excel SaveAs SaveCopyAs" provides some more or less useful
pointers. An overall picture emerges that this issue is not so much of an
Excel bug but rather Excel2007+ being a bit more picky than its
predecessors.

The best seems to be replacing "SaveAs" by "SaveCopyAs" for new files
(xls.changed == 2). It does work with Excel'97 as well. I'll fix this in the
io pkg.

Philip




--
View this message in context: 
http://octave.1599824.n4.nabble.com/Create-an-XLSX-suing-the-OCT-interface-tp4667144p4667169.html
Sent from the Octave - General mailing list archive at Nabble.com.