Re: Need to generate excel having more than 70,000 records

gube:

If you need only limited control of formatting, you could emit the data as an HTML document and load it into Excel. I've had good success with that in the past, with the ability to control much (but not all) of the formatting.

...roboticus

Comment on Re: Need to generate excel having more than 70,000 records

Replies are listed 'Best First'.
Re^2: Need to generate excel having more than 70,000 records by VMat (Novice) on Apr 14, 2009 at 00:48 UTC
I like imrags' suggestion. Win32::OLE is cool. You can do pretty much anything you do with Visual Basic inside Excel. The drawback is that you need Excel installed and running (i.e., you have to open your document to start working on it). If you have the newer version that supports the number of records you want, you're good to go. VMat	[reply]