Parsing excel file with multiple table in a sheet?

Parsing excel file with multiple table in a sheet?

  

Please suggest if there is a component or built-in logic to read and parse excel files with multiple tables in 1 sheet...

Thanks in advance.

Hi Harlin,

It's not possible with the built-in Excel capabilities, but you can take a look at the Forge - there's several Excel components there that should be able to do so.

Or maybe I'll can use Excel2RecordList to get whole excel data, then parse it further...

That might work, depending on the way the data is structured, and whether yu can recognize what data is what (e.g. where does the next table start in the data, etc.).