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

[Tatsuro MATSUOKA]

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

> From: Tatsuro MATSUOKA 
> To: rcharan51 "help-octave
> Cc: 
> Date: 2014/6/24, Tue 16:46
> Subject: Re: Problem when writing a cell array( char and numeric data) to 
> excel(.xlsx) file
> 
> ----- 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



Type miss correction:
> Until the first bug will be fixed, you can do what you want to do as it is. 


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