How do I use Apache poi to manipulate Excel files-----how do i insert a new row of data into an existing Excel file?

In the first section of the poi, we provide two simple examples of how to create a new workbook with Apache poi, and another example is to create a new worksheet with Apache Poi. So in this section, i'll show you how to insert a new row of data into an existing Excel file using Apache Poi. For specific code, See the example BELOW.

[java]View PlainCopy

2. Import java.io.File;
4. Import java.io.FileInputStream;
6. Import java.io.FileNotFoundException;
8. Import java.io.FileOutputStream;
10. Import java.io.IOException;
14. Import org.apache.poi.xssf.usermodel.XSSFCell;
16. Import org.apache.poi.xssf.usermodel.XSSFRow;
18. Import org.apache.poi.xssf.usermodel.XSSFSheet;
20. Import org.apache.poi.xssf.usermodel.XSSFWorkbook;
24. Public class Creatrowtest {
26. //the current file already exists
28. private String Excelpath = "d:\\exceltest\\comments.xlsx";
30. //insert in from the first few lines
32. private int insertstartpointer = 3;
34. //insert This row of data in the work sheet of the current workbook
36. private String sheetname = "Sheet1";
40. /** 
42. * Total Entrance method
44. */
46. public static void main (string[] Args) {
48. Creatrowtest CRT = new Creatrowtest ();
50. Crt.insertrows ();
52. }
54. /** 
56. * Entry method for inserting a new row of data into an existing Excel file
58. */
60. public void insertrows () {
62. Xssfworkbook WB = Returnworkbookgivenfilehandle ();
64. Xssfsheet Sheet1 = Wb.getsheet (sheetname);
66. Xssfrow row = CreateRow (sheet1, insertstartpointer);
68. Createcell (row);
70. Saveexcel (wb);
74. }
76. /** 
78. * Save Work Book
80. * @param WB
82. */
84. private void Saveexcel (xssfworkbook wb) {
86. FileOutputStream fileout;
88. try {
90. Fileout = new FileOutputStream (excelpath);
92. Wb.write (fileout);
94. Fileout.close ();
96. } catch (filenotfoundexception e) {
98. E.printstacktrace ();
100. } catch (ioexception e) {
102. E.printstacktrace ();
104. }
108. }
110. /** 
112. * Create rows in the row to enter or leave cells
114. * @param row
116. * @return
118. */
120. private Xssfcell Createcell (xssfrow Row) {
122. Xssfcell cell = Row.createcell ((short) 0);
124. Cell.setcellvalue (999999);
126. Row.createcell (1). setcellvalue (1.2);
128. Row.createcell (2). setcellvalue ("this is a string cell");
130. return cell;
132. }
134. /** 
136. * Get a POI object for an existing workbook
138. * @return
140. */
142. Private Xssfworkbook returnworkbookgivenfilehandle () {
144. Xssfworkbook WB = null;
146. FileInputStream FIS = null;
148. File F = new file (excelpath);
150. try {
152. if (f! = Null) {
154. FIS = new FileInputStream (f);
156. WB = New Xssfworkbook (fis);
158. }
160. } catch (Exception e) {
162. return null;
164. } finally {
166. if (fis! = Null) {
168. try {
170. Fis.close ();
172. } catch (ioexception e) {
174. E.printstacktrace ();
176. }
178. }
180. }
182. return wb;
184. }
186. /** 
188. * Find the number of rows to insert and create a new POI Row object
190. * @param sheet
192. * @param rowIndex
194. * @return
196. */
198. private Xssfrow createrow (xssfsheet sheet, Integer RowIndex) {
200. Xssfrow row = null;
202. if (sheet.getrow (rowIndex) = Null) {
204. int lastrowno = Sheet.getlastrownum ();
206. Sheet.shiftrows (rowIndex, lastrowno, 1);
208. }
210. row = Sheet.createrow (rowIndex);
212. return row;
214. }
222. }

How do I use Apache poi to manipulate Excel files-----how do i insert a new row of data into an existing Excel file?