The fastest way to write a spreadsheet is to write a csv file directly -- it's just a text file, and it is pretty easy -- you don't get formatting, formulas, etc. (though you don't appear to use them)

However, you should never use the Microsoft ActiveX controls from any server. It is not supported cf. Limitations of Office Web Components when used server-side, and you will be virtually certain to have problems if you put this in production.

There are a both commercial and free libraries that do not depend on ms ActiveX, that make this task straightforward on a server or workstation. StackOverflow seems to frown on library and framework recommendations though.

ADDED

Most of the 3rd party libraries will be considerably faster than using Office Automation too.

The fastest way to write a spreadsheet is to write a csv file directly -- it's just a text file, and it is pretty easy -- you don't get formatting, formulas, etc. (though you don't appear to use them)

However, you should never use the Microsoft ActiveX controls from any server. It is not supported cf. Limitations of Office Web Components when used server-side, and you will be virtually certain to have problems if you put this in production.

There are a both commercial and free libraries that do not depend on ms ActiveX, that make this task straightforward on a server or workstation. StackOverflow seems to frown on library and framework recommendations though.

ADDED

Most of the 3rd party libraries will be considerably faster than using Office Automation too.

ADDED

I linked the wrong article. Should have been Considerations for server-side Automation of Office Do not use office automation components on a server. I have personally been asked to fix this several times by companies that did this. It can be working fine for a while then crash completely, but if you have an active server it will likely run into problems very quickly.

The fastest way to write a spreadsheet is to write a csv file directly -- it's just a text file, and it is pretty easy -- you don't get formatting, formulas, etc. (though you don't appear to use them)

However, you should never use the Microsoft ActiveX controls from any server. It is not supported cf. Limitations of Office Web Components when used server-side, and you will be virtually certain to have problems if you put this in production.

There are a both commercial and free libraries that do not depend on ms ActiveX, that make this task straightforward on a server or workstation. StackOverflow seems to frown on library and framework recommendations though.

The fastest way to write a spreadsheet is to write a csv file directly -- it's just a text file, and it is pretty easy -- you don't get formatting, formulas, etc. (though you don't appear to use them)

However, you should never use the Microsoft ActiveX controls from any server. It is not supported cf. Limitations of Office Web Components when used server-side, and you will be virtually certain to have problems if you put this in production.

There are a both commercial and free libraries that do not depend on ms ActiveX, that make this task straightforward on a server or workstation. StackOverflow seems to frown on library and framework recommendations though.

ADDED

Most of the 3rd party libraries will be considerably faster than using Office Automation too.