Hi,
(Urgent Help Needed)
Can anybody tell me how to handle a dynamically changing excel file…
Probably depends on what you are doing with the excel file.
There is a reusable package in the WMUsers software section for handling Excel files that may help you out. Its called “EXCEL_contentHandler” and can create text/xml files from Excel.
But with the excel content handler of the sharewares section I cannot handle the Null data because the file actually ends with a column with a null…
Ex: the fileds from the file are in this way…
EmloyeesDesc EmpID Sal Sdate EDate ProductStart A1 A2 A3 A4 A5 A6 A7 ProductStart B1 B2 B3 B4 B5 B6 B7
so all those are fields and between Productstart and productend the fileds are dynamic(I mean the excel file which we get is not fixed)…so how do I need to handle…
Have you looked at Jakarta-Apache POI/HSSF ?