Excel to Record List Issues

Excel to Record List Issues

  

Is it possible to import an excel file and convert it to a record list when the excel file headers are not on the first row? 

That is to say the excel file has some headers and titles before the actual spreadsheet data. I attached a screenshot of the file for reference.

Hi Joel,

If I remember correctly, no... but you may be more lucky with one of the other Excel integration forge components, like Advanced Excel.

Hi Joel,

You can use below component this component is having a method named ImportXLSHeader is having input parameter SkipLines to skip the lines to read the excel 


https://www.outsystems.com/forge/component/2939/genericimportfiles/?Unfollow=False



Regards

-SK-

Thanks gentleman, appreciated, I shall try both and see which works better for my purposes.