Hi,
I have method to read XLS as below
I have attached sample XLS.
I need to convert that XLS file to XML file as attached using apache POI and
java program.
I need to iterate the XLS file based on first column to do all this. If first column is null ignore. Instead it has values like
AAA9115
AAA9116
AAA911
AAA9119
AAA9118
BBB911
BBB912
BBB913
BBB914
BBB919
BBB9117
BBB9114
BBB9113
then read that row and then to convert it to XML.
each tag _1, _2, _3,_4,_5,_6 gets values from corresponding XLS cells.
I looked for column iterator similar to row iterator to check if it is null or not
//Iterator colIter = mySheet.colIterator();
but API does not have it. How Can I achieve this task.
Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance