Databases
StackOverflow2013
Postsdbo
POReading Column values from Excel as string return as decimal?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReading Column values from Excel as string return as decimal?
    text
    copied!<p>I have a requirement to read Excel file particular column values.</p> <p>I unable to read the cell values as they are.</p> <p>My code is </p> <pre><code>import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.openxml4j.exceptions.InvalidFormatException; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.WorkbookFactory; import org.apache.poi.ss.usermodel.Workbook; public class ExcelSheetColumn { public static void main(String[] args) throws InvalidFormatException, FileNotFoundException, IOException { Workbook wb = WorkbookFactory.create(new FileInputStream("C:/Users/Pradeep.HALCYONTEKDC/Desktop/My Data/ExcelFiles/XLS1.xls")); Sheet sheet = wb.getSheet("Retail - All"); Row row=null; Cell cell ; for (int j=0; j&lt; sheet.getLastRowNum()+1; j++) { row = sheet.getRow(j); cell = row.getCell(0); if(cell!=null) { int type = cell.getCellType(); if (type == HSSFCell.CELL_TYPE_STRING) System.out.println(cell.getRichStringCellValue().toString()); else if (type == HSSFCell.CELL_TYPE_NUMERIC) System.out.println(cell.getNumericCellValue()); else if (type == HSSFCell.CELL_TYPE_BOOLEAN) System.out.println( cell.getBooleanCellValue()); else if (type == HSSFCell.CELL_TYPE_BLANK) System.out.println(cell.getColumnIndex() + "] = BLANK CELL"); } } } } </code></pre> <p>Excel column values are</p> <pre><code>79 999861 999861 https://staging.adpcreditsolutions.com /index/contract_decision 9200278 2011/01/17 79 5032944200 IL4-PCC@TEST.COM 1979/12/31 0.00 0.00 </code></pre> <p>But the output I am getting is</p> <pre><code>79.0 999861.0 999861.0 https://staging.adpcreditsolutions.com /index/contract_decision 9200278.0 17-Jan-2011 79.0 5.0329442E9 IL4-PCC@TEST.COM 31-Dec-1979 0.0 0.0 </code></pre> <p>How to read code my above program to read the excel column values as they are? Please help me!!</p> <pre><code>if (type == HSSFCell.CELL_TYPE_NUMERIC) { String stringValue=""+cell.getNumericCellValue(); String[] splitValue=stringValue.split(".0"); System.out.println(splitValue[0]); } </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload