JXL (Java Excel API) using method "1"

//    Building Workbook objects, read-only workbook objects
Create workbook directly from a local document
Create workbook from an input stream

Workbook Workbook = null;
try {
Workbook = Workbook.getworkbook (new File ("D://output.xls"));
} catch (Exception e) {
E.printstacktrace ();
}

//Returns the version number of the API being used, which seems to have little effect.
String apiversion = Workbook.getversion ();
System.out.println (apiversion);

//Get the number of worksheets (Sheet) in the workbook (Workbook)
int sheets = Workbook.getnumberofsheets ();
SYSTEM.OUT.PRINTLN (sheets);

Returns an array of sheet (Sheet) objects in a workbook (Workbook)
sheet[] Sheetstringarr = Workbook.getsheets ();
for (int i=0;i<sheetstringarr.length;i++) {
System.out.println (Sheetstringarr[i].getname ()); return to sheet title

System.out.println (Sheetstringarr[i].getcolumns ());//sheet Total number of columns in the page

System.out.println (sheetstringarr[i].getcolumn (0));//sheet An array of columns of a page

System.out.println (Sheetstringarr[i].getrows ());//total number of rows sheet page
System.out.println (Sheetstringarr[i].getrow (0));//sheet An array of rows of a page
}

Get the first sheet table (term: worksheet), two methods
Sheet Sheet = workbook.getsheet (0); Use subscript to get the first page
Sheet Sheet = Workbook.getsheet ("Testcreateexcel"); Get the first page by name

Returns the first row, the value of the first column (0 (the first represents the column), and 0 (the second represents the row)
Cell Cell00=sheet.getcell (0, 0);
System.out.println (Cell00.gettype ()); Gets the type that represents the class (the type of the returned class)
System.out.println (Cell00.getcontents ());//Gets the type that represents the class (returns a string)

Judging the return value type

if (Celltype.date==cell00.gettype ()) {
System.out.print ("Is Date class" +cell00.gettype ());//date ()
}
if (Celltype.label==cell00.gettype ()) {
System.out.print ("is the Label class" +cell00.gettype ());//lable ()
}
if (Celltype.number==cell00.gettype ()) {
System.out.print ("Is Date class" +cell00.gettype ());//number ()
}

Close Object

Workbook.close ();

===============================================================

Like reading an Excel worksheet, you first use the factory method of the Workbook class to create a writable workbook (Workbook) object, and it is important to note that the Workbook can only be created through the factory method provided by the API. Instead of using the Writableworkbook constructor, the constructor for class Writableworkbook is the protected type.

Building Workbook objects, read-only Workbook objects
Method 1: Create a writable Excel workbook
File Tempfile=new file ("D:/output.xls");
Writableworkbook workbook = workbook. Createworkbook (Tempfile);

Create an Excel worksheet (name, location) that requires two parameters, one that is the name of the worksheet, and the other is a bit of the worksheet in the workbook

Reset
Writablesheet sheet = workbook. Createsheet ("Testcreateexcel", 0);

//1. Adding an object with a font formatting
Writablefont HeaderFont = new Writablefont (Writablefont.arial, Writablefont.bold, False, Underlinestyle.no_  Underline, Jxl.format.Colour.BLUE); Font

2. Format
Writablecellformat Headerformat = new Writablecellformat (HeaderFont); //format, please .

3. Add tags (columns, rows, "contents", fonts)

Jxl.write.Label LABELCF = new Jxl.write.Label (1, 0, "This is a Label Cell", Headerformat);

4. Join the worksheet

Sheet.addcell (labelcf );

Set the width of the column (that column, the width number)

Sheet.setcolumnview (1,20);

//write Exel worksheet
Wwb.write ();

//Close the Excel workbook object
Wwb.close ();

=================================================================================

3. Copy and update Excel workbook

Here's a quick introduction to how to update an existing workbook, mainly the following two steps, the first step is to construct a read-only Excel workbook, and the second step is to create a new writable Excel workbook with the Excel workbook that you created, referring to the following code snippet: ( Complete code See EXCELMODIFYING.JAVA)

Create a read-only Excel Workbook object
Jxl. WorkbookRW= Jxl. Workbook.Getworkbook(New File (sourcefile));

Create a writable Excel workbook object
Jxl.write.WritableWorkbookWWB= Workbook.Createworkbook(New File (targetfile), rw);

Read the first sheet
Jxl.write.WritableSheet ws = Wwb.getsheet (0);//Get first page

Get the first Cell object
Jxl.write.WritableCell WC = Ws.getwritablecell (0, 0);//Get first column, first row

Determine the type of cell and make a corresponding conversion
IfWC. GetType () = = Celltype.label)
{
Label L = (label) WC;//(strong turn) gets the label () object of the cell
L.setstring ("The value has been modified.");//Reset Value
}

//write to Excel object
Wwb.write ();

To close a writable Excel object
Wwb.close ();

Close a read-only Excel object
Rw.close ();

Articles reproduced from http://blog.csdn.net/lcz_ptr/article/details/7687657

JXL (Java Excel API) using method "1"