Java对excel文件的处理

一、读取excel文件

String targerPath = "d:" + File.separator + "jxl.xls";
Workbook book = Workbook.getWorkbook(new File(targerPath));
// 获得第一个工作表对象
Sheet sheet = book.getSheet(0);
// 得到单元格
for (int i = 0; i < sheet.getColumns(); i++) {
	for (int j = 0; j < sheet.getRows(); j++) {
		Cell cell = sheet.getCell(i, j);   //注：i为列j为行。起始位0.
		System.out.print(cell.getContents() + "  ");
	}
	System.out.println();
}
book.close();

二、创建excel文件

String targerPath = "d:" + File.separator + "sc1409.xls";
// 创建工作簿
WritableWorkbook workbook = Workbook.createWorkbook(new File(targerPath));
// 创建第一页，索引从0开始
WritableSheet sheet = workbook.createSheet("第一页", 0);
// 设置单元格背景色
WritableCellFormat wcf = new WritableCellFormat();
wcf.setBackground(Colour.RED);
// 创建单元格内容
Label label = new Label(1, 1, "", wcf); //写在<span style="font-family: Arial, Helvetica, sans-serif;">第二行</span><span style="font-family: Arial, Helvetica, sans-serif;">第二列</span>
Label label2 = new Label(2, 1, "反倒是");//<span style="font-family: Arial, Helvetica, sans-serif;">第二行</span>第三列
// sheet添加内容
sheet.addCell(label);
sheet.addCell(label2);
workbook.write();
workbook.close();

注：需要导入jxl.jar包，支持后缀为.xls文件