bugGNU Octave - Bugs: bug #46667, xlsread + OCT interface gives...

 
 

bug #46667: xlsread + OCT interface gives error for xlsx file (io 2.2.11)

Submitter:  None
Submitted:  Fri 11 Dec 2015 12:13:02 PM UTC
   
 
Category:  Octave Package Severity:  3 - Normal
Priority:  5 - Normal Item Group:  Other
Status:  Works For Me Assigned to:  None
Originator Name:  Originator Email:  -email is unavailable-
Open/Closed:  * Closed Release:  * 4.0.0
Operating System:  * Microsoft Windows Fixed Release:  None
Planned Release:  None
* Mandatory Fields

Add a New Comment Rich Markup
   

Sun 20 Dec 2015 11:29:35 PM UTC, comment #2: 

OP now has working xlsread, as posted in the thread in comment #1.

Closing report.

Philip Nienhuis <philipnienhuis>
Group Member
Fri 11 Dec 2015 07:01:45 PM UTC, comment #1: 

(see thread http://octave.1599824.n4.nabble.com/Problems-import-xlsx-using-OCT-interface-and-io-2-2-11-tt4673954.html)

Works for me using Octave-4.0.1-rc1 (just cross-built for Windows) and io-2.2.11:

>> pkg list
Package Name  | Version | Installation directory
--------------+---------+-----------------------
          io *|  2.2.11 | ...\share\octave\packages\io-2.2.11
>> cd c:/tmp
>> xlsread ('qplx2.xlsx', 'Ark1', '', 'oct')
Checking requested interface(s):
OCT*; (* = default interface)

ans =

   101.000    49.400    24.877
   120.000    72.600    30.857
   145.000    99.400    36.095
   174.000   138.000    40.360
   222.000   228.000    47.492
    90.300    50.700    24.610
   113.000    76.600    29.764
   131.000   101.000    34.343
   153.000   132.000    38.641
   166.000   152.000    40.158
   209.000   243.000    46.991
    73.000    53.700    22.903
    90.900    75.000    27.955
   104.600   100.500    32.249
   148.000   184.000    40.965
   180.100   269.000    46.190
    59.400    50.000    21.109
    71.400    77.800    26.771
    81.200    99.800    29.320
   101.000   150.000    35.067
   115.000   185.000    37.727
   143.500   298.300    43.882
    43.000    52.400    20.000
    53.500    80.700    23.922
    61.300   103.600    27.722
    80.400   173.000    34.343
    88.400   205.000    36.606
   115.000   301.600    45.187
    22.900    46.500    20.000
    31.000    75.600    20.000
    36.100   102.000    23.349
    42.700   149.000    30.641
    53.800   241.500    37.524


Given the error messages you posted in the thread referenced above, I wonder if you have any function files lying around that shadow core functions.
What do the following commands:
"which unpack"
"which zip
 which unzip"
(w/o double quotes)
report when run from Octave?

Philip Nienhuis <philipnienhuis>
Group Member
Fri 11 Dec 2015 12:13:02 PM UTC, original submission:  

trying to xlsread ordinary 3D-tabel in attached file 'qplx2' on sheet 'ark1' gives this in command window:


snip ******
Checking requested interface(s):
OCT*; (* = default interface)
warning: fopen: 'C:/Users/bbjn/Documents/Octave\qplx2.xlsx' found by searching load path

file qplx2.xlsx couldn't be unpacked. Is it the proper file format?
warning: __OCT_spsh_open__: some elements in list of return values are undefined
warning: xlsopen.m: file type not supported by OCT
error: File ptr struct expected for arg @ 1
>>


Relevant code is:

 chk_spreadsheet_support == 0   # default OCT interface
 # fil=strcat(filnavn,".csv");
 fil=strcat(filnavn,'.xlsx');
 [Data,Label] =xlsread(fil,arknavn,[],"OCT");


*** end of snip

Similar use in earlier octave versions using Java interface functioned fine for xls files...

Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

Attached Files
file #35697:  qplx2.xlsx added by None (9KiB - application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by philipnienhuis
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only group members can vote.

     

    Follow 5 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2015-12-20 philipnienhuis StatusNeed Info Works For Me
        Open/ClosedOpen Closed
    2015-12-12 philipnienhuis StatusNone Need Info
    2015-12-11 philipnienhuis Carbon-Copy- Added philipnienhuis
    2015-12-11 None Attached File- Added qplx2.xlsx, #35697

    Back to the top

    Powered by Savane 3.13-d3ae.
    Corresponding source code