how to upload a excel file

himanshu kashyap

13y2kWeb Development

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

5 Replies

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

Pankaj Pandey13y ago
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
+2
himanshu kashyap13y ago
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)
+2
himanshu kashyap13y ago
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)
+2
Sanjeeb Lenka13y ago
check this link

http://www.aspdotnet-suresh.com/2012/12/how-to-import-data-from-excel-to-aspnet.html
+2
Raj Kumar13y ago
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];

}
+2