Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file

[Philip Nienhuis]

rcharan51 wrote
> this is my input file
> (http://octave.1599824.n4.nabble.com/file/n4664883/input.xlsx) this is my
> code 
> inputcrctnbldg.m
> <http://octave.1599824.n4.nabble.com/file/n4664887/inputcrctnbldg.m>  
>  and my problem is stille there while opening the created excel file and
> it shows errors like  above uploaded images

Yep I can reproduce your problem. The intriguing thing is that Excel
complains about an "illegal character" that happens to be an ampersand (&).

The produced Excel file opens fine in LibreOffice; if I write it out from LO
it opens fine in Excel 2013.
So a first workaround would be to use LibreOffice rather than Excel. Apache
POI can read it fine as well.
FYI there seem to be more reports of Excel not being able to read seemingly
valid OOXML files. It is extremely picky.

@Markus: this part of the code (string handling and rewriting sheets
bookkeeping) was written by me; you want me to look at it or will you?

@rcharan51: Most Octave devs have many other priorities, I'm no exeception. 
Another stumbling block for me personally is a code repository change that I
need to adapt to. So do not expect miracles as to when this will be in a
next io package release. 
I did show you a workaround above.

Philip



--
View this message in context: 
http://octave.1599824.n4.nabble.com/Problem-when-writing-a-cell-array-char-and-numeric-data-to-excel-xlsx-file-tp4664851p4664918.html
Sent from the Octave - General mailing list archive at Nabble.com.