5 Replies Latest reply: Mar 8, 2017 11:55 AM by Evan Kurowski RSS

    Align RecNo() to spreadsheet rows that encounter empties either in body of data or before first header

    Evan Kurowski

      Hello All,


      I have spreadsheets with a varying number of Null rows before encountering the first row containing any sort of data.

       

       

      When using an ODBC connection, it has been capable of tracking blank entries in the past, so that the RecNo() function can align to the spreadsheet.  But it does not seem to be working when the blank rows precede the first header line.

       

       

      Any varying number of fully blank rows before the header are still not getting tabulated by the RecNo() function when loading via ODBC.   Is there a way to pick up the amount of Null rows that appear before the header?