JAVA学习提高之－－－－JAVA EXCEL API及JAVA 操作Excel（一）

最近在做JAVA操作CSV文件相关功能，顺序把JAVA操作EXCEL的相关功能学习一下
http://www-128.ibm.com/developerworks/cn/java/l-javaExcel/index.html?n-j-01231
一文对使用JAVA EXCEL API对EXCEL进行操作做了说明

以下是API的主页：
http://jexcelapi.sourceforge.net/
以下是具体的下载路径：
http://sourceforge.net/project/showfiles.php?group_id=79926
今天没有时间对他进行学习了，改天再看。。。先记录到此

可以看下此文：
http://blog.youkuaiyun.com/tingqier/archive/2008/10/15/3079138.aspx
http://kingsui.iteye.com/blog/154712

已转贴到：
http://blog.youkuaiyun.com/luweifeng1983/archive/2008/12/30/3645807.aspx

http://www.iteye.com/topic/240053

下面是我的测试实例：

1. packagecom.bytecode.openexcel.util;
4. importjava.io.File;
5. importjava.io.IOException;
7. importjxl.Cell;
8. importjxl.CellType;
9. importjxl.Sheet;
10. importjxl.Workbook;
11. importjxl.read.biff.BiffException;
12. importjxl.write.Label;
13. importjxl.write.Number;
14. importjxl.write.WritableCell;
15. importjxl.write.WritableCellFormat;
16. importjxl.write.WritableFont;
17. importjxl.write.WritableSheet;
18. importjxl.write.WritableWorkbook;
19. importjxl.write.WriteException;
20. importjxl.write.biff.RowsExceededException;
23. publicclassMapExcel{
25. publicstaticvoidmain(String[]args){
27. Stringstep="";
29. WorkbookworkBook=null;
30. Cella=null;
31. StringaStr="";
32. try{
33. step="readthexls";
34. workBook=Workbook.getWorkbook(newFile("c:/myfile.xls"));
35. Sheetsheet=workBook.getSheet(0);
36. //按行读取sheet中的数据
37. intskipLine=0;//可设置跳地读取的行数
38. for(inti=skipLine;i<sheet.getRows();i++){
39. Cell[]cells=sheet.getRow(i);
40. for(intj=0;j<cells.length;j++){
41. a=sheet.getCell(j,i);
42. aStr=a.getContents();
43. System.out.println(aStr);
44. }
45. }
47. //按列读取sheet中的数据
48. for(inti=0;i<sheet.getColumns();i++){
49. Cell[]cells=sheet.getColumn(i);
50. for(intj=0;j<cells.length;j++){
51. a=sheet.getCell(i,j);
52. aStr=a.getContents();
53. System.out.println(aStr);
54. }
55. }
57. }catch(BiffExceptione){
58. e.printStackTrace();
59. }catch(IOExceptione){
60. e.printStackTrace();
61. }finally{
62. workBook.close();
63. }
66. step="writethexls";
67. WritableWorkbookworkBook1=null;
68. try{
69. workBook1=Workbook.createWorkbook(newFile("c:/output.xls"));
70. WritableSheetsheet1=workBook1.createSheet("Firstsheet",0);
71. Labellabel=newLabel(0,2,"Alabelrecord");
72. sheet1.addCell(label);
74. Numbernumber=newNumber(3,4,3.1459);
75. sheet1.addCell(number);
77. step="addformatedcelltoxls";
78. //CreateacellformatforArial10pointfont
80. WritableFontarial10font=newWritableFont(WritableFont.ARIAL,10);
81. WritableCellFormatarial10format=newWritableCellFormat(arial10font);
83. //Createthelabel,specifyingcontentandformat
84. //通过一种格式创建单元格
85. Labellabel2=newLabel(1,0,"Arial10pointlabel",arial10format);
86. sheet1.addCell(label2);
88. //Cellformatsobjectsareshared,somanycellsmayusethesameformatobject,eg.
89. //创建的单元格与前面创建的使用同样的格式
90. Labellabel3=newLabel(2,0,"AnotherArial10pointlabel",arial10format);
91. sheet1.addCell(label3);
93. //可以使用其它的构造函数为某一个单元格单独列一种格式
94. //CreateacellformatforTimes16,boldanditalic
95. WritableFonttimes16font=newWritableFont(WritableFont.TIMES,16,WritableFont.BOLD,true);
96. WritableCellFormattimes16format=newWritableCellFormat(times16font);
98. //Createthelabel,specifyingcontentandformat
99. Labellabel4=newLabel(3,0,"Times16bolditaliclabel",times16format);
100. sheet1.addCell(label4);
102. //相应的还有对数字和日期的格式，具体看JAVAEXCELAPI的指南文件
105. }catch(RowsExceededExceptione1){
106. e1.printStackTrace();
107. }catch(WriteExceptione1){
108. e1.printStackTrace();
109. }catch(IOExceptione1){
110. e1.printStackTrace();
111. }finally{
112. try{
113. workBook1.write();
114. workBook1.close();
115. }catch(IOExceptione){
116. e.printStackTrace();
117. }catch(WriteExceptione){
118. e.printStackTrace();
119. }
120. }
122. step="copyandmodifyxls";
123. WritableWorkbookcopy=null;
124. try{
125. WorkbookworkBook2=Workbook.getWorkbook(newFile("c:/myfile.xls"));
126. //把myfile.xls中的内容（包括所有sheet）复制到out.xls中
127. copy=Workbook.createWorkbook(newFile("c:/out.xls"),workBook2);
129. WritableSheetsheet3=copy.getSheet(1);
130. WritableCellcell3=sheet3.getWritableCell(1,2);
131. if(cell3.getType()==CellType.LABEL){
132. Labell=(Label)cell3;
133. l.setString("modifycell");
134. }
135. }catch(BiffExceptione){
136. e.printStackTrace();
137. }catch(IOExceptione){
138. e.printStackTrace();
139. }finally{
140. try{
141. copy.write();
142. copy.close();
143. }catch(Exceptione){
144. e.printStackTrace();
145. }
146. }
147. }
148. }