What is your question exactly? Is it that you want the value returned as a string with no decimals or are you encountering an error somewhere?
FELIX BERIG <[email protected]> wrote on 2012-09-13 01:46:23 PM: > FELIX BERIG <[email protected]> > 2012-09-13 01:46 PM > > Please respond to > "POI Users List" <[email protected]> > > To > > [email protected], > > cc > > Subject > > POI 3.8 Invalid cell type > > > Hi All. > > I recently upgraded to POI 3.8. I am having issue with cell type when > trying to read xls file. The cell is defined as a text. But value in the > cell is numeric(5678). When I validate the cell type I can see that it > is Cell.CELL_TYPE_NUMERIC and the value in the cell is 5678.0 > > Here is the code I have: > ... > import org.apache.poi.ss.usermodel.Workbook; > .... > Workbook workbook = null; > FileInputStream fileInputStream = new FileInputStream(fileName); > if(fileExt.equals("xls"){ > workbook = new HSSFWorkbook(fileInputStream); > } > if(fileExt.equals("xlsx"){ > workbook = new XSSFWorkbook(fileInputStream); > } > sheet = workbook.getSheetAt(0); > xlsRow = sheet.getRow(0); > > etc.... > > > Am I doing something wrong? > > Thank you, > Feliks. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] >
