Export excel file instance of Java data export function
Tables (reports) often need to be used in programming are mainly excel tables. The following is the method of writing data into excel tables with Java:
1. Add jar file
Java import / export excel file to import JXL Jar package. The most important thing is that this API is pure Java and does not rely on Windows system. Even if it runs under Linux, it can correctly process Excel files. Download address: http://www.andykhan.com/jexcelapi/
2. JXL's understanding of Excel tables
See: http://www.jb51.net/article/68631.htm
The following figure shows the excel file t.xls to be created. Coordinates (column, row): role (0,0), teaching assistant (0,3), function description (3,0), uc22 (1,4).
3. The Java code generates the t.xls file shown in the above picture according to the data in the program