Question

急啊！java中怎么把10万条数据导入Excel,

可以使用哪几种数据格式，请详述

Answer 1

public class ExcelWrit {
public static void main(String[] args) throws IOException, RowsExceededException, WriteException {
String path="D:\\123.xlsx";//找到Excel表格
File file=new File(path);//为excel表格开辟内存
WritableWorkbook workbook=Workbook.createWorkbook(file);
WritableSheet sheet=workbook.createSheet("第一页", 0);
WritableSheet sheet2=workbook.createSheet("第二页", 1);
for (int i = 1; i <=100000; i++) {
if (i<=50000) {
Label label=new Label(0, i,Integer.toString(i));
sheet.addCell(label);
System.out.println("正在写入第"+i+"行");
}else {
Label label=new Label(0, i-50000,Integer.toString(i));
sheet2.addCell(label);
System.out.println("正在写入第"+i+"行");
}

}
workbook.write();//写入
workbook.close();//关闭
}
}

Answer 2

额，不要这样，就算导入了也会报内存溢出的 正确的办法是分批 或者压缩。

Answer 3

apache poi包下个，excel写入