Hi Gayathri,
The limit of Excel 03 is 65536 lines. If the number of lines exceeds, an error will be reported.
to resolve this you have to check
for (int i = 0; i < list.size(); i++) {
if ((i + 1) % 65535 == 0) {
sheet = book.createSheet(“stud” + index);
row = sheet.createRow(0);
row.createCell (0). Setcellvalue (“identity”);
row.createCell (1) . setcellvalue (“credit”);
index++;
}
row = sheet.createRow((i + 1) – (index * 65535));
//The fourth step is to create cells and set values
row.createCell((short) 0).setCellValue(list.get(i).getStr(“info”));
row.createCell((short) 1).setCellValue(list.get(i).getStr(“score”));
}