read and write excel file from a web application

[logi2000]

i need to create a web application in ASP.NET with C#, that reads and writes(create new) an excel file.

i want to know if it is possible to do it, because i have read that microsoft does not recomend working with excel applications in a web environment.

does anyone has done anything like this, or have any recomendation on which is the best way to implement it.

also if someone can tell me of a website where i can read to look information in this issue will be welcome.

thanks.

 

[chiph]

Excel (and all the MS-Office apps) are not designed for use in a server environment.

That being said, it is possible to call Excel from your ASP.NET code. There will be some security issues to resolve (the ASP.NET user is locked down by default, and can't do much of anything), but the actual coding is pretty much like it was under VBA and VB6 (do a search here for sample code).

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first