Java POI Import Export Excel xsl XSLX

2. Import Java.io.FileInputStream;
4. Import Java.io.FileOutputStream;
6. Import java.io.IOException;
8. Import Java.io.InputStream;
10. Import Java.io.OutputStream;
12. Import Org.apache.poi.hssf.usermodel.HSSFWorkbook;
14. Import Org.apache.poi.ss.usermodel.Cell;
16. Import Org.apache.poi.ss.usermodel.Row;
18. Import Org.apache.poi.ss.usermodel.Sheet;
20. Import Org.apache.poi.ss.usermodel.Workbook;
22. Import Org.apache.poi.xssf.usermodel.XSSFWorkbook;
26. Public class FFF {
28. public static void Main (string[] args) throws IOException {
30. String path = "d:/";
32. String fileName = "Test";
34. String FileType = "xlsx";
36. Writer (path, fileName, FileType);
38. Read (path, fileName, FileType);
40. }
42. private static void writer (string path, String filename,string fileType) throws IOException {
44. //Create Work Document Object
46. Workbook WB = null;
48. if (filetype.equals ("xls")) {
50. WB = new Hssfworkbook ();
52. }
54. Else if (filetype.equals ("xlsx"))
56. {
58. WB = new Xssfworkbook ();
60. }
62. Else
64. {
66. System.out.println ("Your document is not formatted correctly!")    ");
68. }
70. //Create sheet Object
72. Sheet Sheet1 = (Sheet) wb.createsheet ("Sheet1");
74. //Loop write row data
76. For (int i = 0; i < 5; i++) {
78. Row row = (row) sheet1.createrow (i);
80. //Loop write column data
82. For (int j = 0; j < 8; j + +) {
84. Cell cell = Row.createcell (j);
86. Cell.setcellvalue ("test" +j);
88. }
90. }
92. //Create a file stream
94. OutputStream stream = new FileOutputStream (path+filename+".")    +filetype);
96. //Write Data
98. Wb.write (stream);
100. //Close file stream
102. Stream.Close ();
104. }
106. public static void Read (String path,string filename,string fileType) throws IOException
108. {
110. InputStream stream = new FileInputStream (path+filename+".")    +filetype);
112. Workbook WB = null;
114. if (filetype.equals ("xls")) {
116. WB = New Hssfworkbook (stream);
118. }
120. Else if (filetype.equals ("xlsx")) {
122. WB = New Xssfworkbook (stream);
124. }
126. else {
128. System.out.println ("The Excel format you entered is incorrect");
130. }
132. Sheet Sheet1 = Wb.getsheetat (0);
134. For (Row row:sheet1) {
136. For (Cell cell:row) {
138. System.out.print (Cell.getstringcellvalue () +"");
140. }
142. System.out.println ();
144. }
146. }
148. }

Java POI Import Export Excel xsl XSLX