jxl 新版电子表格_Java实现Excel表格操作--API:jxl(示例代码)

packagecom.jxl.excel;importjava.io.File;importjxl.Cell;importjxl.Sheet;importjxl.Workbook;importjxl.write.Label;importjxl.write.Number;importjxl.write.WritableCellFormat;importjxl.write.WritableFont;importjxl.write.WritableImage;importjxl.write.WritableSheet;importjxl.write.WritableWorkbook;/*** Excel表格操作

*

*@authorAdministrator

**/

public classUtils {public static voidmain(String[] args) {//createXLS();

readXLS();

}//创建表格

public static voidcreateXLS() {try{//打开文件

WritableWorkbook book = Workbook.createWorkbook(new File("test.xls"));//生成名为“第一页”的工作表，参数0表示这是第一页

WritableSheet sheet = book.createSheet("first page", 0);//在Label对象的构造子中指名单元格位置是第一列第一行(0,0)单元格内容为test

Label label = new Label(0, 0, "test");//将定义好的单元格添加到工作表中

sheet.addCell(label);//生成一个保存数字的单元格,

Number number = new Number(1, 0, 789);

sheet.addCell(number);//写入数据并关闭文件

book.write();

book.close();

}catch(Exception e) {

e.printStackTrace();

}

}//读取Excel

public static voidreadXLS() {try{

Workbook book= Workbook.getWorkbook(new File("test.xls"));

Sheet sheet= book.getSheet(0);

Cell cell= sheet.getCell(0, 0);

String result=cell.getContents();

System.out.println(result);

book.close();

}catch(Exception e) {

e.printStackTrace();

}

}//修改Excel的类，添加一个工作表

public static voidupdateXLS() {try{

Workbook wb= Workbook.getWorkbook(new File("test.xls"));//打开一个文件的副本，并且指定数据写回到原文件

WritableWorkbook book = Workbook.createWorkbook(new File("test.xls"), wb);//添加一个工作表

WritableSheet sheet = book.createSheet("第二页", 1);

sheet.addCell(new Label(0, 0, "第二页的测试数据"));

book.write();

book.close();

}catch(Exception e) {

e.printStackTrace();

}

}//操作图片

public static void addImage() throwsException {

WritableWorkbook wwb= Workbook.createWorkbook(new File("test.xls"));

WritableSheet ws= wwb.createSheet("Test Sheet 1", 0);

File file= new File("test.png");

WritableImage image= new WritableImage(1, 4, 6, 18, file);

ws.addImage(image);

wwb.write();

wwb.close();

}//单元格合并

public static void mergeSheet(WritableWorkbook book, int sheetIndex, int x, int y, int x1, inty1) {

WritableSheet sheet=book.getSheet(sheetIndex);try{

sheet.mergeCells(x, y, x1, y1);//合并第x列第x行到第x1列第y1行的所有单元格

} catch(Exception e) {

e.printStackTrace();

}

}//列宽行高设置

public static void setColView(WritableSheet sheet, int colIndex, int rowIndex, int colW, introwH) {try{//将第colIndex列的宽度设为colW

sheet.setColumnView(colIndex, colW);//将第rowIndex行的高度设为rowH

sheet.setRowView(rowIndex, rowH);

}catch(Exception e) {

e.printStackTrace();

}

}public static voidsetFont() {

WritableWorkbook book;try{

book= Workbook.createWorkbook(new File("test.xls"));

WritableFont font1= new WritableFont(WritableFont.TIMES, 16, WritableFont.BOLD);//字体为TIMES，字号16，加粗显示

WritableCellFormat format1 = new WritableCellFormat(font1);

//使用了WritableCellFormat类，这个类非常重要，通过它可以指定单元格的各种属性，后面的单元格格式化中会有更多描述

Label label = new Label(0, 0, "data 4 test", format1);

//使用了Label类的构造子，指定了字串被赋予那种格式//把水平对齐方式指定为居中

format1.setAlignment(jxl.format.Alignment.CENTRE);//把垂直对齐方式指定为居中

format1.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//设置自动换行

format1.setWrap(true);

}catch(Exception e) {

e.printStackTrace();

}

}

}