java操作Excel

package test;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;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;public class ExcelDemo {/**根据路径读取Excel文件 * @param filePath */public static void readExcel(String filePath){//创建只读的workbookWorkbook wk=null;try {FileInputStream fis=new FileInputStream(filePath);wk=Workbook.getWorkbook(fis);} catch (FileNotFoundException e) {e.printStackTrace();} catch (BiffException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();} //获取Excel中的第一个sheet，下标从0开始。也可以通过其他重载方法根据名称获得sheetSheet sheet=wk.getSheet(0);//获取sheet中的第一行第一列的值Cell cell=sheet.getCell(1, 6);System.out.println("读取的内容是："+cell.getContents());//关闭wk对象if(wk!=null){wk.close();}}/**根据路径创建Excel * @param filePath */public static void createExcel(String filePath){try {//创建可写入的workbookWritableWorkbook wwb=Workbook.createWorkbook(new File(filePath));//创建可写入sheetWritableSheet ws=wwb.createSheet("mysheet1", 0);//添加label单元格Label label=new Label(1, 1, "测试内容");//将label单元格添加到cell中ws.addCell(label);wwb.write();wwb.close();} catch (IOException e) {e.printStackTrace();} catch (RowsExceededException e) {e.printStackTrace();} catch (WriteException e) {e.printStackTrace();}}/**根据路径修改Excel * @param filePath */public static void updateExcel(String filePath){try {//获得原来的ExcelWorkbook wb=Workbook.getWorkbook(new File(filePath));//创建一个原Excel的副本，并把数据写回WritableWorkbook wwb=Workbook.createWorkbook(new File(filePath), wb);WritableSheet ws=wwb.getSheet(0);Label label=new Label(3,3,"测试更新的内容");ws.addCell(label);wwb.write();wwb.close();} catch (IOException e) {e.printStackTrace();} catch (WriteException e) {e.printStackTrace();} catch (BiffException e) {e.printStackTrace();}}public static void main(String[] args) {String readFilePath="I:/测试读取.XLS";readExcel(readFilePath);String createFilePath="I:/测试创建.XLS";createExcel(createFilePath);String updateFilePath="I:/测试更新.XLS";updateExcel(updateFilePath);}}