New answers tagged


If you want to use a library to write data in excel, you can use org.apache.poi


I used to have a similar job; pulling down reports from different vendors in Excel and doing a pseudo-ETL. Excel Macros were great and I had one macro for each vendor. Still, I saved countless hours each week by learning macros.


Please check this code .which may helpful for many :- public String cellconvertor(Cell cell) { try { String cellvalue=null; if(cell.getCellType().equals(CellType.STRING)) { cellvalue= cell.getStringCellValue(); } else if (cell.getCellType().equals(CellType.NUMERIC )) ...

Top 50 recent answers are included