模板-jxl对excel读写操作

pom.xml引入

    <dependency>
        <groupId>org.jdom</groupId>
        <artifactId>jdom</artifactId>
        <version>1.1.3</version>
    </dependency>
    <dependency>
        <groupId>net.sourceforge.jexcelapi</groupId>
        <artifactId>jxl</artifactId>
        <version>2.6.10</version>
    </dependency>

模板代码：

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 java.io.File;
import java.io.IOException;
import java.util.List;
import java.util.TreeMap;

public class ExcelUtil {

//lists代表多行数据，第i行为容器内的 lists.get[i]
public static void write( List<List<String>> lists, String[] keys, String filePath ) throws Exception {
    //创建Excel文件
    File file = new File(filePath);
    //创建文件
    file.createNewFile();
    //创建工作薄
    WritableWorkbook workbook = Workbook.createWorkbook(file);
    //创建sheet
    WritableSheet sheet = workbook.createSheet("sheet1", 0);
    //添加表头
    Label label = null;
    for (int i = 0; i < keys.length; i++) {
        label = new Label( i, 0, keys[i]);
        sheet.addCell(label);
    }
    //追加数据
    //i行 j列
    for (int i = 1; i < lists.size(); i++) {
        List<String> list = lists.get( i - 1 );
        for (int j = 0; j < list.size(); j++) {
            String value = list.get(j);
            if ( value != null )
                label = new Label(j, i, value );
            else
                label = new Label(j, i, " ");
            sheet.addCell(label);
        }
    }
    workbook.write();
    workbook.close();
}

public static TreeMap<String , Object > getData( String filePath ){

    try {
        //获得Excel文件
        File file = new File(filePath);
        //获得工作薄
        Workbook workbook = Workbook.getWorkbook(file);
        //获得第一个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() + "  ");
            }
            System.out.println();
        }
    } catch (IOException e) {
        e.printStackTrace();
    } catch (BiffException e) {
        e.printStackTrace();
    }
    return null;
}
}