How to run Excel on server

Posted by Shoyebaziz123 under ASP.NET on 12/2/2009 | Views : 3921 | Status : [Member] | Replies : 2
Hi All,
I have upload my project on server , in my project there is an excel sheet which i have fill to generate xml...... now when i am running this project there is an error showing

"Compiler Error Message: BC30002: Type 'Microsoft.Office.Interop.Excel.Application' is not defined."

and in Red Color

Line 17: Dim exel As Microsoft.Office.Interop.Excel.Application
Line 18: Dim wb As Microsoft.Office.Interop.Excel.Workbook

Then what i have to do ?


Please help me
Thanks in advance




Responses

Posted by: Lakhangarg on: 12/2/2009 [Member] [Moderator] Silver

Up
0
Down
Hi-

You Need to add Reference of Microsoft.Office.Interop.Execl.

means you need to add dll in bin.

Thanks & Regards
Lakhan Pal Garg

Shoyebaziz123, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Abhi2434 on: 12/3/2009 [Member] [Microsoft_MVP] [MVP] Silver

Up
0
Down
do you have Excel installed in your server.

InterOp needs the server to have the component installed.

make sure it is there.

www.abhisheksur.com

Shoyebaziz123, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response