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

Question

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

Karthik Elumalai · Answer

Below are the two methods which i used in our project for excelHope that will help you protected void upldGrid_Click(object sender EventArgs e) { string filename = fileuploadExcel.PostedFile.FileName; filename = Guid.NewGuid().ToString() + _ + filename; string path = Server.MapPath(~/BOQ_Uploads/ + filename); fileuploadExcel.SaveAs(path); DataSet ds1 = OneStopMethods_Admin.Bindgrid_StoreInSQL(path); grvExcelData.DataSource = ds1.Tables[0]; grvExcelData.DataBind(); } public void WriteExcelWithNPOI(String extension DataTable dt) { // dll refered NPOI.dll and NPOI.OOXML IWorkbook workbook; if (extension == xlsx) { workbook = new XSSFWorkbook(); } else if (extension == xls) { workbook = new HSSFWorkbook(); } else { throw new Exception(This format is not supported); } ISheet sheet1 = workbook.CreateSheet(Sheet 1); //make a header row IRow row1 = sheet1.CreateRow(0); for (int j = 0; j { ICell cell = row1.CreateCell(j); String columnName = dt.Columns[j].ToString(); cell.SetCellValue(columnName); } //loops through data for (int i = 0; i { IRow row = sheet1.CreateRow(i + 1); for (int j = 0; j { ICell cell = row.CreateCell(j); String columnName = dt.Columns[j].ToString(); cell.SetCellValue(dt.Rows[i][columnName].ToString()); } } using (var exportData = new MemoryStream()) { Response.Clear(); workbook.Write(exportData); if (extension == xlsx) //xlsx file format { Response.ContentType = application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; Response.AddHeader(Content-Disposition string.Format(attachment;filename={0} tpms_Dict.xlsx)); Response.BinaryWrite(exportData.ToArray()); } else if (extension == xls) //xls file format { Response.ContentType = application/vnd.ms-excel; Response.AddHeader(Content-Disposition string.Format(attachment;filename={0} tpms_dict.xls)); Response.BinaryWrite(exportData.GetBuffer()); } Response.End(); } } Please let me know if it works for youthanks

Raja T · Answer

Hi Try Shakti Singh Dulawat suggested. If you no luck try like public void ImportXLX() { string filePath = string.Format({0}/{1} Server.MapPath(~/Content/UploadedFolder) @C:\Users\Vipin\Desktop\Sheets\MyXL6.xlsx); if (System.IO.File.Exists(filePath)) System.IO.File.Delete(filePath); Request.Files[xlsFile].SaveAs(filePath); Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application(); } More details check out below links http://stackoverflow.com/questions/26312437/how-to-save-excel-file-in-a-specific-folder http://stackoverflow.com/questions/10411520/export-grid-view-to-excel-and-save-excel-file-to-folder http://www.encodedna.com/2013/01/asp.net-export-to-excel.htm

Shakti Singh Dulawat · Answer

Please try private void ExportGridView() { System.IO.StringWritersw= new System.IO.StringWriter(); System.Web.UI.HtmlTextWriterhtw= new System.Web.UI.HtmlTextWriter(sw); //Rendergridviewcontrol. gvFiles.RenderControl(htw); //Writetherenderedcontenttoafile. string renderedGridView=sw.ToString(); System.IO.File.WriteAllText(@ C:\Path\On\Server\ExportedFile.xlsx renderedGridView); }