Wednesday, December 07, 2005
Jtable to Excel output performance improvement
There were two issues with exporting the output of SQL query to excel. First the limit on the number of columns and second was the performance. Excel used to error out saying too many format styles when the columns were more than 150 which resulted in too many cell formats.
This has been improved by reusing the existing formats and Excel doesn't complain now. This also has increased the performance for generating the output from sql qlet (query).
Download the latest version here
