I am trying to export to excel using SSRS reports , its working fine with pdf ,but while exporting to excel ,if i want to export multiple times the excel is not opening after 2-3 times. I am using MS Excel 2010. Help me....
View Complete Post
i am new to asp.net programming i am trying to create an ms excel file with charts drawn in it,
i wrote the complete code for it but the it is saying
i have set the permissions to my complete disk space and all user accounts, and i tried with anti-virus disabling also it didnt work please try to help me out and my code is :
Hello good people,
I have this beast as an error. Did my research and found some posts here as well but did not do any good for me.
Here is what I did. I had an error regarding issue rights with COM objects so I gave access rights under component services for Microsoft Excel application now I am getting this error.
Here is some information regarding this
1. Gave rights to ASPNET and network service to my web app directory to try to fix this error.
2. The exact same process works on my Windows 2003 server and my Windows 7 development machine. I am trying to get this going on a different windows 2003 machine that is outside of our domain.
3. Developing on windows 7 64 bit with office 2010 installed. Also excel 2010 is installed on my Web server
4. Here is the code that is causing the error: The last line is causing the error.:
MyXl = new Microsoft.Office.Interop.Excel.Application();
MyXl.Visible = false;
MyWb = (Microsoft.Office.Interop.Excel._Workbook)(MyXl.Workbooks.Add(Missing.Value));
int test = 0;
MySheet = (Microsoft.Office.Interop.Excel._Worksheet)MyXl.ActiveSheet;
int InRow = 2;
for (int i = 0; i < Nu
Edited by Nancy Michell
MSDN Magazine October 2003