Java uses POI to parse more than 2007 Excel tables

From http://hao0610.iteye.com/blog/1160678

Use POI to parse the XLS and xlsx of Excel.

Resolve XLS:

Java code

2. Package xls;
6. Import Java.io.FileInputStream;
8. Import java.io.IOException;
10. Import Java.io.InputStream;
12. Import Org.apache.poi.hssf.usermodel.HSSFCell;
14. Import Org.apache.poi.hssf.usermodel.HSSFRow;
16. Import Org.apache.poi.hssf.usermodel.HSSFSheet;
18. Import Org.apache.poi.hssf.usermodel.HSSFWorkbook;
22. Public class Xlsmain {
26. public static void Main (string[] args) throws IOException {
28. Xlsmain Xlsmain = new Xlsmain ();
32. Xlsmain.readxls ();
34. }
38. private void Readxls () throws ioexception{
40. InputStream is = new FileInputStream ( "D:\\excel\\xls_test2.xls");
42. Hssfworkbook Hssfworkbook = new Hssfworkbook (IS);
46. //Cycle sheet sheet
48. For (int numsheet = 0; numsheet < hssfworkbook.getnumberofsheets (); numsheet++) {
50. Hssfsheet Hssfsheet = Hssfworkbook.getsheetat (Numsheet);
52. if (Hssfsheet = = null) {
54. continue;
56. }
60. //Cycle rows row
62. For (int rowNum = 0; rowNum <= hssfsheet.getlastrownum (); rownum++) {
64. Hssfrow Hssfrow = Hssfsheet.getrow (RowNum);
66. if (Hssfrow = = null) {
68. continue;
70. }
74. //Cyclic column cell
76. For (int cellnum = 0; cellnum <= hssfrow.getlastcellnum (); cellnum++) {
78. Hssfcell Hssfcell = Hssfrow.getcell (cellnum);
80. if (Hssfcell = = null) {
82. continue;
84. }
88. System.out.print ("" + GetValue (Hssfcell));
90. }
92. System.out.println ();
94. }
96. }
98. }
102. @SuppressWarnings ("static-access")
104. private String GetValue (Hssfcell hssfcell) {
106. if (hssfcell.getcelltype () = = Hssfcell.cell_type_boolean) {
108. return string.valueof (Hssfcell.getbooleancellvalue ());
110. }Else if (hssfcell.getcelltype () = = hssfcell.cell_type_numeric) {
112. return string.valueof (Hssfcell.getnumericcellvalue ());
114. }else{
116. return string.valueof (Hssfcell.getstringcellvalue ());
118. }
120. }
124. }

Resolve xlsx:

Java code

2. Package xlsx;
6. Import java.io.IOException;
8. Import Org.apache.poi.xssf.usermodel.XSSFCell;
10. Import Org.apache.poi.xssf.usermodel.XSSFRow;
12. Import Org.apache.poi.xssf.usermodel.XSSFSheet;
14. Import Org.apache.poi.xssf.usermodel.XSSFWorkbook;
18. Public class Xlsxmain {
22. public static void Main (string[] args) throws IOException {
24. Xlsxmain Xlsxmain = new Xlsxmain ();
28. Xlsxmain.readxlsx ();
30. }
34. private void readxlsx () throws ioexception{
36. String fileName = "D:\\excel\\xlsx_test.xlsx";
38. Xssfworkbook Xssfworkbook = new Xssfworkbook (FileName);
42. //Cycle sheet sheet
44. For (int numsheet = 0; numsheet < xssfworkbook.getnumberofsheets (); numsheet++) {
46. Xssfsheet Xssfsheet = Xssfworkbook.getsheetat (Numsheet);
48. if (Xssfsheet = = null) {
50. continue;
52. }
56. //Cycle rows row
58. For (int rowNum = 0; rowNum <= xssfsheet.getlastrownum (); rownum++) {
60. Xssfrow Xssfrow = Xssfsheet.getrow (RowNum);
62. if (Xssfrow = = null) {
64. continue;
66. }
70. //Cyclic column cell
72. For (int cellnum = 0; cellnum <= xssfrow.getlastcellnum (); cellnum++) {
74. Xssfcell Xssfcell = Xssfrow.getcell (cellnum);
76. if (Xssfcell = = null) {
78. continue;
80. }
82. System.out.print ("+getvalue (Xssfcell)");
84. }
86. System.out.println ();
88. }
90. }
92. }
96. @SuppressWarnings ("static-access")
98. private String GetValue (Xssfcell xssfcell) {
100. if (xssfcell.getcelltype () = = Xssfcell.cell_type_boolean) {
102. return string.valueof (Xssfcell.getbooleancellvalue ());
104. }Else if (xssfcell.getcelltype () = = xssfcell.cell_type_numeric) {
106. return string.valueof (Xssfcell.getnumericcellvalue ());
108. }else{
110. return string.valueof (Xssfcell.getstringcellvalue ());
112. }
114. }
118. }

Java uses POI to parse more than 2007 Excel tables