JXL操作Excel（1）

备忘

package com.jzbr.test;import java.io.File;import java.io.IOException;import jxl.Cell;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;@SuppressWarnings("unchecked")public class ExcelTest {public static void main(String[] args) throws BiffException, IOException,RowsExceededException, WriteException {ExcelTest.writeExcel();}// 读取Excel表格public static void readExcel() throws BiffException, IOException {Workbook wb = Workbook.getWorkbook(new File("D:\\test1.xls"));//声明工作簿对象 参数是文件Sheet sheet = wb.getSheet("Sheet1");//获取工作表对象 可以使用名称作为参数 也可以使用下标作为参数(从0开始)int rows = sheet.getRows();int columns = sheet.getColumns();for (int i = 0; i < rows; i++) {for (int j = 0; j < columns; j++) {Cell cell = sheet.getCell(j, i);System.out.println(cell.getContents());}}}// 写入Excel表格public static void writeExcel() throws BiffException, IOException,RowsExceededException, WriteException {// 创建工作簿(WritableWorkbook)对象，打开excel文件，若文件不存在，则创建文件WritableWorkbook wb = Workbook.createWorkbook(new File("D:\\test1.xls"));WritableSheet sheetOne = wb.createSheet("第一个工作簿", 1);// 第一个参数为工作簿的名称，第二个参数为页数  WritableSheet sheetTwo = wb.createSheet("第二个工作簿", 0);Label label1 = new Label(1, 1, "malin");// 第一个参数指定单元格的列数、第二个参数指定单元格的行数，第三个指定写的字符串内容sheetOne.addCell(label1);Label lable2 = new Label(1, 1, "scott");sheetTwo.addCell(lable2);// 打开流，开始写文件  wb.write();// 关闭流wb.close();}// 合并单元格public static void mergeCell() throws IOException, RowsExceededException,WriteException {WritableWorkbook wb = Workbook.createWorkbook(new File("D:\\test1.xls"));WritableSheet sheetOne = wb.createSheet("第一个工作簿", 1);Label label1 = new Label(0, 0, "test1");Label label2 = new Label(3, 1, "我是合并后的单元格！");sheetOne.addCell(label1);sheetOne.addCell(label2);sheetOne.mergeCells(3, 1, 9, 2);// 参数说明，前两个参数为待合并的起始单元格位置，后两个参数用来指定结束单元格位置（列和行）wb.write();wb.close();}}