Writing Excel files using Java--JXL

To operate the Excle file, first download the Jxl.jar file, the version I use is 2.6. Download Address: http://www.andykhan.com/jexcelapi/download.html.

Java Excel is an open source project through which Java developers can read the contents of Excel files, create new Excel files, and update existing Excel files. Using this API non-Windows operating systems can also work with Excel data tables through a pure Java application. Because it is written in Java, we can use the JSP, servlet to invoke the API to implement the access to Excel datasheet in the Web application.

1. Create an XLS file

OutputStream os=new FileOutputStream ("C:\\test.xls");

2, the establishment of working papers

Writableworkbook WWB = workbook.createworkbook (OS);

3, if this file already exists, then we can add a sheet in this file in order to separate from the previous data;
Jxl.write.WritableSheet ws = Wwb.createsheet ("Sheet 1", 0);
The previous argument in the Createsheet method is the sheet name, followed by the sheet number to be manipulated.

4. Write Data

(1) The simplest type of character data

Label label = new label (0, 0, "This is a label cell", WCFF);
Ws.addcell (label);
There are three parameters in the label () method
The first is to represent the number of columns,
The second is to represent the number of rows,
The third represents what to write
The fourth option is to enter the style inside the label
Then write the content into the sheet by writing the sheet method Addcell.

Font style:

Writablefont wf = new Writablefont (Writablefont.times, Writablefont.bold, true);
Writablefont () method in the parameter description:
This method is a container that can be put in a lot of properties
The first: Times is the font size, he wrote is 18
The second: bold is to determine if it is italic and to select True as italic
Third: ARIAL
Fourth: Underlinestyle.no_underline underline
Fifth: Jxl.format.Colour.RED font color is red

Writablecellformat WCFF = new Writablecellformat (WF);

(2) Add a number object with formatting
NumberFormat NF = new NumberFormat ("#.##");

(3) Add Number Object

(3.1) Display the number Object data format

NumberFormat NF = new NumberFormat ("#.##");

Writablecellformat WCFN = new Writablecellformat (NF);

Number LABELNF = new number (1,1,3.1415926,WCFN);

Ws.addcell (LABELNF);

Number () method parameter description:

The first two represents the position of the input

The third represents what is entered

(4) Adding a Boolean object

Boolean Labelb = new Boolean (0,2,false);

Ws.addcell (LABELB);

(5) Add a DateTime object

DateTime Labeldt = new DateTime (0,3,new java.util.Date ());

Ws.addcell (Labeldt);

Parameter descriptions for the DateTime () method

The first two positions that represent the input

The third represents the current time entered

(6) Add a DateFormat object with formatting

This displays all information about the current time, including the date and hour of the month.

DateFormat df = new DateFormat ("dd MM yyyy hh:mm:ss");

Writablecellformat wcfdf = new Writablecellformat (DF);

DateTime LABELDTF = new DateTime (1,3,new java.util.Date (), WCFDF);

Ws.addcell (LABELDTF);

(7) Add an object with font color formatting

Writablefont WFC = new Writablefont (writablefont.arial, Writablefont.no_bold, False,underlinestyle.no_underline, colour.red);

Writablecellformat WCFFC = new Writablecellformat (WFC);

Import= "jxl.format.*

Writablefont WFC = new Writablefont (Writablefont.arial,20,writablefont.bold,false,underlinestyle.no_underline, Jxl.format.Colour.GREEN);

(8) Set cell style

Writablecellformat WCFFC = new Writablecellformat (WFC);

Wcffc.setbackground (colour.red);//Set cell color to red

WCFFC = new Label (6,0, "I Love", WCFFC);

The simplest example of a program:

/*

* Created on 2007-12-19

*

* To change the template for this generated file go

* window> Preferences> Java> Code generation> Code and Comments

*/

Package beans;

Import java.io.*;

Import Java.util.Vector;