0
How to skip first N rows when reading an excel file using pyramid when the header is not necessarily the first row.
i have a simple xls but the header row is not always the first row of the file.Using a simple filter i could get rows as per clause in the filter below, but incase i want to skip rows to reach the header what is the best alternative other than reading using python?
1 reply
-
Mark the grid of Excel data with a name (aka "named range") or as an Excel table.