The IE 7 function "Export to Excel" works great in an unprotected area of my site (in IE, right click on a gridview, choose "Export to Excel" and data from gridview is exported to a new Excel worksheet).
However, if the gridview is in an area of the site that requires some sort of security privileges, the "Export to Excel" function only exports the column headings, not the actual data. Is there any way around this? For someone to access the gridview in the protected area, they would have already have had the appropriate security clearance .... As a work-around, my users have just been using copy/paste for the data in the gridview into Excel (basically, a list of names and addresses), but this is not a particularly elegant solution.
Is there some other way to use the IE Export to Excel function in an area of the site that requires permissions? I have looked at some of the code examples for exporting to Excel (I am learnin ...
Go to the complete details ...