[Octave-bug-tracker] [bug #60830] xls2oct can't find worksheets in .xlsx file

[Greg Holmberg]

URL:
  <https://savannah.gnu.org/bugs/?60830>

                 Summary: xls2oct can't find worksheets in .xlsx file
                 Project: GNU Octave
            Submitted by: gholmberg
            Submitted on: Sat 26 Jun 2021 02:58:36 PM PDT
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Incorrect Result
                  Status: None
             Assigned to: None
         Originator Name: Greg Holmberg
        Originator Email: 
             Open/Closed: Open
                 Release: 6.2.0
         Discussion Lock: Any
        Operating System: GNU/Linux

    _______________________________________________________

Details:

I have an .xlsx file created by Google Sheets (File > Download > Microsoft
Excel (.xlsx)).

After download, I can open the file in LibreOffice 7.0.6.2 on Ubuntu 20.10
(Linux 5.8.0).

However, if I try to read it with xls2oct, I get:


error: xls2oct: worksheet number 1 > number of worksheets in file (0)


If I give a worksheet name, I get:


error: xls2oct: cannot find sheet 'Modeling' in file sample.xlsx


The following script reproduces the problem with the attached .xlsx file.


xls = xlsopen("sample.xlsx", true);
[cells, xls, status] = xls2oct(xls);
xls = xlsclose(xls);


My environment:


ver
----------------------------------------------------------------------
GNU Octave Version: 6.2.0 (hg id: 5cfdf97c5350)
GNU Octave License: GNU General Public License
Operating System: Linux 5.8.0-59-generic #66-Ubuntu SMP Thu Jun 17 00:46:01
UTC 2021 x86_64
----------------------------------------------------------------------
Package Name  | Version | Installation directory
--------------+---------+-----------------------
     control  |   3.2.0 | /home/greg/snap/octave/78/octave/control-3.2.0
          io *|   2.6.3 | /home/greg/snap/octave/78/octave/io-2.6.3
      signal  |   1.4.1 | /home/greg/snap/octave/78/octave/signal-1.4.1

version -java
ans = no usable Java Runtime Environment (x86_64) found:
javaMethod: support for Java was unavailable or disabled when Octave was
built

chk_spreadsheet_support([], 2)

(OCT interface... OK, included in io package)

1. Checking Octave's Java support... none.
This Octave has no built-in Java support. Skipping Java checks
Only ODS 1.2 (.ods) & OOXML (.xlsx) & .gnumeric r/w support present
ans = 0





    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Sat 26 Jun 2021 02:58:36 PM PDT  Name: sample.xlsx  Size: 121KiB   By:
gholmberg

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

    _______________________________________________________

Reply to this item at:

  <https://savannah.gnu.org/bugs/?60830>

_______________________________________________
  Message sent via Savannah
  https://savannah.gnu.org/