[Octave-bug-tracker] [bug #59273] [octave forge] (io) can't reliably load XLSX files in release 2.6.2

[Philip Nienhuis]

Follow-up Comment #5, bug #59273 (project octave):

Looks like you've hit a bug that has been looming for quite some time.

It boils down to always trying to invoke POI for .xls *and* .xlsx even if only
partial POI support (just for .xls) was present. Turns out I fixed this
already in 2017 but after last year's interfaces reshuffling for io-2.6.x that
fix got lost.

The other, subordinate issue is L.131 in xlopen.m,
      reqinterface = [];
which needs unconditionally changing to
      reqinterface = "";

... and maybe it shouldn't be there in that form at all.

As a first step, would you please try again with attached xlsopen.m and
getinterfaces.m ? (the latter to be put in private/ subdir)

Next up = finding out what else you hit when you did have full POI support. If
still needed.

Taking a step backward for some overview it would be better to rethink the
"verbose" option. You say that it worked in io-2.6.1 (and before?) but you
-unknowingly- may have actually invoked OCT rather than POI&OOXML. xlsopen.m
as it stands doesn't give you any clue.


(file #49985, file #49986)
    _______________________________________________________

Additional Item Attachment:

File name: xlsopen.m                      Size:16 KB
    <https://file.savannah.gnu.org/file/xlsopen.m?file_id=49985>

File name: getinterfaces.m                Size:7 KB
    <https://file.savannah.gnu.org/file/getinterfaces.m?file_id=49986>



    _______________________________________________________

Reply to this item at:

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

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