首先下載jxl.jar包,下載地址:http://download.csdn.net/detail/prstaxy/4469935
然后在工程文件上右鍵選Built Path—Configure? Built Path切換到Libraries導入jxl.jar包。
寫入Excel方法示例:
讀取Excel見文章:http://blog.csdn.net/prstaxy/article/details/8119167
?
-
- public?static?void?main(String[]?args)???
- {??
- ????try???
- ????{???
- ????//打開文件? ??
- ????WritableWorkbook?book=?Workbook.createWorkbook(new?File("E:\\GetInfo\\測試.xls"));???
- ????//生成名為“第一頁”的工作表,參數0表示這是第一頁? ??
- ????WritableSheet?sheet=book.createSheet("第一頁",0);???
- ????//在Label對象的構造子中指名單元格位置是第一列第一行(0,0)? ??
- ????//以及單元格內容為test? ??
- ????Label?label=new?Label(0,0,"測試");???
- ????//將定義好的單元格添加到工作表中? ??
- ????sheet.addCell(label);????
- ????jxl.write.Number?number?=?new?jxl.write.Number(1,0,789.123);???
- ????sheet.addCell(number);???
- ????jxl.write.Label?s=new?jxl.write.Label(1,?2,?"三十三");??
- ????sheet.addCell(s);???
- ????//寫入數據并關閉文件? ??
- ????book.write();???
- ????book.close();?//最好在finally中關閉,此處僅作為示例不太規范 ??
- ????}??
- ????catch(Exception?e)???
- ????{???
- ????????System.out.println(e);???
- ????}???
- }??