public static void exportToExcel_poi(String[] title, String[][] dataList,
OutputStream os)
{
// 将结果集转化为Excel输出
int k = -1;
HSSFWorkbook wwb = null;
try
{
// 创建工作表
wwb = new HSSFWorkbook();
HSSFSheet ws = null;
HSSFRow row = null;
HSSFCell cell = null;
// 逐行添加数据
for (int i = 0; i < dataList.length; i++)
{
// 每10000条记录分一页
if (i / 10000 > k)
{
k = i / 10000;
ws = wwb.createSheet("Sheet" + k);
row = ws.createRow(0);
// 在每页的第一行输入标题
for (int l = 0; l < title.length; l++)
{
cell = row.createCell((short) l);
cell.setCellValue(new HSSFRichTextString(title[l]));
}
}
// 输出数据
for (int j = 0; j < dataList[i].length; j++)
{
row = ws.createRow(i - 10000 * k + 1);
cell = row.createCell((short) j);
cell.setCellValue(new HSSFRichTextString(dataList[i][j]));
}
}
wwb.write(os);
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
try
{
os.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
导出数据进excel
最新推荐文章于 2024-03-18 17:00:35 发布