Display data from Excel tables with the GridView

excel| Data | show

In ASP.net 2.0, how to display the content from a built Excel file with the GridView is very simple, and here's a simple snippet of code.

protected void Page_Load (object sender, EventArgs e)
{
OleDbConnection dbconnection = new
OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data source=" +
Server.MapPath ("~/app_data/demo1.xls") + ";" + "Extended
Properties=\ "Excel 8.0; Hdr=yes\ "");
Dbconnection.open ();
String SqlString = "SELECT * FROM [sheet1$]";
OleDbCommand DbCommand = new OleDbCommand (SqlString, dbconnection);
IDataReader Dbreader = Dbcommand.executereader ();
Gridview1.datasource = Dbreader;
Gridview1.databind ();
Dbreader.close ();
Dbconnection.close ();
}
Among them, the Demo1.xls is placed in the App_Data directory, where a select * from [sheet1$] is used to extract the Sheet1 contents.