Can anyone help me in parsing an Excel File(.xls) which consists of multiple records.
I have created a schema but when I tried to run with the file, it is showing “No Valid records Found”. I have defined the Flat File Definition with record delimiter as “carriage return line feed” and field delimiter as “Tab” but could not solve my problem.
I was told to write a generic java service which parses the Xcel file with any number of columns. It would be great and helpful if anyone can provide me a solution.
Many Thanks in Advance.
Thanks & Regards,