java 操作excel (maven)

资料地址：http://www.teamdev.com/downloads/jexcel/docs/JExcel-PGuide.html

1. pom.xml文件添加

<dependency>
<groupId>net.sourceforge.jexcelapi</groupId>
<artifactId>jxl</artifactId>
<version>2.6.12</version>
</dependency>

2、例子代码

package org.jks.test;


import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;


import jxl.Workbook;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;


import org.jks.model.Model;


public class ExcelTest {
public static void main(String args[]) throws IOException,
RowsExceededException, WriteException {
List<Model> models = new ArrayList<Model>();
for (int i = 0; i < 10; i++) {
Model model = new Model();
model.setName("name" + i);
model.setPwd("pwd" + i);
models.add(model);
}


File f = new File("turan.xls");


WritableWorkbook workbook = Workbook.createWorkbook(f);
WritableSheet sheet = workbook.createSheet("sheet1", 0);


sheet.mergeCells(0, 0, 1, 0);
WritableFont wf = new WritableFont(WritableFont.TIMES, 18,
WritableFont.BOLD, true, UnderlineStyle.NO_UNDERLINE,
Colour.RED);
WritableCellFormat wcf = new WritableCellFormat(wf);
Label lab = null;
lab = new Label(0, 0, "Turan test", wcf);
sheet.addCell(lab);
for (int i = 0; i < models.size(); i++) {
Model tmp = models.get(i);
lab = new Label(0, i + 1, tmp.getName());
sheet.addCell(lab);
lab = new Label(1, i + 1, tmp.getPwd());
sheet.addCell(lab);
}


workbook.write();
workbook.close();
System.out.println("game over");
}
}