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

[Tatsuro MATSUOKA]

----- Original Message -----

> From: rcharan51 
> To: help-octave Cc: 
> Date: 2014/6/24, Tue 14:02
> Subject: Re: Problem when writing a cell array( char and numeric data) to 
> excel(.xlsx) file
> 
> Can some one tell me why the data has been changed in the OUT.xlsx(open this
> in libreoffice)when I did this
> 
>>>  [dat, hed, mixed]=xlsread('Book1.xlsx');
> Detected XLS interfaces: >> xlswrite('OUT.xlsx', mixed);
> Creating file OUT.xlsx
> 
> book1( Book1.xlsx
> <http://octave.1599824.n4.nabble.com/file/n4664983/Book1.xlsx>  )
> 
> OUT.xlsx( OUT.xlsx
> <http://octave.1599824.n4.nabble.com/file/n4664983/OUT.xlsx>  ) 
> 


Perhapsyou do not understand the situation fully.
Please read carefully read again this successive thread.

http://octave.1599824.n4.nabble.com/Problem-when-writing-a-cell-array-char-and-numeric-data-to-excel-xlsx-file-td4664851i20.html

Anyway I will make small explanation
There are two bugs.

1. Bug of xlsread
  xlsread on io package seems not to read correctly the Excel sheet which 
contains string and numeric data.

Marcus already mentioned it the previous thread that you voted  
http://octave.1599824.n4.nabble.com/Re-installing-java-and-apache-for-using-spreadsheet-I-O-td4664767i20.html#a4664884


This can be confirmed easily by displaying the variable "mixed"

>> [dat, hed, mixed]=xlsread('Book1.xlsx');
>> mixed 

Obviously cell array variable "mixed" does not reflect the spreadsheet data 
correctly.

Marcus already mentioned that the above is a bug.


2.Bug of xlswrite
This bug can be avoided using LibreOffiece as Philip mentioned.

Until the first bug will be fixed, you can do what you want to do as it is. 

A workaround plan is that save the data in txt file read it by  importdata as
shown previously.

http://octave.1599824.n4.nabble.com/Problem-when-writing-a-cell-array-char-and-numeric-data-to-excel-xlsx-file-td4664851.html#a4664901


HTH

Tatsuro