Export Excel with protection

See more:

C#

Hi all,

I need to export gridview to excel .I am using the following code for the same

Response.ClearContent();
 
Response.AddHeader(
 

"content-disposition", "attachment; filename=MyExcelFile.xls"); 
 
Response.ContentType =
 

"application/excel";
 

 

StringWriter sw = new StringWriter();
 

 

HtmlTextWriter htw = new HtmlTextWriter(sw);
 
Gridview1.RenderControl(htw);
 
Response.Write(sw.ToString());
 
Response.End();

It gets exported from the grid view to the excel.but the excel needs to be protected sheet with the password generated and hide one column from the code.This is for payroll..

Thanks..