与上一篇的POI不同, Java Excel小巧 易用 跨平台,好像目前只支持.xls(Excel2003)格式,这就比较不爽
首先下载jar包jxl.jar
只要加入jxl.jar就好了,不需要其他jar包
与上一篇类似写一个工具类,这次是本人自己写的借鉴上个工具类简介的模式代码如下:
可与上篇对比观看,与数据库连接就不说了,
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;
public class JxlReadWriteExcelUtil {
public static void read(String filePath) throws IOException, BiffException {
Workbook rwb=Workbook.getWorkbook(new File(filePath));
Sheet rs=rwb.getSheet(0);//或者rwb.getSheet(0)
int clos=rs.getColumns();//得到所有的列
int rows=rs.getRows();//得到所有的行
System.out.println(clos+" rows:"+rows);
for (int i = 1; i < rows; i++) {
for (int j = 0; j < clos; j++) {
String a = rs.getCell(j++, i).getContents();//默认最左边编号也算一列 所以这里得j++
System.out.print(a + " ");
}
System.out.println("");
}
}
public static void write(String outPath) throws Exception {
WritableWorkbook wwb = null;
// 创建可写入的Excel工作簿
String fileName = outPath;
File file=new File(fileName);
if (!file.exists()) {
file.createNewFile();
}
//以fileName为文件名来创建一个Workbook
wwb = Workbook.createWorkbook(file);
// 创建工作表
WritableSheet ws = wwb.createSheet("Test Shee 1", 0);
// 循环写入行列数据
for (int i = 0; i < 5; i++) {
for(int j = 0;j < 5; j++){
Label label= new Label(i, j,"哈哈");
ws.addCell(label);
}
}
//写进文档
wwb.write();
// 关闭Excel工作簿对象
wwb.close();
}
public static void main(String[] args) {
try {
JxlReadWriteExcelUtil.write("D:" + File.separator + "hh.xls");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
JxlReadWriteExcelUtil.read("D:" + File.separator + "hh.xls");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
注意不要引错包,感觉不错的顶下