[Octave-bug-tracker] [bug #60830] [octave-forge] (io) xls2oct can't find worksheets in .xlsx file

[Philip Nienhuis]

Update of bug #60830 (project octave):

                  Status:                    None => Confirmed              
        Operating System:               GNU/Linux => Any                    
                 Summary: [octave forge] (io) xls2oct can't find worksheets in
.xlsx file => [octave-forge] (io) xls2oct can't find worksheets in .xlsx file

    _______________________________________________________

Follow-up Comment #1:

Confirmed on Windows:

>> [a, b, c] = xlsfinfo ("sample.xlsx", "oct")
a = Microsoft Excel Spreadsheet
b = [](0x1)
c =

>> [a, b, c] = xlsfinfo ("sample.xlsx", "poi")
a = Microsoft Excel Spreadsheet
b =
{
  [1,1] = Modeling
  [2,1] = Constants
  [1,2] = A1:AG52
  [2,2] = A1:Z10
}

c = xlOpenXMLWorkbook
>>


Given bug #60825 and this one, I wonder what Google does to provide these
spreadheets. Apparently they set them up differently than any other
spreadsheet SW we've seen til now.
I'm wondering if locale settings and text encoding play a role here.

If no one beats me to it I'll look at it after my vacation i.e., after
mid-July. Until then I can't do much.

In the mean time you can work around it by invoking the Apache POI interface
("poi") as shown above. You need a Java JRE and add the relevant files from
Apache POI to the javaclasspath; see the html doc in the io package
installation dir for details, of see the wiki. Many distros have Apache POI in
their repos, chances are that your distro has it as well.
As in bug #60825 you mention LibreOffice, another alternative is using the
Java UNO bridge supplied by LibreOffice. It could be that it needs additional
installation of LibreOffice parts from your distro's repo.

In the io package there's a function chk_spreadsheet_support that can set up
the javaclasspath for you, given paths to where Apache POI files and/or the
LibreOffice program are installed.


    _______________________________________________________

Reply to this item at:

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

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