JXL usage(国外英文资料).docVIP

JXL usage(国外英文资料) JXL. Jar USES the tools library of the excel table through Java Supports all versions of Excel 95-2000 Generate the Excel 2000 standard format Supports fonts, Numbers, and date operations Ability to modify the cell properties Supports images and charts It should be said that the above functions have been able to approximate our needs. The key thing is that the API is pure Java and doesnt rely on Windows, and even if it runs under Linux, it can handle Excel files correctly. In addition, the API has limited support for graphics and graphs, and only identifies the PNG format. Set up environment To unpack the downloaded file, get the JXL. Jar, put in the classpath, and the installation is complete. (a large load is always not good, I want to add: you downloaded JXL. Jars in the D: \ JAVA \ jre \ lib \ ext is JDK1.6 (I) with respect to OK. I believe in the TOMCAT configuration also need to put the related three packages in there.) Basic operation Create a file An Excel file called test data.xls is generated, and the first worksheet is named first page, which is roughly the following: Code (CreateXLS. Java) : / / generate Excel classes Import Java. Import JXL. Import JXL. Public class CreateXLS { Public static void main (String args) { The try { / / open file WritableWorkbook book = Workbook. CreateWorkbook ( test XLS ); / / generate a worksheet called page 1, which indicates that this is the first page WritableSheet sheet = book.createsheet ( first page , 0); / / the constructor of the Label object is the first row (0, 0) in the first column. / / the cell content is test Label Label = new Label (0, 0, test); / / add the defined cells to the worksheet () / * generate a cell that holds the number You must use the full package path of Number, otherwise there is a syntax ambiguity The cell location is the second column, the first row, which is 789.123 * / (1) its new JXL. (number) / / write the data and close the file () () } catch (Exception e) { A. out.p