Excel performance
Posted: Tue Nov 10, 2009 8:44 pm
Hiya,
Probably not the right forum for this, but has this community used Excel data much for automation?
If so id like to know, what is the fastest way to create an Excel document with say 13,000 lines and 5 columns?
I mean I have a DataSet, and need to save it to Excel
The method I tried was iterating over the Rows and Columns of the dataset
And writing a XMLSS (2003 Excel XML format) document
It takes forever....
Thanks
Probably not the right forum for this, but has this community used Excel data much for automation?
If so id like to know, what is the fastest way to create an Excel document with say 13,000 lines and 5 columns?
I mean I have a DataSet, and need to save it to Excel
The method I tried was iterating over the Rows and Columns of the dataset
And writing a XMLSS (2003 Excel XML format) document
It takes forever....
Thanks