- import java.io.FileOutputStream;
- import java.io.IOException;
- import java.util.Date;
- // poi-bin-2.5.1-final-20040804.zip
- import org.apache.poi.hssf.usermodel.HSSFCell;
- import org.apache.poi.hssf.usermodel.HSSFCellStyle;
- import org.apache.poi.hssf.usermodel.HSSFDataFormat;
- import org.apache.poi.hssf.usermodel.HSSFRow;
- import org.apache.poi.hssf.usermodel.HSSFSheet;
- import org.apache.poi.hssf.usermodel.HSSFWorkbook;
- /**
- * @author
- * @version 创建时间:Dec 2, 2008 10:23:24 AM
- * 写入Excel
- */
- public class WriteExcel {
- public static void main(String[] args) throws IOException {
- //工作簿
- HSSFWorkbook hssfworkbook = new HSSFWorkbook();
- //创建sheet页
- HSSFSheet hssfsheet = hssfworkbook.createSheet();
- //sheet名称乱码处理
- hssfworkbook.setSheetName(0,"研发部门",HSSFWorkbook.ENCODING_UTF_16);
- //取得第一行
- HSSFRow hssfrow = hssfsheet.createRow(0);
- //创建第一个单元格 并处理乱码
- HSSFCell hssfcell_0 = hssfrow.createCell((short)0);
- hssfcell_0.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
- //对第一个单元格赋值
- hssfcell_0.setCellValue("研发工程师1");
- //日期单元格格式处理
- HSSFCellStyle hssfcellstyle = hssfworkbook.createCellStyle();
- //m/d/yy h:mm
- hssfcellstyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));
- //创建第二个单元格
- HSSFCell hssfcell_1 = hssfrow.createCell((short)1);
- hssfcell_1.setCellValue(new Date());
- hssfcell_1.setCellStyle(hssfcellstyle);
- hssfrow.createCell((short)2).setCellValue(true);
- hssfrow.createCell((short)3).setCellValue(122.00);
- //输出
- FileOutputStream fileoutputstream = new FileOutputStream("d://exceltext.xls");
- hssfworkbook.write(fileoutputstream);
- fileoutputstream.close();
- }
- }
用POI写入Excel
最新推荐文章于 2024-07-05 14:30:10 发布