最终效果图
代码:
public class Test {
public static void main(String[] args) throws IOException, IllegalAccessException, ParseException {
ArrayList<People> dataList = new ArrayList<>();
List<String> ss=new ArrayList<>();
for (int i = 0; i < 20; i++) {
ss.add(i+"");
}
for (int i = 0; i < 5; i++) {
People people = new People("姓名" + i, i + "", "男", "12345678911","1","2",ss);
dataList.add(people);
doExceloneThread(dataList);
}
}
public static void doExceloneThread(ArrayList<People> dataList) throws IllegalAccessException, IOException, ParseException {
//创建一个工作薄
SXSSFWorkbook workbook = new SXSSFWorkbook();
//创建一个sheet
SXSSFSheet sheet = (SXSSFSheet) workbook.createSheet();
//设置sheet页长度限制
sheet.setRandomAccessWindowSize(-1);
//-------------------------------------------------------
//表中要几种样式,或几种字体