V Volker2502 New Member May 23, 2022 #1 Hello everyone, I've been using B4J for a while, but now i run into problems. I wrote a module that reads MT940 files. That works very well so far. The problem is that I have to write the balances of the bank accounts into an existing EXCEL file. In the development environment it works without problems. But when I create a standalone package, I get the error message: java.io.IOException: Your InputStream was neither an OLE2 stream, nor an OOXML stream or you haven't provide the poi-ooxml*.jar in the classpath/modulepath - FileMagic: OOXML, having providers: [] Also modified the packager.json according to https://www.b4x.com/android/forum/threads/b4jpackager-11-and-jpoi.105311/#content. I'm a little confused now and hope that anyone can help me.
Hello everyone, I've been using B4J for a while, but now i run into problems. I wrote a module that reads MT940 files. That works very well so far. The problem is that I have to write the balances of the bank accounts into an existing EXCEL file. In the development environment it works without problems. But when I create a standalone package, I get the error message: java.io.IOException: Your InputStream was neither an OLE2 stream, nor an OOXML stream or you haven't provide the poi-ooxml*.jar in the classpath/modulepath - FileMagic: OOXML, having providers: [] Also modified the packager.json according to https://www.b4x.com/android/forum/threads/b4jpackager-11-and-jpoi.105311/#content. I'm a little confused now and hope that anyone can help me.
Solution Erel May 23, 2022 Moved to the questions forum. Volker2502 said: Also modified the packager.json according to https://www.b4x.com/android/forum/threads/b4jpackager-11-and-jpoi.105311/#content. Click to expand... I've deleted this thread to avoid confusion. You need to use XLUtils + latest version of jPOI. Add a reference to XLUtils even if you mistakenly aren't using it.
Moved to the questions forum. Volker2502 said: Also modified the packager.json according to https://www.b4x.com/android/forum/threads/b4jpackager-11-and-jpoi.105311/#content. Click to expand... I've deleted this thread to avoid confusion. You need to use XLUtils + latest version of jPOI. Add a reference to XLUtils even if you mistakenly aren't using it.
Erel B4X founder Staff member Licensed User Longtime User May 23, 2022 #2 Moved to the questions forum. Volker2502 said: Also modified the packager.json according to https://www.b4x.com/android/forum/threads/b4jpackager-11-and-jpoi.105311/#content. Click to expand... I've deleted this thread to avoid confusion. You need to use XLUtils + latest version of jPOI. Add a reference to XLUtils even if you mistakenly aren't using it. Upvote 0 Solution
Moved to the questions forum. Volker2502 said: Also modified the packager.json according to https://www.b4x.com/android/forum/threads/b4jpackager-11-and-jpoi.105311/#content. Click to expand... I've deleted this thread to avoid confusion. You need to use XLUtils + latest version of jPOI. Add a reference to XLUtils even if you mistakenly aren't using it.
V Volker2502 New Member May 23, 2022 #3 If I put this #PackagerProperty: AdditionalModuleInfoString = opens schemaorg_apache_xmlbeans.system.sD023D6490046BA0250A839A9AD24C443; #PackagerProperty: IncludedModules = jdk.charsets in b4j-File instead of packager.json then I get while compiling the following error: jar: Package schemaorg_apache_xmlbeans.system.sD023D6490046BA0250A839A9AD24C443 missing from ModulePackages class file attribute the xmlbeans-4.0.0.jar exists in additional Library. Upvote 0
If I put this #PackagerProperty: AdditionalModuleInfoString = opens schemaorg_apache_xmlbeans.system.sD023D6490046BA0250A839A9AD24C443; #PackagerProperty: IncludedModules = jdk.charsets in b4j-File instead of packager.json then I get while compiling the following error: jar: Package schemaorg_apache_xmlbeans.system.sD023D6490046BA0250A839A9AD24C443 missing from ModulePackages class file attribute the xmlbeans-4.0.0.jar exists in additional Library.
Erel B4X founder Staff member Licensed User Longtime User May 23, 2022 #4 This is all irrelevant. All you need to do is: You need to use XLUtils + latest version of jPOI. Add a reference to XLUtils even if you mistakenly aren't using it. And use the built in packager. Upvote 0
This is all irrelevant. All you need to do is: You need to use XLUtils + latest version of jPOI. Add a reference to XLUtils even if you mistakenly aren't using it. And use the built in packager.
