I have a C# application that I wrote that takes SQL Server datasets and outputs them to EXCEL.
Right now I have the following:
SQL Server connection via DSN an ODBC.
Excel Connected via Microsoft.Interop.Office.Excel (Spelling?)
Excel Application Object called, workbook initiated.
Then for each row, I go column-by-column and enter data to Excel.
The table has 24 columns. That means 24 inserts per record.
This takes time. Approximately 1000/minute.
On some computers it's even less than that.
I was assuming that was a standard OFFICE COM based throughput.
I was wondering if there was a way to increase it.
Is there a way to insert a full range at once?
turn it from a cell by cell to a row by row?
Or any other option to increase throughput?
Any wisdom would be greatly appreciated.