[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 16:46:43 +0900 (JST) |
----- 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
- 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, Tatsuro MATSUOKA, 2014/06/20
- 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 <=
- Re: Problem when writing a cell array( char and numeric data) to excel(.xlsx) file, Tatsuro MATSUOKA, 2014/06/24