accessing the sheets by name rather than index
I tried doing through Spreadsheet::ParseExcel rather than the "simple" version.
I get the sheet names in the right order (not that that is so important) but the contents appear with a different sheet. For example:
Sheet foo
contents of bar
Sheet bar
contents of baz
Sheet baz
empty
What I want is the data from "foo" (what I expect to be the first sheet). As you suggest, if I could get it by name, all would be saved ... even if the event would be hard to explain.
I was a bit vague regarding the "reappearing data" because it's just too weird. In excel, I deleted the other sheets from the file and found that I could then find my "foo" data on the "foo" sheet (the only one left).