摘要: string name=sheet.Name; //获取该sheet的名称string amount=book.WorkSheets.Count.ToString(); //获取该book的sheet数量。string sSheetName=null;object missing = Missing.Value;OleDbConnection conn = new OleDbConnection(... 阅读全文
posted @ 2009-05-12 16:18 居后不争 阅读(3072) 评论(0) 推荐(0) 编辑
摘要: public DataSet ImportDataBase(string path){string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + path + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnec... 阅读全文
posted @ 2009-05-12 16:07 居后不争 阅读(750) 评论(0) 推荐(0) 编辑