用POI写入Excel

1. importjava.io.FileOutputStream;
2. importjava.io.IOException;
3. importjava.util.Date;
5. //poi-bin-2.5.1-final-20040804.zip
7. importorg.apache.poi.hssf.usermodel.HSSFCell;
8. importorg.apache.poi.hssf.usermodel.HSSFCellStyle;
9. importorg.apache.poi.hssf.usermodel.HSSFDataFormat;
10. importorg.apache.poi.hssf.usermodel.HSSFRow;
11. importorg.apache.poi.hssf.usermodel.HSSFSheet;
12. importorg.apache.poi.hssf.usermodel.HSSFWorkbook;
13. /**
14. *@author
15. *@version创建时间：Dec2,200810:23:24AM
16. *写入Excel
17. */
18. publicclassWriteExcel{
20. publicstaticvoidmain(String[]args)throwsIOException{
22. //工作簿
23. HSSFWorkbookhssfworkbook=newHSSFWorkbook();
24. //创建sheet页
25. HSSFSheethssfsheet=hssfworkbook.createSheet();
26. //sheet名称乱码处理
27. hssfworkbook.setSheetName(0,"研发部门",HSSFWorkbook.ENCODING_UTF_16);
28. //取得第一行
29. HSSFRowhssfrow=hssfsheet.createRow(0);
30. //创建第一个单元格并处理乱码
31. HSSFCellhssfcell_0=hssfrow.createCell((short)0);
32. hssfcell_0.setEncoding(HSSFWorkbook.ENCODING_UTF_16);
33. //对第一个单元格赋值
34. hssfcell_0.setCellValue("研发工程师1");
36. //日期单元格格式处理
37. HSSFCellStylehssfcellstyle=hssfworkbook.createCellStyle();
38. //m/d/yyh:mm
39. hssfcellstyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));
40. //创建第二个单元格
41. HSSFCellhssfcell_1=hssfrow.createCell((short)1);
42. hssfcell_1.setCellValue(newDate());
43. hssfcell_1.setCellStyle(hssfcellstyle);
45. hssfrow.createCell((short)2).setCellValue(true);
46. hssfrow.createCell((short)3).setCellValue(122.00);
48. //输出
49. FileOutputStreamfileoutputstream=newFileOutputStream("d:\\exceltext.xls");
50. hssfworkbook.write(fileoutputstream);
51. fileoutputstream.close();
52. }
53. }