hi
i want to export gridview data to excel from my asp.net application in server.i know well how to do it using Response.Addheader...
but this way i get white background in whole excel document and no border color like normal excel file, only border color on data.
also i can export in .xls file and not xlsx file..... so i want to export both extensions....
i tried many ways -
1. http://netoffice.codeplex.com/ used this which include all excel version's libraries but it only works in locally when office installed.
dont know how i will make it work production server where office not installed though i have a VPS server.
2. then used open xml sdk by this post - http://blogs.msdn.com/b/brian_jones/archive/2008/11/04/document-assembly-solution-for-spreadsheetml.aspx but it works well in locally but not in server.at last i get prompt says - authentication required.asks username and pass ! ...
Go to the complete details ...