I'm trying to read an existing XLSX file and get the values from a given sheet (e.g. 'Sheet2') and a given range (e.g. "C4:C8", or "C4:F4"). For the moment I'm assuming the range includes cells in either a single row or a single column.
I can read the file and get the sheet, but I'm not sure what is the best way to find the cells for the given range.
One way would be to convert the range to row and column numbers (e.g. C4:C8 --> r4c3:r8c3), then call Worksheet.getSheetData and traverse the returned SheetData to get the cells I need. But I notice that Worksheet.getSheetData will omit empty leading rows, so my row and columns numbers may not correspond to the rows and columns in SheetData, e.g. my row 4 may in fact be row 1 in the data returned from Worksheet.getSheetData.
Any ideas on a robust way to do this?