poi导出数据分割成多个excel
获取数据list,然后按照list大小,分割成500条数据一个excel.生成多个excel.
------解决思路----------------------
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools
------解决思路----------------------
Templates
* and open the template in the editor.
*/
package com.excel;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
/**
*
* @author lugl