B4J Question XLReader errors when Microsoft Excel is installed

BarryW

Active Member
Licensed User
Longtime User
B4X:
Program started.
java.lang.OutOfMemoryError: Java heap space
    at jdk.internal.reflect.GeneratedConstructorAccessor13.newInstance(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
    at org.apache.xmlbeans.impl.schema.SchemaTypeImpl.createUnattachedNode(SchemaTypeImpl.java:1887)
    at org.apache.xmlbeans.impl.schema.SchemaTypeImpl.createAttributeType(SchemaTypeImpl.java:1064)
    at org.apache.xmlbeans.impl.values.XmlObjectBase.create_attribute_user(XmlObjectBase.java:932)
    at org.apache.xmlbeans.impl.store.Xobj.getUser(Xobj.java:1598)
    at org.apache.xmlbeans.impl.store.Xobj.find_attribute_user(Xobj.java:2156)
    at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTCellFormulaImpl.getT(CTCellFormulaImpl.java:59)
    at org.apache.poi.xssf.usermodel.XSSFSheet.onReadCell(XSSFSheet.java:3542)
    at org.apache.poi.xssf.usermodel.XSSFRow.<init>(XSSFRow.java:81)
    at org.apache.poi.xssf.usermodel.XSSFSheet.initRows(XSSFSheet.java:229)
    at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:192)
    at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:179)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.parseSheet(XSSFWorkbook.java:444)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:408)
    at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:169)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:278)
    at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:118)
    at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:155)
    at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:36)
    at org.apache.poi.ss.usermodel.WorkbookFactory.lambda$create$4(WorkbookFactory.java:277)
    at org.apache.poi.ss.usermodel.WorkbookFactory$$Lambda$466/0x0000000100374440.create(Unknown Source)
    at org.apache.poi.ss.usermodel.WorkbookFactory.wp(WorkbookFactory.java:295)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:277)
    at anywheresoftware.b4j.objects.PoiWorkbookWrapper.InitializeExisting(PoiWorkbookWrapper.java:78)
    at com.product.master.converter.ff.xlreader._openworkbook(xlreader.java:347)
    at com.product.master.converter.ff.xlreader._readsheetbyindex(xlreader.java:59)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
Error occurred on line: 27 (XLReader)
java.lang.RuntimeException: java.lang.OutOfMemoryError: Java heap space
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:138)
    at anywheresoftware.b4a.shell.ShellBA.raiseEvent2(ShellBA.java:98)
    at anywheresoftware.b4a.debug.Debug.delegate(Debug.java:64)
    at com.product.master.converter.ff.main._selectsheetname(main.java:2751)
    at com.product.master.converter.ff.main._openfile(main.java:2738)
    at com.product.master.converter.ff.main._menubar_action(main.java:2668)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:629)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:237)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:167)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:109)
    at anywheresoftware.b4a.shell.ShellBA.raiseEvent2(ShellBA.java:98)
    at anywheresoftware.b4a.BA$1.run(BA.java:234)
    at javafx.graphics/com.sun.javafx.application.PlatformImpl.lambda$runLater$10(PlatformImpl.java:428)
    at java.base/java.security.AccessController.doPrivileged(Native Method)
    at javafx.graphics/com.sun.javafx.application.PlatformImpl.lambda$runLater$11(PlatformImpl.java:427)
    at javafx.graphics/com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java:96)
    at javafx.graphics/com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
    at javafx.graphics/com.sun.glass.ui.win.WinApplication.lambda$runLoop$3(WinApplication.java:174)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.OutOfMemoryError: Java heap space
    at jdk.internal.reflect.GeneratedConstructorAccessor13.newInstance(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
    at org.apache.xmlbeans.impl.schema.SchemaTypeImpl.createUnattachedNode(SchemaTypeImpl.java:1887)
    at org.apache.xmlbeans.impl.schema.SchemaTypeImpl.createAttributeType(SchemaTypeImpl.java:1064)
    at org.apache.xmlbeans.impl.values.XmlObjectBase.create_attribute_user(XmlObjectBase.java:932)
    at org.apache.xmlbeans.impl.store.Xobj.getUser(Xobj.java:1598)
    at org.apache.xmlbeans.impl.store.Xobj.find_attribute_user(Xobj.java:2156)
    at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTCellFormulaImpl.getT(CTCellFormulaImpl.java:59)
    at org.apache.poi.xssf.usermodel.XSSFSheet.onReadCell(XSSFSheet.java:3542)
    at org.apache.poi.xssf.usermodel.XSSFRow.<init>(XSSFRow.java:81)
    at org.apache.poi.xssf.usermodel.XSSFSheet.initRows(XSSFSheet.java:229)
    at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:192)
    at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:179)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.parseSheet(XSSFWorkbook.java:444)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:408)
    at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:169)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:278)
    at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:118)
    at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:155)
    at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:36)
    at org.apache.poi.ss.usermodel.WorkbookFactory.lambda$create$4(WorkbookFactory.java:277)
    at org.apache.poi.ss.usermodel.WorkbookFactory$$Lambda$466/0x0000000100374440.create(Unknown Source)
    at org.apache.poi.ss.usermodel.WorkbookFactory.wp(WorkbookFactory.java:295)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:277)
    at anywheresoftware.b4j.objects.PoiWorkbookWrapper.InitializeExisting(PoiWorkbookWrapper.java:78)
    at com.product.master.converter.ff.xlreader._openworkbook(xlreader.java:347)
    at com.product.master.converter.ff.xlreader._readsheetbyindex(xlreader.java:59)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)

Any suggestions?
 
Top