CODEWITHSUNDEEP
javaexcelapache-poi
Sadesh Kumar N
Sadesh Kumar N

Reputation: 2062

converting a numeric cell type into a text cell type in ms excel document without changing contents of the cell using open office

How to convert a numeric cell type into a text cell type in ms excel document without changing contents of the cell using open office. This cell value is then accessed using java (POI JAR getRichStringCellValue() method of HSSFCELL Object).

Upvotes: 1

Views: 1678

Answers (1)

True Soft
True Soft

Reputation: 8796

Try this:

HSSFWorkbook wb = ...;
DataFormat format = wb.createDataFormat();

HSSFCellStyle cellStyle = wb.createCellStyle();
style.setDataFormat(format.getFormat("@")); // or "text"
cell.setCellStyle(cellStyle);

Upvotes: 1

Related Questions