speed issue when writing to excel from c#

[philky001]

I have a small program in C# that takes a legacy report as a text file and writes to excel template. We also do the page break in the program. It takes a while to run. about 45 seconds for a template with 3 sheets, 2-6 pages per sheet.

But if we have more data, it will take longer.

I am looking for ideas to speed up this process. I was told to look at SpreadsheetML.

Is that the way to go or any other ideas?

 

[Trevor G]

Do you have the updating and calculations switched off in your code?

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.DisplayAlerts = False
'Your code
'Then switch back on
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
Application.DisplayAlerts = True

 

[Norie]

Philly

What method(s) are you using for this?

Are you automating Excel in anyway?

Also how are you dealing with the text file(s)?