Global configuration options

The following options allow you to override the default behaviour of a new or existing library instance.

dateFormats

Specify your preferred date masks

See setDateFormats

defaultWorkbookFormat

Create XLSX spreadsheets instead of XLS by default

See setDefaultWorkbookFormat

javaLoaderDotPath

Use an existing JavaLoader installation.

See Loading the POI java libraries

javaLoaderName

Control the name of the JavaLoader instance variable.

See Loading the POI java libraries

loadJavaClassesUsing

Choose how you would like to load the supporting POI and other java libraries.

See setLoadJavaClassesUsing

returnCachedFormulaValues

Force formulas cell values to be recalculated on retrieval.

See setReturnCachedFormulaValues

throwExceptionOnFormulaError

Stop processing if formula cells contain an error.

See setThrowExceptionOnFormulaError