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

narasiman rao

10y25.8kC#

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Karthik Elumalai10y ago
Below are the two methods which i used in our project for excel,Hope 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 < dt.Columns.Count; j++)
{
ICell cell = row1.CreateCell(j);
String columnName = dt.Columns[j].ToString();
cell.SetCellValue(columnName);
}
//loops through data
for (int i = 0; i < dt.Rows.Count; i++)
{
IRow row = sheet1.CreateRow(i + 1);
for (int j = 0; j < dt.Columns.Count; 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 you,thanks
Raja T10y ago
Hi, Try Shakti Singh Dulawatsuggested. 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 Dulawat10y ago
Please try
privatevoidExportGridView()
{
System.IO.StringWritersw=newSystem.IO.StringWriter();
System.Web.UI.HtmlTextWriterhtw=newSystem.Web.UI.HtmlTextWriter(sw);
//Rendergridviewcontrol.
gvFiles.RenderControl(htw);
//Writetherenderedcontenttoafile.
stringrenderedGridView=sw.ToString();
System.IO.File.WriteAllText(@"C:\Path\On\Server\ExportedFile.xlsx",renderedGridView);
}