Hi,

I have a data dump going to excel writer. The problem is that excel 2003 has a max limit of 65,535 rows per sheet. My data dump has more than 70K records. What is the best way to wrte data? I tried delimited text writer component but the outcome/format is really unreadable (Column Header and data does not align properly). How can we write data in to excel that can go in to different sheets of the same excel file once the first sheet reaches its capacity? Is there a better solution? Please advise.

Pipeline Pilot version: 6.1.5 / 8.0

MS Office: Version 2003

regards,

BJ