求导入/导出EXCEL sheet的例子

Question

现在时间比较赶啊。 各位有例子的发来看看哈   如何读取excel的sheet给个例子吧。谢谢

Answer 1

Excel.Application app = new Excel.ApplicationClass();   
app.Visible = true;   
Excel.Workbook workBook = app.Workbooks.Open(templetFile,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing);   
Excel.Worksheet workSheet = (Excel.Worksheet)workBook.Sheets.get_Item(1);   
for(int i=1;i <sheetCount;i++)   
{   
} 
excel导入dataset
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
 using(OleDbConnection OleConn = new OleDbConnection(strConn))
{
  OleConn.Open();
  String sql = "SELECT * FROM [Sheet1$]";
  OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
  DataSet ds= new DataSet();
  OleDaExcel.Fill(ds);
  OleConn.Close();
}

Answer 2

http://dotnet.aspx.cc/file/Export-Gridview-To-Excel-With-Multi-Sheet.aspx