1.所需工具
jxl.jar是通过java操作excel表格的工具类库,在写入和读取Excek表格时我们要使用此库。
下载地址:http://jxl.sourceforge.net/
2.导入方法
在Eclipse开发环境下,在Project下,新建lib文件夹,将jar包复制,之后鼠标右键,选择Build Path。如图:
3.代码实例
(1)创建Excel文件,并写入数据
import java.io.*;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
/*
* 创建Excel表格,并写入数据
*/
public class Demo1 {
public static void main(String args[]) throws Exception
{
//创建excel文件
File file = new File("d://test.xls");
file.createNewFile();
//创建工作簿
WritableWorkbook workbook = Workbook.createWorkbook(file);
WritableSheet sheet = workbook.createSheet("用户管理", 0);
//设置标题
String[] titles = {"编号","账号","密码"};
//单元格
Label label = null;
//设置列名
for(int i = 0; i < titles.length; i++)
{
label = new Label(i,0,titles[i]);
//添加单元格
sheet.addCell(label);
}
//模拟数据库导入数据
for(int i = 1; i <= 8; i++)
{
//添加编号
label = new Label(0,i,i+" ");
sheet.addCell(label);
//添加账号
label = new Label(1,i,"11111"+i);
sheet.addCell(label);
//添加密码
label = new Label(2,i,"12345"+i);
sheet.addCell(label);
}
//写入数据
workbook.write();
//关闭工作簿
workbook.close();
}
}
运行结果:
(2)读取Excel表格数据
import java.io.*;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
/*
* 读取Excel表格数据
*/
public class Demo2 {
public static void main(String args[]) throws Exception
{
//创建WorkBook
Workbook workbook = Workbook.getWorkbook(new File("d://test.xls"));
//获取工作表
Sheet sheet = workbook.getSheet(0);
//读取数据
System.out.println("行数:"+sheet.getRows());
System.out.println("列数:"+sheet.getColumns());
for(int i = 0; i < sheet.getRows(); i++)
{
for(int j = 0; j < sheet.getColumns(); j++)
{
Cell cell = sheet.getCell(j,i);
System.out.print(cell.getContents()+" ");
}
System.out.println();
}
}
}
运行结果: