narasiman rao

narasiman rao

  • NA
  • 519
  • 769k

saving the excel file in specific path in asp.net using C#

May 5 2016 5:02 AM
i have gridview and i am exproting that gridview data to excel.

Before downloading i show popup as Open Save Cancel.

When user click the Open the excel is file open.

The excel open code as follows
 
 
System.Threading.Thread.Sleep(3000);
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gvEmpdetails.AllowPaging = false;
BindGrid();
//Applying stlye to gridview header cells
for (int i = 0; i < gvEmpdetails.HeaderRow.Cells.Count; i++)
gvEmpdetails.HeaderRow.Cells[i].Style.Add("background-color", "#df5015");
gvEmpdetails.RenderControl(htw);
Session["ResponseData"] = sw.ToString();
iframe1.Attributes.Add("src", "Download.aspx");
 
When user the Open button in the popup excel is open
 simiarily when user click the save button in the popup user will choose the path where the excel isto be save.
 
 
for saving the excel file in specific how can i do 

Answers (3)