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

[Philip Nienhuis]

Update of bug #53459 (project octave):

                  Status:                    None => Postponed              
                 Release:                   4.2.2 => other                  
        Operating System:       Microsoft Windows => Any                    

    _______________________________________________________

Follow-up Comment #1:

Confirmed.

This is another "new" situation we hadn't seen til now. Thanks for this
example.
A quick look shows it is probably related to Chart sheets interfering in the
sheet order. I fear this bug can take a while to be fixed; the way the OCT
interface opens .xlsx files needs a thorough review, ditto writing/adding data
to such files. So that's why I set status to "Postponed".

A workaround is to install a Java JRE (if you haven't already had one
installed), install the Apache POI stuff, add it to the javaclasspath (or use
chk_spreadsheet_support.m in the io package to do that for you), and read the
file with the POI interface.
If you have LibreOffice or OpenOffice.org you can also use that with a Java
JRE to read the data into Octave (UNO interface)
Also Excel itself with the windows package works (COM interface).

BTW in passing I noted another bug that I'll fix right away.

    _______________________________________________________

Reply to this item at:

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

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