Link to home
Start Free TrialLog in
Avatar of sweet55
sweet55Flag for United States of America

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#
Avatar of BuggyCoder
BuggyCoder
Flag of India image

Avatar of sweet55

ASKER

I need to Use 'Microsoft.Office.Interop’  dlls in my project.
ASKER CERTIFIED SOLUTION
Avatar of BuggyCoder
BuggyCoder
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of Amandeep Singh Bhullar
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.