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

    • NPANS
    • 4 mths ago
    • Reported - view

    Mark the grid of Excel data with a name (aka "named range") or as an Excel table. 

Content aside

  • Status Answered
  • 4 mths agoLast active
  • 1Replies
  • 63Views
  • 2 Following