C
ChrisW
HI,
I've got a spreadsheet I'm trying to read in using the jxl api. My
spreadsheet is about 12 Mb (~200 columns x 6000 rows). My code can
read the spreadsheet, and can print a list of the worksheets using the
following:
rawData = Workbook.getWorkbook(dataFile, wks);
String [] sheetNames = rawData.getSheetNames();
for(int i = 0; i<numberOfSheets; i++)
{
tools.out(sheetNames); //print the sheet names
}
I then try to access the sheet I want
rawDataSheet = rawData.getSheet("Sheet1");
NVars = rawDataSheet.getColumns();
NRows = rawDataSheet.getRows();
System.out.println(NVars + " " + NRows);
I never get to the final print statemement. I've set the
WorkbookSettings as follows:
WorkbookSettings wks = new WorkbookSettings();
wks.setInitialFileSize(30000000);
wks.setArrayGrowSize(6000000);
and I've edited my -Xms and -Xmx to the following:
-Xms4m -Xmx30m
I (and my colleagues) have got no idea what to do next! If anyone can
help, then they might stop my computer from being thrown out of the
window
Thanks,
Chris
I've got a spreadsheet I'm trying to read in using the jxl api. My
spreadsheet is about 12 Mb (~200 columns x 6000 rows). My code can
read the spreadsheet, and can print a list of the worksheets using the
following:
rawData = Workbook.getWorkbook(dataFile, wks);
String [] sheetNames = rawData.getSheetNames();
for(int i = 0; i<numberOfSheets; i++)
{
tools.out(sheetNames); //print the sheet names
}
I then try to access the sheet I want
rawDataSheet = rawData.getSheet("Sheet1");
NVars = rawDataSheet.getColumns();
NRows = rawDataSheet.getRows();
System.out.println(NVars + " " + NRows);
I never get to the final print statemement. I've set the
WorkbookSettings as follows:
WorkbookSettings wks = new WorkbookSettings();
wks.setInitialFileSize(30000000);
wks.setArrayGrowSize(6000000);
and I've edited my -Xms and -Xmx to the following:
-Xms4m -Xmx30m
I (and my colleagues) have got no idea what to do next! If anyone can
help, then they might stop my computer from being thrown out of the
window
Thanks,
Chris