Hi, if you don't want to dump the file as text as you asked about using the tool Corion suggested earlier, I suggest getting the owner of the spreadsheet to export it as a CSV document and then use Text::CSV_XS to work with it.

I see that you've posted the example code from the doc for Spreadsheet::ParseExcel, which is a good way to start experimenting. As you learned there is not a method provided to get the full row. I don't know enough about Excel to know the reason for this, but I assume there is a good one.

But, since you have the row number in $row and also the range of columns in the row, you could loop through the cells in the row for the column range and build an array of values, then return that as the "row".

Sure would be simpler to work with CSV, though.

Hope this helps