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

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

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