> Hi > I have a collection which contains String data which I need > to be shown in > excel columns. The actual data may however be of any type > (int, double, date > etc) even though it is stored as string. We cannot apply any numeric > function on excel generated by HSSF if we use > cell.setColumnValue(Stringdata). We need to use > cell.setColumnValue(double). > Is it possible that POI/HSSF doesnt set the data type on its > own but lets > the excel determine what data is passed (as done when we pass > a csv file to > excel)
AFAIK this is not done by Excel but by a csv import module. Maybe you can do it with cell.setCellType(int type)? But I do not know if this works on cells that strings have already been written to. Docu says nothing about it, so it is just a guess. bye, Bodo
smime.p7s
Description: S/MIME cryptographic signature
