B4J Tutorial [jPOI] Migration to version 5 experience (not a big thing)

Just a short note how my experience was migrating to JPOI5. Not worth a tutorial - more a "all easy note" when you migrate an important app (like mine which is used by a company).

I needed to remove the Packager property (The B4J-packager does it on it's own with the new version)

'#PackagerProperty: AdditionalModuleInfoString =provides org.apache.poi.extractor.ExtractorProvider with org.apache.poi.extractor.MainExtractorFactory, org.apache.poi.ooxml.extractor.POIXMLExtractorFactory; provides org.apache.poi.sl.draw.ImageRenderer with org.apache.poi.sl.draw.BitmapImageRenderer, org.apache.poi.xslf.draw.SVGImageRenderer; provides org.apache.poi.ss.usermodel.WorkbookProvider with org.apache.poi.hssf.usermodel.HSSFWorkbookFactory, org.apache.poi.xssf.usermodel.XSSFWorkbookFactory;opens org.apache.xmlbeans.metadata.system.sXMLTOOLS; opens org.apache.xmlbeans.metadata.system.sXMLSCHEMA;opens org.apache.xmlbeans.metadata.system.sXMLLANG;opens org.apache.xmlbeans.metadata.system.sXMLCONFIG;opens org.apache.poi.schemas.ooxml.system.ooxml;

In the code I had to change

titleStyle.ForegroundColor = fx.Colors.LightGray

to

titleStyle.ForegroundColor =3435973887

As it is an integer value now (fx.colors.xxx gives a hex value). So just log the value and convert it to integer.

Last thing:

MyWorkbook.InitializeExistingAsync("MyWorkbook",FParent,FName,"",True)

Here the last parm (read only) was added.

So that's it

 

[Erel]

Big thank you for sharing this!

(fx.colors.xxx gives a hex value)

(It actually returns a JavaFX Paint object. This made it problematic to use jPOI from a non-ui app.)

For new projects I recommend switching to XLUtils. It is simpler to use and much more powerful.

 

[KMatle]

Pleasure but I have to be thankful