Question

我需要从某个地点(d:emp.xls)开出一张单,然后用黑体字标出头并节省文件。

I am trying to do it but not getting how to open the file and access the 1 row and make them as bold in c#?

Answer 1

• 扩大财产=Excel 8.0;

  // Select using a Named Range
  //string selectString = "SELECT * FROM Customers";

  // Select using a Worksheet name
  string selectString = "SELECT * FROM [Sheet1$]";

  OleDbConnection con = new OleDbConnection(connectionString);
  OleDbCommand cmd = new OleDbCommand(selectString,con);

  try
  {
    con.Open();
    OleDbDataReader theData = cmd.ExecuteReader();
    while (theData.Read())
    {
      Console.WriteLine("{0}: {1} ({2}) - {3} ({4})", theData.GetString(0),theData.GetString(1),theData.GetString(2),theData.GetString(3),theData.GetString(4));
    }
  }
  catch (Exception ex)
  {
    Console.WriteLine(ex.Message);
  }
  finally
  {
    con.Dispose();
  }

友情链接