Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter.formatCellValue()

Class org.apache.poi.hssf.usermodel.HSSFDataFormatter

Examples of org.apache.poi.hssf.usermodel.HSSFDataFormatter.formatCellValue()

org.apache.poi.hssf.usermodel.HSSFDataFormatter.formatCellValue()

Returns the formatted value of a cell as a String regardless of the cell type. If the Excel format pattern cannot be parsed then the cell value will be formatted using a default format.

When passed a null or blank cell, this method will return an empty String (""). Formulas in formula type cells will not be evaluated.
@param cell The cell @return the formatted cell value as a String

              Date xlDtVal=cellData.getDateCellValue();
              cell.setCellValue(new HSSFRichTextString(CommonUtilities.getDateInddMMYYYYFormat(xlDtVal)));
              break;
            }else{
              HSSFDataFormatter format = new HSSFDataFormatter(); // copies the data in the same format
              cell.setCellValue(new HSSFRichTextString(format.formatCellValue(cellData)));
            }
            break;
          }
        }
      }

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.