how to upload a excel file

Question

hi , i wanted to know how to upload a excel file and display in a grid view form ,,

Sanjeeb Lenka · Answer

check this link http://www.aspdotnet-suresh.com/2012/12/how-to-import-data-from-excel-to-aspnet.html

Raj Kumar · Answer

protected void btnUpload_Click(object sender, EventArgs e) { if (FileUpload1.FileName.ToString() != "" && FileUpload1.ToString().Contains(".")) { String filepath = Server.MapPath("UploadedFiles"); FileUpload1.SaveAs(filepath + "\" + FileUpload1.FileName.Split('\')[FileUpload1.FileName.Split('\').Length - 1]); string excelPath = (filepath + "\" + FileUpload1.FileName.Split('\')[FileUpload1.FileName.Split('\').Length - 1]); ExcelGridView.DataSource = GetExcelData(excelPath); ExcelGridView.DataBind(); } } public DataTable GetExcelData(string ExcelFilePath) { string OledbConnectionString = string.Empty; OleDbConnection objConn = null; OledbConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ExcelFilePath + ";Extended Properties=Excel 8.0;"; objConn = new OleDbConnection(OledbConnectionString); if (objConn.State == ConnectionState.Closed) { objConn.Open(); } OleDbCommand objCmdSelect = new OleDbCommand("Select * from [Sheet1$]", objConn); OleDbDataAdapter objAdapter = new OleDbDataAdapter(); objAdapter.SelectCommand = objCmdSelect; DataSet objDataset = new DataSet(); objAdapter.Fill(objDataset, "ExcelDataTable"); objConn.Close(); return objDataset.Tables[0]; }

Pankaj Pandey · Answer

http://www.codeproject.com/Tips/593181/Load-GridView-from-Excel http://www.dotnetfunda.com/articles/article1954-how-to-read-ms-excel-file-and-populate-into-gridview.aspx http://www.aspdotnet-suresh.com/2010/06/read-data-from-excel-sheet-and-bind-it.html

himanshu kashyap · Answer

thank u sir its really use full, but can we upload a excel file without browsing all the time ,,and we place a add button in design side , through that button we can add or edit that data in html(asp.net)

himanshu kashyap · Answer

thank u sir its really use full, but can we upload a excel file without browsing all the time ,,and we place a add button in design side , through that button we can add or edit that data in html(asp.net)

how to upload a excel file

Answers (5)