How to parse complex excel file
Hi All,
I have a requirement to parse a complex excel file containing,
1. multiple drop downs
2. macros
3. multiple work sheets
4. Rows and Columns are not visible.
I know pxParseExcel can read a file from top after the header.
In my case there are gaps in the file as if it is word doc, so I need to read the file as and when there is data.
Thanks