[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupt
From: |
Philip Nienhuis |
Subject: |
[Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice |
Date: |
Thu, 8 Jun 2017 05:24:53 -0400 (EDT) |
User-agent: |
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0 |
Update of bug #51203 (project octave):
Status: None => Need Info
Assigned to: None => philipnienhuis
Release: 4.2.1 => dev
_______________________________________________________
Follow-up Comment #1:
The issue is that you're being hit by double-byte character issues; I'm sorry
for that. Octave isn't very good at handling double-byte characters esp. on
Windows.
Luckily there's a way out for you.
First, be sure to upgrade the io package to 2.4.7 (latest version).
Then in your script change the line:
xlswrite(filename,cell1,[],[],'oct');
into:
xls = xlsopen ("o076xls.xlsx", 1, "oct");
xls = oct2xls (cell1, xls, 1, "", struct ("convert_utf", 1));
xls = xlsclose (xls);
and try again.
If I do that I get the attached file that is read perfectly fine by Excel and
LibreOffice.
FYI: the option "convert_utf" is what you need. Try:
help oct2xls
_or_
help oct2ods
_and_
help xls2oct
_or_
help ods2oct
for more info.
Please report back!
Release => other (as it is an OF package issue and not core Octave)
(file #40885)
_______________________________________________________
Additional Item Attachment:
File name: o076xls-2.7z Size:5 KB
_______________________________________________________
Reply to this item at:
<http://savannah.gnu.org/bugs/?51203>
_______________________________________________
Message sent via/by Savannah
http://savannah.gnu.org/
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice, Aleshin Andrey Igorevich, 2017/06/08
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice,
Philip Nienhuis <=
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice, Aleshin Andrey Igorevich, 2017/06/08
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice, Aleshin Andrey Igorevich, 2017/06/08
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice, Aleshin Andrey Igorevich, 2017/06/08
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice, Aleshin Andrey Igorevich, 2017/06/08
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice, Aleshin Andrey Igorevich, 2017/06/08
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice, Philip Nienhuis, 2017/06/08
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice, Aleshin Andrey Igorevich, 2017/06/08
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice, Aleshin Andrey Igorevich, 2017/06/08
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice, Aleshin Andrey Igorevich, 2017/06/08
- [Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice, Aleshin Andrey Igorevich, 2017/06/08