[Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Excel worksheet reordering

[Zachary Strider McGregor-Dorsey]

URL:
  <http://savannah.gnu.org/bugs/?45303>

                 Summary: xlsread in io package can't handle Excel worksheet
reordering
                 Project: GNU Octave
            Submitted by: tarrou
            Submitted on: Thu 11 Jun 2015 04:52:26 PM GMT
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Incorrect Result
                  Status: None
             Assigned to: None
         Originator Name: 
        Originator Email: 
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 4.0.0
        Operating System: Microsoft Windows

    _______________________________________________________

Details:

  When you manually reorder worksheets in Excel, the sheetId in the underlying
xml file stays the same, but the order of the sheets in the <sheets></sheets>
changes.  Before reordering, sheetIds just go from 1 to n, in order.

  It appears that the io package, when you run xlsread(filename,
worksheetname), finds the worksheet name, looks at the sheetId and imports the
data from the sheet that corresponds to that number.  If the "Sheet3" has
sheetId is 3, xlsread(filename, 'Sheet3') imports the 3rd sheet in
<filename>.

  However, if you move Sheet3 to the beginning of the workbook, it is now the
first sheet as indicated by its placement in the <sheets></sheets> list, but
sheetId remains 3.  Thus xlsread(filename, 'Sheet3') still imports the 3rd
sheet, which is wrong.

  A similar problem occurs when you delete a sheet (so, for example, the 3rd
sheet becomes the 2nd).  Also, I should mention that this works in MatLab.

  Hopefully, this is an easy fix.






    _______________________________________________________

Reply to this item at:

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

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