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)