On Thu, 04 Nov 2004 12:59:51 -0400, Jonathan Nickle <[EMAIL PROTECTED]> wrote: > Problem with the XML solution I just found was that the XML file that is created > (named file.xls) is HUGE. 30,000 records (with only 12 columns of text) creates a > 42MB file. When this file is then saved through Excel as an .xls workbook it is > only 16MB. There is obviously some overhead in file size with the XML file. > > Not only is this huge, but Excel takes an extra long time to translate this file > when opening (3 minutes on a very fast machine). > > In addition, when I tried to produce a file with 120,000 records (split into 3 > sheets), it bombed out with the out of memory error. This makes sense after I saw > what the file size is with ony 30,000 records. Arghhh!!! > > Next approach I am working on is to use the COM object and interface with Excel > automatically... >
Have you tried using the Apache POI project's stuff, which is a Java API to Microsoft file types? Check this blog out for Excel stuff. It's really slick: http://www.d-ross.org/index.cfm?objectid=9C65ED5A-508B-E116-6F4F7F38C6AE167C Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183385 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54