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

[anonymous]

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

                 Summary: io package (2.4.10), function xlsread, results in
unexpected error reading Excel (xlsx) file
                 Project: GNU Octave
            Submitted by: None
            Submitted on: Sun 25 Mar 2018 07:22:51 AM UTC
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Unexpected Error
                  Status: None
             Assigned to: None
         Originator Name: Werner Simbuerger
        Originator Email: address@hidden
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 4.2.2
        Operating System: Microsoft Windows

    _______________________________________________________

Details:

The function xlsread (io oackage version 2.4.10) does not read xlsx and xls
Excel file with more complex sheet strcture.

Please try it with the attached example: 500V_SHORT.xlsx

Please try to read all sheets, or specific sheets (in my case sheet no. 9).


Test Case 1)

[numarr,txtarr,rawarr,limits]=xlsread('500V_SHORT.xlsx',9,[],'OCT');


Checking requested interface(s):
OCT*; (* = default interface)
error: 'id' undefined near line 52 column 58
error: called from
    __OCT_xlsx2oct__ at line 52 column 15
    xls2oct at line 203 column 27
    xlsread at line 238 column 29
    main at line 21 column 29


Test Case 2)

[numarr,txtarr,rawarr,limits]=xlsread('500V_SHORT.xlsx','Current Wfms
Data',[],'OCT');

Checking requested interface(s):
OCT*; (* = default interface)
error: 'rawdata' undefined near line 91 column 17
error: called from
    __OCT_xlsx2oct__ at line 91 column 7
    xls2oct at line 203 column 27
    xlsread at line 238 column 29
    main at line 20 column 29


Best regards,
Werner Simbuerger




    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Sun 25 Mar 2018 07:22:51 AM UTC  Name: 500V_SHORT.xlsx  Size: 2MiB   By:
None

<http://savannah.gnu.org/bugs/download.php?file_id=43669>

    _______________________________________________________

Reply to this item at:

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

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