[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Problem when writing a cell array( char and numeric data) to excel(.
From: |
Tatsuro MATSUOKA |
Subject: |
Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file |
Date: |
Tue, 24 Jun 2014 18:07:39 +0900 (JST) |
----- 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.
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, (continued)
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, Philip Nienhuis, 2014/06/21
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, rcharan51, 2014/06/23
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, Tatsuro MATSUOKA, 2014/06/23
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, Tatsuro MATSUOKA, 2014/06/23
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, Philip Nienhuis, 2014/06/23
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, Tatsuro MATSUOKA, 2014/06/23
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, rcharan51, 2014/06/24
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, Markus Bergholz, 2014/06/24
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, rcharan51, 2014/06/24
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, Tatsuro MATSUOKA, 2014/06/24
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file,
Tatsuro MATSUOKA <=