ExcelWriter: Too many different cell formats

Home › Forums › Data Pipeline Toolkit Forums › Data Pipeline Toolkit – Help › ExcelWriter: Too many different cell formats

This topic has 2 voices, contains 3 replies, and was last updated by  Dele Taylor 354 days ago.

Viewing 4 posts - 1 through 4 (of 4 total)
Author Posts
Author Posts
May 31, 2011 at 1:36 AM #345

May 31, 2011 at 1:36 AM #346

I use a JDBCReader to read info from an MySQL database and a ExcelWriter to write this data one-on-one to an excel sheet. At this moment I get a ‘Too many different cell formats’ error if I open the resulting excel sheet in MS Excel 2002. The query results in ~45000 records of 14 columns each.

Any ideas on where to look for a solution?
May 31, 2011 at 1:46 AM #347

Issue seems to be solved by using the JXL library for excel creation:

Code: Select all
ExcelDocument document = new ExcelDocument(ExcelDocument.ProviderType.JXL);
May 31, 2011 at 12:39 PM #348

Dele Taylor

Thanks for posting about this problem with the default (Apache POI) Excel provider along with your solution.

We’ve put in a fix that caches cell styles in the latest Development release (2.2.4). We tested it with 65,535 rows and 64 columns without any problems.

Please give it a try if you get time.

http://northconcepts.com/downloads/data-pipeline/NorthConcepts-DataPipeline-2.2.4.zip/

Thanks,
Dele
Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.