sweet55
asked on
Export data in Grdiview to Excel using ‘Microsoft.Office.Interop’ in C#
Export data from GridView to Excel, CSV in asp.net using c#
ASKER
I need to Use 'Microsoft.Office.Interop’ dlls in my project.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hello:
Using Office automation in server environment is not recomended by microsoft:
"Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment."
http://support.microsoft.com/kb/257757
Instead, I would suggest using xslt transform or third party component:
http://ewbi.blogs.com/develops/2005/01/create_excels_s.html
http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx
Best regards
Using Office automation in server environment is not recomended by microsoft:
"Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment."
http://support.microsoft.com/kb/257757
Instead, I would suggest using xslt transform or third party component:
http://ewbi.blogs.com/develops/2005/01/create_excels_s.html
http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx
Best regards
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
http://www.codeproject.com/Articles/164582/8-Solutions-to-Export-Data-to-Excel-for-ASP-NET