Hi
I am using JExcel to read Excel spreadsheets, in a
Java application.
The program is opening a workbook, and reads the names of the sheets in the workbook.
I use a while loop to read through the sheets.
I created several workbooks with Identical sheet names.
My program is having problems reading a certain workbook. I get the following runtime error, when I try to read a certain workbook.
I am using Netbeans
IDE, It seems that the sheet is large and is triggering a Out of Memory error.
How can I increase the memory in the Netbean editor to fix this.
Or is there another method to fix my problem.
Exception in
thread "AWT-EventQueue-0" java.lang.OutOfMemoryError: Java heap space
at jxl.read.biff.File.read(File.java:217)
at jxl.read.biff.Record.getData(Record.java:117)
at jxl.read.biff.CellValue.<init>(CellValue.java:94)
at jxl.read.biff.RKRecord.<init>(RKRecord.java:66)
at jxl.read.biff.SheetReader.read(SheetReader.java:419)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:252)
Thanks
Rudy