[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]

Follow-up Comment #2, bug #51203 (project octave):

Me pleasantly, that you answered me. Thank you very much. Thank you very much.
I studied, understood and tried new variant a long time, therefore I write
only now.

I replace xlswrite by oct2xls as you recommended.

Russian symbols with 'oct' output correct only in Linux without structure
"convert_utf". Me smile. I attached screenshots and xlsx-es.

But this is not priority task. Today, it is may to read and write in English
only.
-------------
Main task - is to do sure output in xlsx - was not obtain by me with oct2xls.
In Linux - no problems. Sure and guaranteed. In Windows, I have same result.
Therefore, problem may be is not be related with xlswrite and oct2xls. I don't
know, what.

In two words: when script to be with files and folders - often there are
xml-files instead file.xlsx.

Yea, io-2.4.7:

pkg list
Package Name         | Version | Installation directory
---------------------+---------+-----------------------
                 io *|   2.4.7 | C:\OCTAVE~1.1\share\octave\packages\io-2.4.7


oct2xls:

filename = C:\05octave\o076.xlsx
warning: xls2open: file C:\05octave\o076.xlsx couldn't be unzipped
warning: __OCT_spsh_open__: some elements in list of return values are
undefined
warning: called from
    __OCT_spsh_open__ at line 85 column 7
    xlsopen at line 318 column 30
    o076xls at line 25 column 5
warning: xlsopen.m: file type not supported by oct
warning: called from
    xlsopen at line 338 column 7
    o076xls at line 25 column 5
error: oct2xls: invalid xls file pointer struct


xlswrite:

filename = C:\05octave\o076.xlsx
warning: xls2open: file C:\05octave\o076.xlsx couldn't be unzipped
warning: __OCT_spsh_open__: some elements in list of return values are
undefined
warning: called from
    __OCT_spsh_open__ at line 85 column 7
    xlsopen at line 318 column 30
    xlswrite at line 202 column 9
    o076xls at line 36 column 3
warning: xlsopen.m: file type not supported by oct
warning: called from
    xlsopen at line 338 column 7
    xlswrite at line 202 column 9
    o076xls at line 36 column 3


Today I use a not right solution - to repeat output:

xlswrite(filename,cell1,'sh1','A1');

t=1; %'oct' не всегда выводится с 1 раза
while (exist(filename)~=2)&&t<=1 %пока не сущ и к-во поп<=3
  xlswrite(filename,cell1,[],[],'oct');
  t=t+1;
end

if (exist(filename)~=2)
  fprintf('Please repeat script\n');
end
-verbatim
This is not liked by me, but today it is works only that. Me smile.

(file #40886, file #40887, file #40888, file #40889)
    _______________________________________________________

Additional Item Attachment:

File name: m oct2xls.7z                   Size:0 KB
File name: screenshots oct2xls.7z         Size:170 KB
File name: xlsx-es oct2xls.7z             Size:17 KB
File name: again same strange files oct2xls.7z Size:3 KB


    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?51203>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/