本文共 1002 字，大约阅读时间需要 3 分钟。
/// /// 读取Excel文档 /// /// 文件名称 /// 返回一个数据集 public Data ExcelToDS(string Path) { string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ""; OleDbDataAdapter myCommand = null; Data ds = null; strExcel="select * from [sheet1$]"; myCommand = new OleDbDataAdapter(strExcel, strConn); ds = new Data(); myCommand.Fill(ds,"table1"); return ds; } /// /// 写入Excel文档 /// /// 文件名称 public bool SaveFP2toExcel(string Path) { try { string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); System.Data.OleDb.OleDbCommand cmd=new OleDbCommand (); cmd.Connection =conn; //cmd.CommandText ="UPDATE [sheet1$] SET 姓名=’2005-01-01’ 工号=’日期’"; //cmd.ExecuteNonQuery (); for(int i=0;i
转载于:https://www.cnblogs.com/WuXuanKun/p/5256814.html