IBM Support

Workaround for issue with Spreadsheet Import builder and jakarta-poi libraries

Technote (troubleshooting)


The Spreadsheet Import builder is attempting to interpret the data as date values instead of numeric values when a WEF application is deployed as a portlet.


WEF includes poi 2.5.1, and portal includes an older version of poi. The portal version HSSFDateUtil.isCellDateFormatted method returns true incorrectly for a number of cell format strings which it shouldn't. (formats 164-173) This causes the spreadsheet data to be incorrectly interpreted as date values.

Resolving the problem

You can resolve this issue by forcing WEF exported portlet .war files to include the 2.5.1 version of jakarta-poi.jar.
The exclude line in portlet7.0.excludes should be removed to allow jakarta-poi.jar to be included in our .war files.

Find this files here:


This is a simple text file which you can edit it in Eclipse or any text editor. You will need to remove the following line from the file:


Then save the excludes file and perform an Export->Web Experience Factory Portlet WAR action to generate a new .war file that contains the jakarta-poi.jar library.

Document information

More support for: WebSphere Dashboard Framework
Framework Builders

Software version: 7.0.1

Operating system(s): Linux, Windows

Reference #: 1600453

Modified date: 12 July 2012

Translate this page: