Java Operations Excel table

The interaction between Java encoding and Excel is very much used in actual development, and today it is simple to use JXL to realize their interaction. Nonsense not much to say, direct code!

First, you have to import the JXL rack package:

1. Writing data to Excel

2. Package com.easyteam.yc01;
6. Import Java.io.File;
8. Import JXL. Workbook;
10. Import Jxl.write.Label;
12. Import Jxl.write.WritableSheet;
14. Import Jxl.write.WritableWorkbook;
20. Public class Operateexcel {
22. Public void Getexcel () throws exception{
24. File File = new file ("D:" +file.separator+"A.xls"); Create a file
26. if (!file.exists ()) {
30. File.createnewfile ();
32. }
36. Writableworkbook workbook=workbook.createworkbook (file); //Create a workbook
38. Writablesheet Sheet=workbook.createsheet ("Sheet1",0); Create sheet
42. String[] title={"id","name","Age"}; Defining header Elements
46. Populating data into Excel
48. for (int i=0;i<title.length;i++) {
50. Label lable1=New Label (I,0,title[i]); Table Header
52. Label lable2=new label (0,i+1,i+""); ID
54. Label lable3=new label (1,i+1,"Zhang San" +i); Name
56. Label lable4=new label (2,i+1,"+i"); Age
60. Sheet.addcell (LABLE1);
62. Sheet.addcell (Lable2);
64. Sheet.addcell (LABLE3);
66. Sheet.addcell (LABLE4);
68. }
70. Workbook.write (); //Write Data
72. Workbook.close (); //Off
80. }
82. }

Test:

1. Package com.easyteam.yc01;
3. Public class Test {
4. Public static void Main (string[] args) throws Exception {
5. Operateexcel op=New Operateexcel ();
6. Op.getexcel ();
7. }
8. }

Test results:

2. Read the data in Excel

2. Package com.easyteam.yc01;
6. Import Java.io.File;
8. Import java.io.IOException;
12. Import JXL. Cell;
14. Import JXL. Sheet;
16. Import JXL. Workbook;
18. Import jxl.read.biff.BiffException;
20. Import Jxl.write.WritableWorkbook;
24. Public class Getexceldata {
26. public void GetData () throws exception{
28. File File = new file ("D:" +file.separator+"A.xls");
30. Workbook workbook=workbook.getworkbook (file); //Get a working thin
32. Sheet Sheet =workbook.getsheet (0); Get sheet
36. int rows = Sheet.getrows (); //number of rows
40. int columns = Sheet.getcolumns (); //Number of columns
44. For (int i=0;i<rows;i++) {
46. For (int j=0;j<columns;j++) {
48. Cell cell= Sheet.getcell (J, I); //Get cell
50. String str=cell.getcontents (); //Get cell contents
52. System.out.print (str+"\ t");
54. }
56. System.out.println ();
58. }
62. }
66. }

Test:

1. Package com.easyteam.yc01;
3. Public class Test1 {
4. Public static void Main (string[] args) throws Exception {
5. Getexceldata ged=New Getexceldata ();
6. Ged.getdata ();
7. }
8. }

Test results:

Java Operations Excel table