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)
else if (cell.getCellType().equals(CellType.NUMERIC ))