在asp.net 2.0中，如何用gridview顯示來自建立好的excel文件的內容呢，其實是很簡單的，下面給出簡單代碼片斷

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();
}
  其中，把demo1.xls放在app_data目錄下，這里用select * from [sheet1$]來將sheet1的內容取出來。