Use the jxl framework to parse Excel files

1. Import the Excel file to the database during project development and apply it to jxl. jar for parsing.

2. as follows

1. Package test;
3. Import java. Io. file;
4. Import java. Io. ioexception;
5. Import java. Io. unsupportedencodingexception;
7. Import javax. servlet. http. httpservletresponse;
8. Import jxl. sheet;
9. Import jxl. workbook;
10. Import jxl. workbooksettings;
11. Import jxl. Read. Biff. biffexception;
12. Import jxl. Write. label;
13. Import jxl. Write. writablesheet;
14. Import jxl. Write. writableworkbook;
15. Import jxl. Write. writeexception;
17. Public class jxltest {
18. Public static void main (string [] ARGs ){
19. (New jxltest (). excelread ();
20. }
21. Public void excelread (){
22. File file = new file ("D: // cicc825.xls ");
23. Try {
24. Workbooksettings = new workbooksettings ();
25. Workbooksettings. setencoding ("ISO-8859-1"); // key code to address Chinese garbled characters
26. Workbook book = Workbook. getworkbook (file, workbooksettings );
27. // Workbook book = Workbook. getworkbook (File );
28. Sheet sheet = book. getsheet (0 );
29. Int ROW = sheet. getrows ();
30. Int column = sheet. getcolumns ();
31. For (INT I = 0; I <row; I ++ ){
32. For (Int J = 0; j <column; j ++ ){
33. System. Out. println (sheet. getcell (J, I). getcontents ());
34. }
35. }
36. } Catch (biffexception e ){
37. E. printstacktrace ();
38. } Catch (ioexception e ){
39. E. printstacktrace ();
40. }
41. }
43. Public void excelwrite (httpservletresponse response ){
44. Long time = system. currenttimemillis (); // use the current system time as the default table name
45. String name = string. valueof (time );
46. Name = "position ";
47. String pathname = Name + ". xls ";
48. Try {
49. Pathname = new string (pathname. getbytes (), "ISO-8859-1 ");
50. } Catch (unsupportedencodingexception e ){
51. E. printstacktrace ();
52. }
53. // Obtain the Save path and table name in the pop-up save box.
54. Response. setcontenttype ("application/OCTET-STREAM ");
55. Response. setheader ("content-disposition", "attachment; filename =/" "+ pathname + "/"");
57. Writableworkbook workbook;
58. Workbooksettings = new workbooksettings ();
59. Workbooksettings. setencoding ("gb2312 ");
60. Try {
61. Workbook = Workbook. createworkbook (response. getoutputstream (), workbooksettings );
62. Writablesheet Ws = Workbook. createsheet ("Sheet 1", 0 );
63. WS. setcolumnview (0, 22 );
64. Label cell = NULL;
65. For (INT I = 0; I <2; I ++ ){
66. Cell = new label (0, I + 1, "ID ");
67. WS. addcell (cell );
68. Cell = new label (1, I + 1, "name ");
69. WS. addcell (cell );
71. }
72. Workbook. Write ();
73. Workbook. Close (); // be sure to close it; otherwise, no Excel is saved;
74. } Catch (ioexception e ){
75. E. printstacktrace ();
76. } Catch (writeexception e ){
77. E. printstacktrace ();
78. }
80. }
83. }

3. The parsing process is relatively simple.