Java implementation Export Excel table POI

1. Import the relevant JAR package first

2.student.java

2. Import Java.util.Date;
6. Public class Student
8. {
10. private int id;
12. private String name;
14. private int age;
16. private Date birth;
20. Public Student ()
22. {
24. }
28. Public Student (int id, String name, int. Age, Date birth)
30. {
32. this.id = ID;
34. this.name = name;
36. this.age = age;
38. This.birth = birth;
40. }
44. public int getId ()
46. {
48. return ID;
50. }
54. public void setId (int id)
56. {
58. this.id = ID;
60. }
64. Public String getName ()
66. {
68. return name;
70. }
74. public void SetName (String name)
76. {
78. this.name = name;
80. }
84. public int getage ()
86. {
88. return age;
90. }
94. public void Setage (int.)
96. {
98. this.age = age;
100. }
104. Public Date Getbirth ()
106. {
108. return birth;
110. }
114. public void Setbirth (Date birth)
116. {
118. This.birth = birth;
120. }
124. }

3.createsimpleexceltodisk.java

2. Import Java.io.FileOutputStream;
4. Import Java.text.SimpleDateFormat;
6. Import java.util.ArrayList;
8. Import java.util.List;
12. Import Org.apache.poi.hssf.usermodel.HSSFCell;
14. Import Org.apache.poi.hssf.usermodel.HSSFCellStyle;
16. Import Org.apache.poi.hssf.usermodel.HSSFRow;
18. Import Org.apache.poi.hssf.usermodel.HSSFSheet;
20. Import Org.apache.poi.hssf.usermodel.HSSFWorkbook;
24. Public class Createsimpleexceltodisk
26. {
28. /** 
30. * @ Function: Manually build an excel in a simple format
32. */
34. private static list<student> getstudent () throws Exception
36. {
38. List List = new ArrayList ();
40. SimpleDateFormat df = new SimpleDateFormat ("Yyyy-mm-dd");
44. Student user1 = new Student (1, "Zhang San", + , Df.parse ("1997-03-12"));
46. Student user2 = new Student (2, "John Doe", + , Df.parse ("1996-08-12"));
48. Student User3 = new Student (3, "Harry", + , Df.parse ("1985-11-12"));
50. List.add (user1);
52. List.add (User2);
54. List.add (USER3);
58. return list;
60. }
64. public static void Main (string[] args) throws Exception
66. {
68. //First step, create a webbook, corresponding to an Excel file
70. Hssfworkbook WB = new Hssfworkbook ();
72. ///second step, add a sheet in WebBook, corresponding to the sheet in the Excel file
74. Hssfsheet sheet = wb.createsheet ("student form One");
76. ///step three, add the header line No. 0 to the sheet, and note that the older POI has a limit on the number of rows in Excel short
78. Hssfrow row = Sheet.createrow ((int) 0);
80. //Fourth step, create the cell and set the value header to center the table header
82. Hssfcellstyle style = Wb.createcellstyle ();
84. Style.setalignment (Hssfcellstyle.align_center); //Create a center format
88. Hssfcell cell = Row.createcell ((short) 0);
90. Cell.setcellvalue ("School Number");
92. Cell.setcellstyle (style);
94. Cell = Row.createcell ((short) 1);
96. Cell.setcellvalue ("name");
98. Cell.setcellstyle (style);
100. Cell = Row.createcell ((short) 2);
102. Cell.setcellvalue ("age");
104. Cell.setcellstyle (style);
106. Cell = Row.createcell ((short) 3);
108. Cell.setcellvalue ("Birthday");
110. Cell.setcellstyle (style);
114. //Fifth, write the data from the database in the actual application of the physical data,
116. List List = Createsimpleexceltodisk.getstudent ();
120. For (int i = 0; i < list.size (); i++)
122. {
124. row = Sheet.createrow ((int) i + 1);
126. Student stu = (Student) list.get (i);
128. //Fourth step, create a cell and set the value
130. Row.createcell ((short) 0). Setcellvalue ((Double) Stu.getid ());
132. Row.createcell ((short) 1). Setcellvalue (Stu.getname ());
134. Row.createcell ((short) 2). Setcellvalue ((Double) Stu.getage ());
136. Cell = Row.createcell ((short) 3);
138. Cell.setcellvalue (new SimpleDateFormat ("YYYY-MM-DD"). Format (Stu
140. . Getbirth ()));
142. }
144. //Sixth, save the file to the specified location
146. Try
148. {
150. FileOutputStream fout = new FileOutputStream ("E:/students.xls");
152. Wb.write (Fout);
154. Fout.close ();
156. }
158. catch (Exception e)
160. {
162. E.printstacktrace ();
164. }
166. }
168. }

Java implementation Export Excel table POI