C# 操作excel-白红宇

C# 操作excel

阅读量：5292 次

发布时间：2019-06-14

本文共 1093 字，大约阅读时间需要 3 分钟。

///   /// 读取Excel文档  /// 
  /// 文件名称  /// 
     
      返回一个数据集
       public DataSet 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;   DataSet ds = null;   strExcel="select * from [sheet1$]";   myCommand = new OleDbDataAdapter(strExcel, strConn);   ds = new DataSet();   myCommand.Fill(ds,"table1");    conn.Close();    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' WHERE 工号='日期'";    //cmd.ExecuteNonQuery ();    for(int i=0;i

转载于:https://www.cnblogs.com/lampon/p/3651634.html

你可能感兴趣的文章