I have a gridview that I need to export to Excel. Excel is not installed on the server, but I would like to put a template on the server so that when the user exports the data it will use the template and open the file on the user's local machine.
To make things slightly more complex, I need to export the data to Sheet2 because Sheet1 needs to be a graph (thus the need for the template).
I cannot use any third party software and I have no ability to modify anything on the server. This is used in a corporate environment on a shared server that I don't have any control over.
Any sample code would be very helpful. I'm running ASP.NET 3.5 with Visual Studio 2008.
View Complete Post