in reply to Re^2: Unable to read values from Excel file
in thread Unable to read values from Excel file
Yes, DataFromExcel is a "one trick pony". It only has one trick (convert worksheet to Array of Array), but it does that one trick well. It doesn't have convenience functions like accessing a cell like "D4", you have to go to $data->[3,3]. I just needed 2 columns from one sheet of a 5 sheet Workbook and that was enough for me. Mileage varies. The trade-off between complexity and features happens all the time.
Thanks++ for reporting that installing Spreadsheet::ParseExcel did what you needed. That feedback may help somebody else further down the road.
|
|---|