poi操作excel设置数据格式,金额数据格式
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.DataFormat;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import java.io.FileOutputStream;
/**
* @ClassName 类名:ExcelDemo10
* @Author作者: hzh
* @Date时间:2018/12/4 16:15
* 设置数据格式
**/
public class ExcelDemo10 {
public static void main(String[] args) throws Exception{
//获得一个工作薄
Workbook wb = new HSSFWorkbook();
//第一个sheet
Sheet sheet = wb.createSheet("第一个sheet");
CellStyle cellStyle;
DataFormat format = wb.createDataFormat();
Row row;
Cell cell;
short rowNum = 0;
short colNum = 0;
row = sheet.createRow(rowNum++);
cell = row.createCell(colNum);
cell.setCellValue(111111111111.25);
cellStyle = wb.createCellStyle();
cellStyle.setDataFormat(format.getFormat("0.0")); //设置数据格式
cell.setCellStyle(cellStyle);
row = sheet.createRow(rowNum++);
cell = row.createCell(colNum);
cell.setCellValue(111111111111.25);
cellStyle = wb.createCellStyle();
cellStyle.setDataFormat(format.getFormat("#,##0.00")); //设置数据格式
cell.setCellStyle(cellStyle);
FileOutputStream fileOutputStream = new FileOutputStream("D://file//数据格式.xls");
wb.write(fileOutputStream);
wb.close();
}
}