Has anyone seen where a cell is returned from a different worksheet besides the one that is being used? In my case, I'm extracting values from the same cells across 10 different Excel files. In one file and for only two particular cells, I get the values of the cells on another worksheet of the workbook instead the desired sheet. I get the right values for all the other cells I'm extracting and I get the right values for all the cells in the other 9 workbooks.
Code Snippet:
my $workbook = Spreadsheet::ParseExcel::Workbook->Parse($file);
my $sheet = $workbook->{Worksheet}->[0];
#for $row and $col in list of wanted cells
{
my $cell = $sheet->{Cells}[$row][$col];
my $val = $cell->{Val};
# do stuff with $val
}
In 9 files everything works as expected. In the 10th file, I get the values I expect for most of the cells. For two cells in the worksheet, I get the values from the same cell locations on a different worksheet of the same file. All 10 files are copies of a master file. All 10 files have the same 3 worksheets.
Any suggestions to fix? I've alread downloaded 0.42...
