jlong

Thanks for the inputs. Using the POI exporter (JXlsExporter) ... Setting the IS_AUTO_DETECT_CELL_TYPE to false resulted in leading zeros & correct time format. OK. Desirable output. Setting the parameter IS_DETECT_CELL_TYPE to false resulted in no leading zeros & correct time format. Setting the parameter IS_DETECT_CELL_TYPE to true resulted in leading zeros & incorrect time formats. Then, I used the JExcelAPIExporter. Setting the IS_AUTO_DETECT_CELL_TYPE to false resulted in leading zeros and correct time format. OK. Desirable output. Setting the IS_DETECT_CELL_TYPE to false resulted in no leading zeros and correct time formats. Setting the IS_DETECT_CELL_TYPE to true resulted in leading zeros and correct time formats. Yeah! Desirable code & output. OK, so what we have is ... POI & JExcelAPI exporters work with the deprecated IS_AUTO_DETECT_CELL_TYPE = false. JExcelAPI works with IS_DETECTED_CELL_TYPE = true. I'll be using the JExcelAPI exporter. Much obliged to you both.

The time format does not work when either XLS parameter IS_DETECT_CELL_TYPE or IS_AUTO_DETECT_CELL_TYPE is set to true. pattern=h:mm:ss a The time reverts to 24 hour clock and sticks the "a" on the end. E.g. It returns "23:59:00 a" instead of "11:59:00 PM". The date format works fine. pattern=MM/dd/yyyy I've tried version 1.2.5, 1.3.0, and 1.3.2. Does anyone else experience this problem?

I am looking at a solution for my problem that may help you too. The key is to use a template engine like Velocity. http://www-128.ibm.com/developerworks/websphere/library/techarticles/0505_olivieri/0505_olivieri.html