HSSFWorkbook demoWorkBook = new HSSFWorkbook();
HSSFSheet demoSheet = demoWorkBook.createSheet("The World's 500 Enterprises");
HSSFCell cell = demoSheet.createRow(0).createCell(0);
1.设置单元格为文本格式
HSSFCellStyle cellStyle2 = demoWorkBook.createCellStyle();
HSSFDataFormat format = demoWorkBook.createDataFormat();
cellStyle2.setDataFormat(format.getFormat("@"));
cell.setCellStyle(cellStyle2);
第一种:日期格式
cell.setCellValue(new Date(2008,5,5));
//set date format
HSSFCellStyle cellStyle = demoWorkBook.createCellStyle();
HSSFDataFormat format= demoWorkBook.createDataFormat();
cellStyle.setDataFormat(format.getFormat("yyyy年m月d日"));
cell.setCellStyle(cellStyle);
第二种:保留两位小数格式
cell.setCellValue(1.2);
HSSFCellStyle cellStyle = demoWorkBook.createCellStyle();
cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("0.00"));
cell.setCellStyle(cellStyle);
第三种:货币格式
cell.setCellValue(20000);
HSSFCellStyle cellStyle = demoWorkBook.createCellStyle();
HSSFDataFormat format= demoWorkBook.createDataFormat();
cellStyle.setDataFormat(format.getFormat("¥#,##0"));
cell.setCellStyle(cellStyle);
第四种:百分比格式
cell.setCellValue(20);
HSSFCellStyle cellStyle = demoWorkBook.createCellStyle();
cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("0.00%"));
cell.setCellStyle(cellStyle);
此种情况跟第二种一样
第五种:中文大写格式
cell.setCellValue(20000);
HSSFCellStyle cellStyle = demoWorkBook.createCellStyle();
HSSFDataFormat format= demoWorkBook.createDataFormat();
cellStyle.setDataFormat(format.getFormat("[DbNum2][$-804]0"));
cell.setCellStyle(cellStyle);
第六种:科学计数法格式
cell.setCellValue(20000);
HSSFCellStyle cellStyle = demoWorkBook.createCellStyle();
cellStyle.setDataFormat( HSSFDataFormat.getBuiltinFormat("0.00E+00"));
cell.setCellStyle(cellStyle);
The following is a list of built-in formats provided is POI 3.0:
S/No.
Format
VlaueS/NoFormat
Value 1General012h:mm AM/PM0x1220113h:mm:ss AM/PM0x1330.00214h:mm0x144#,##0315h:mm:ss0x155#,##0.00416m/d/yy h:mm0x166($#,##0_);($#,##0)517(#,##0_);[Red](#,##0)0x267($#,##0_);[Red]($#,##0)618(#,##0.00_);(#,##0.00)0x278($#,##0.00);($#,##0.00)719(#,##0.00_);[Red](#,##0.00)0x289($#,##0.00_);[Red]($#,##0.00)820_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)0x29100%921_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)0x2a110.00%0xa22_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)0x2b120.00E+000xb23_($*#,##0.00_);_($*(#,##0.00);_($*\"-\"??_);_(@_)0x2c13# ?/?0xc24mm:ss0x2d14# ??/??0xd25[h]:mm:ss0x2e15m/d/yy0xe26mm:ss.00x2f16d-mmm-yy0xf27##0.0E+00x3017d-mmm0x1028@-This is text format.0x3118mmm-yy0x1129text-Alias for "@"0x31Note:-The values from 0x17 to 0x24 are reserved for international and undocumented and 0x25 is for "(#,##0_);(#,##0)".
转自:http://blog.sina.com.cn/s/blog_6793ffde0101l121.html
0 0