Using this Code We can Take both (.xls) format and (.xlsx) format
try
{
string target = Server.MapPath("~/upload");
if (fileupload1.HasFile)
{
fileupload1.SaveAs(System.IO.Path.Combine(target, fileupload1.FileName));
string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + target + "\\" + fileupload1.FileName + ";" + "Extended Properties='Excel 12.0;HDR=YES;'";
string query = String.Format("SELECT * FROM [{0}$]", "Sheet1");
OleDbDataAdapter da = new OleDbDataAdapter(query, connectionString);
DataSet ds = new DataSet();
da.Fill(ds);
GVexcel.DataSource = ds.Tables[0];
GVexcel.DataBind();
}
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
finally{
}
if any problem on this please let me know...
No comments:
Post a Comment