import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; import java.util.ArrayList; import java.util.List; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.write.WriteException; import jxl.write.biff.RowsExceededException; public class JxlWriteExcel { /** * @param datas 封装着Object[]的列表, 一般是String内容. * @param title 每个sheet里的标题. */ public void writeExcel(OutputStream out, List list, String[] title) { if(list == null) { throw new IllegalArgumentException("要写入excel的数据不能为空!"); } try { WritableWorkbook workbook = Workbook.createWorkbook(out); WritableSheet ws = workbook.createSheet("sheet 1", 0);//创建sheet int rowNum = 0; //要写的行,jxl操作excel时,第一行是从0开始,以此类推 if(title != null) { putRow(ws, 0, title);//压入标题 rowNum = 1; } for(int i=0; i
JXL写入Excel
最新推荐文章于 2024-12-08 09:57:40 发布