B4J Question Error JPOI

[Volker2502]

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.

 

[Erel]

Moved to the questions forum.

Also modified the packager.json according to https://www.b4x.com/android/forum/threads/b4jpackager-11-and-jpoi.105311/#content.

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.

 

[Volker2502]

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]

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.