Question

MSOParseExcelFile is Deprecated and how to skip two rows with pxParseExcelFile act(hasHeadr params only skip first row)

I have an excel with two column rows(forst row is used for grouping) where I can only keep data from third row, with MSOParseExcelFile i am able to achieve the desired output but, since it is Deprecated, how to achieve the same with pxParseExcelFile, which I couldn't because pxParseExcelFile hasHeader skips only first row.

Thanks in advance,

Harsha K

Comments

Keep up to date on this post and subscribe to comments