I have been tasked with generating Enterprise Reports and writing them to Excel Spreadsheets. When using POI, the program crashes after about 30,000 records are processed. Our system requires millions of records to be processed. POI's limit is 65K rows and some change. Excel 2007 is now capable of processing over a million rows of data. Is there a tool available either open source or for purchase that can handle writing large quantities of data (over 1 million rows) to an Excel spreadsheet? This data will in turn be used to populate pivot tables or be merged with an Excel Template.
John K. Borys Projects & Financial Controls Desk: 312.930.3134 [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> CME Group A CME/Chicago Board of Trade Company 20 S. Wacker Chicago, Illinois 60606 http://www.cmegroup.com/
