package com.practice.excel;
import java.io.File;
import java.io.IOException;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
/**
* 利用java excel向excel中写入数据
* @author lb
*
*/
public class JExcelTest {
public static void main(String []args){
File f = new File("D:"+File.separator+"test.xls");
String str[][] = {{"姓名","罗彬"},{"email","2362688032@qq.com"}};
try {
WritableWorkbook workbook = Workbook.createWorkbook(f);
WritableSheet sheet = workbook.createSheet("测试表", 0);
Label label = null;
for(int i=0;i<str.length;i++){
for(int j=0;j<str[i].length;j++){
label = new Label(j,i,str[i][j]);
try {
sheet.addCell(label);
} catch (RowsExceededException e) {
e.printStackTrace();
} catch (WriteException e) {
e.printStackTrace();
}
}
}
workbook.write();
try {
workbook.close();
} catch (WriteException e) {
System.out.println("关闭出现异常!!");
}
} catch (IOException e) {
e.printStackTrace();
}
}
}
package com.practice.excel;
import java.io.File;
import java.io.IOException;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
/**
*
* 利用JExcel读取excel内容
* @author lb
*
*/
public class JExcelTest {
public static void main(String []args){
Workbook workbook = null;
try {
workbook = Workbook.getWorkbook(new File("D:"+File.separator+"test.xls"));
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
Sheet sheet[] = workbook.getSheets();
String lab = null;
for(int a=0;a<sheet.length;a++){
for(int i=0;i<sheet[a].getRows();i++){
for(int j=0;j<sheet[a].getColumns();j++){
lab = sheet[a].getCell(j,i).getContents();
System.out.print(lab+"、");
}
System.out.println();
}
}
}
}
Jexcel对读写excel非常方便,但是相对于POI来说还是逊色了些。