Java读写Excel(1) 由模板写入,输出为另一个文件
先下载一个jxl-2.6.10.jar,别的版本不清楚,应该也行。
import java.io.File;
import java.io.IOException;
import java.util.Date;
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;
import jxl.write.Number;
import jxl.write.DateTime;
public class CreateExcel {
public static void main(String args[]) {
try {
lalala("D:\\A.xls","D:\\B.xls");
} catch (Exception e) {
e.printStackTrace();
}
}
/*
@param modelPath 模板路径
@param newFilePath 输出文件路径
@return
*/
static void lalala(String modelPath,String newFilePath) throws Exception{
jxl.Workbook rw=jxl.Workbook.getWorkbook(new File(modelPath));
WritableWorkbook wwb = Workbook.createWorkbook(new File(newFilePath),rw);
jxl.write.WritableSheet ws=wwb.getSheet(0);
Label label = new Label(0, 2, "我当场自闭"); //0代表第一列,2代表第三行
ws.addCell(label);
wwb.write();
wwb.close();
rw.close();
}
}