使用jxl 实现对Excel的导入与导出

package com.lin;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;/** * @description java 实现Excel表格的导入与导出 </br> * 使用jxl.jar * @author ljh */public class JavaExcelDemo {public static void main(String[] args) throws RowsExceededException, WriteException {//exportExcel();try {importExcel();} catch (Exception e) {e.printStackTrace();} }    /**     * Exel 的导出     * @throws WriteException     * @throws RowsExceededException     */private static void exportExcel() throws WriteException, RowsExceededException {File file=new File("e:/jxl_text.xls");String[] title={"id号","姓名","性别"};//注意：如果有中文会出现乱码，也会有显示不出来的情况try {file.createNewFile();//创建一个可写工作簿/*WorkbookSettings workbookSettings = new WorkbookSettings();            workbookSettings.setEncoding("ISO-8859-1");*/WritableWorkbook workbook=Workbook.createWorkbook(file);           // WritableWorkbook workbook =Workbook.createWorkbook(file, workbookSettings);//创建一个可写sheet页WritableSheet sheet=workbook.createSheet("第一个sheet1", 0);Label label=null;//第一行，设置列名for (int i = 0; i < title.length; i++) {//第几列第几行，值label=new Label(i, 0, title[i]);sheet.addCell(label);}//追加10行数据//注意：如果有中文会出现乱码，也会有显示不出来的情况for (int i = 1; i <=10; i++) {label=new Label(0, i, i+"");sheet.addCell(label);label=new Label(1, i, "张三"+i);sheet.addCell(label);if(i%2==0){label=new Label(2, i, "男");sheet.addCell(label);}else{label=new Label(2, i, "女");sheet.addCell(label);}}//写入数据workbook.write();//关闭数据workbook.close();} catch (IOException e) {e.printStackTrace();}}/** * @description Excel 的导入 * @throws BiffException * @throws IOException */private static void importExcel() throws BiffException, IOException{//获取工作簿Workbook workbook=Workbook.getWorkbook(new File("e:/jxl_text.xls"));//获取第一个sheet页Sheet sheet=workbook.getSheet(0);//获取数据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()+"\t");}System.out.println();}workbook.close();}}