Hello manmoth,
This is a great job. I coded XLS export feature for my
app but it handles more than 300 000 records and I
found the EXCEL rows amount per sheeet limitation at
this time.
I used XSLT transformation to HTML tables based on the
HTML feature of EXCEL. Using this, the performance was
GREAT due to the rapid covertion by means of XLST.. I
did generate LARGE XLS files in a few minutes, but when
I try to load it into excel app, the limitation arises.
Googling for a better solution I found your project and
a found it awsome. I like it a lot because it does not
utilize the Excel.Application or any other COM object;
and it is a great feature. However testing with 2
sheets of 60000 records the performance was really bad.
Do you have some advice to improve it? Am I doing
something wrong? What is the speed average per amount
of records?
Thanks in advance...
Raciel Rodriguez L.