JAVA Excel Demo
所需JAR: jxl.jar<div style="border-right: #cccccc 1px solid; padding-right: 5px; border-top: #cccccc 1px solid; padding-left: 4px; font-size: 13px; padding-bottom: 4px; border-left: #cccccc 1px solid; width: 98%; padding-top: 4px; border-bottom: #cccccc 1px solid; background-color: #eeeeee;">package exceldemo.BO;
import java.io.InputStream;
import java.io.FileInputStream;
import java.io.*;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.Sheet;
import jxl.Cell;
import jxl.write.WritableWorkbook;
import jxl.write.WritableSheet;
import jxl.write.Label;
import jxl.write.WriteException;
import jxl.write.WritableCell;
import jxl.write.WritableImage;
import jxl.write.WritableFont;
import jxl.format.UnderlineStyle;
import jxl.write.WritableCellFormat;
public class WriteExcel {
public WriteExcel() {
}
/**
* 读取Excel文件
*/
public void readExcel(){
try {
InputStream is = new FileInputStream("c:\\ss.xls");
Workbook workbook = Workbook.getWorkbook(is);//构建Workbook对象, 只读Workbook对象
System.out.println("工作表个数："+workbook.getNumberOfSheets());
Sheet[] sheet = workbook.getSheets();//获取Sheet表
int columns = sheet[0].getColumns();
int rows = sheet[0].getRows();
System.out.println("共"+rows+"行"+columns+"列");
for(int i=0;i<rows;i++){
for(int j=0;j<columns;j++){
Cell cell00 = sheet[0].getCell(j,i);
System.out.print(cell00.getContents());
}
System.out.println("");
}
workbook.close();
is.close();
} catch (FileNotFoundException ex) {ex.printStackTrace();
} catch (BiffException ex) {ex.printStackTrace();
} catch (IOException ex) {ex.printStackTrace();}
}
/**
* 写Excel文件
*/
public void writeExcel(){
File newExcel = new File("c:\\newExcel.xls");
try {
WritableWorkbook wwb = Workbook.createWorkbook(newExcel);//创建可写入的Excel工作薄
//Method 2：将WritableWorkbook直接写入到输出流
/*
OutputStream os = new FileOutputStream(targetfile);
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
*/
WritableSheet ws = wwb.createSheet("TheFirstSheet",0);//创建Excel工作表
//普通文本
Label label00 = new Label(0,0,"derek");
ws.addCell(label00);
WritableCell wc = new Label(1,0,"man");
ws.addCell(wc);
//图片
WritableImage wi = new WritableImage(1,5,1,3,new File("c:\\300.PNG"));//参数表示(列位置，行位置，宽占列数，高占行数，图片路径)
ws.addImage(wi);
//格式化
WritableFont wfc = new WritableFont(WritableFont.ARIAL,10,WritableFont.BOLD,false,UnderlineStyle.DOUBLE,jxl.format.Colour.RED);
WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);
Label labelCFC = new jxl.write.Label(2, 0, "This is a Label Cell", wcfFC);
ws.addCell(labelCFC);
//写入Exel工作表
wwb.write();
//关闭Excel工作薄对象
wwb.close();
} catch (IOException ex) {ex.printStackTrace();}
catch (WriteException ex) {
/** @todo Handle this exception */
}
}
public static void main(String[] args) {
WriteExcel writeexcel = new WriteExcel();
writeexcel.writeExcel();
}
}
页:
[1]