[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Exc
From: |
Zachary Strider McGregor-Dorsey |
Subject: |
[Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Excel worksheet reordering |
Date: |
Thu, 11 Jun 2015 16:52:27 +0000 |
User-agent: |
Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.124 Safari/537.36 |
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/
- [Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Excel worksheet reordering,
Zachary Strider McGregor-Dorsey <=
- [Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Excel worksheet reordering, Philip Nienhuis, 2015/06/11
- [Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Excel worksheet reordering, Zachary Strider McGregor-Dorsey, 2015/06/12
- [Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Excel worksheet reordering, Philip Nienhuis, 2015/06/12
- [Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Excel worksheet reordering, Philip Nienhuis, 2015/06/19
- [Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Excel worksheet reordering, Philip Nienhuis, 2015/06/19
- [Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Excel worksheet reordering, Philip Nienhuis, 2015/06/19
- [Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Excel worksheet reordering, Philip Nienhuis, 2015/06/22