[Octave-bug-tracker] [bug #53459] io package (2.4.10), function xlsread, results in unexpected error reading Excel (xlsx) file

[Markus Mützel]

Follow-up Comment #3, bug #53459 (project octave):

@Werner: "odsread" seems to be working for me if you take the hidden sheet
"Event Timeline Data" into account:

>> [numarr,txtarr,rawarr,limits]=odsread('500V_SHORT.ods', 10, [], 'OCT');
Checking requested interface(s):
OCT*; (* = default interface)
>> numarr(1:4,1:4)
ans =

          NaN  5.0000e+002  5.0000e+002  5.0000e+002
          NaN  1.0000e+000  2.0000e+000  3.0000e+000
  -1.8083e+002  -4.4367e-003  -2.4526e-003  -2.8605e-004
  -1.7983e+002  -5.9604e-004  -1.5911e-003  2.2382e-003



I am also attaching a patch for __OCT_xlsx2oct__.m that fixes the issue with
file #43669 for me.
@Philip: I have inverted the logic to prefer the r:id over a direct
enumeration of the sheet%d.xml files. Do you think that might cause problems
in other cases?

(file #43673)
    _______________________________________________________

Additional Item Attachment:

File name: bug53459_sheet_by_name.patch   Size:2 KB


    _______________________________________________________

Reply to this item at:

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

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