现在正在做的一个项目,要把excel中的数据导入数据库中。但是由于excel中数据量过大(大于十万条),一次读取数据会程序抛出如下异常:Exception in thread "main" java.lang.OutOfMemoryError: Java heap space。
测试代码如下:
InputStream is=new FileInputStream("d:\\test1.xls");
Workbook wb = Workbook.getWorkbook(is);
Sheet sheet = wb.getSheet(0);
Cell cell = null;
int columns = sheet.getColumns();
int rows = sheet.getRows();
int flag = 1000;
for(int i = 0;i < rows; i++){
for(int n = 0;n < columns; n++){
cell = sheet.getCell(i, n);
System.out.print(cell.getContents() + " ");
}
System.out.println();
}
测试代码如下:
InputStream is=new FileInputStream("d:\\test1.xls");
Workbook wb = Workbook.getWorkbook(is);
Sheet sheet = wb.getSheet(0);
Cell cell = null;
int columns = sheet.getColumns();
int rows = sheet.getRows();
int flag = 1000;
for(int i = 0;i < rows; i++){
for(int n = 0;n < columns; n++){
cell = sheet.getCell(i, n);
System.out.print(cell.getContents() + " ");
}
System.out.println();
}