title: Display and read an Excel file into a datagridview
body: <p>I have successfully displayed the data using a code I found at this particular website. The problem is, the colour, bold or italics of the font isn't carried over. I need to read the code of a specific cell and convert it into a HTML string and display it as a textbox elsewhere. So I really need to learn how to import colour, bold or italics so I can convert it too. I will be eternally grateful to any kind soul who helps me on this one. Below is my current code.</p>
  
  <pre><code>string PathConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + textBox1.Text + ";Extended Properties=\"Excel 8.0;HDR=Yes;\";";
  
  OleDbConnection conn = new OleDbConnection(PathConn);
  OleDbDataAdapter myDataAdapter = new OleDbDataAdapter("Select * from [sheet1$]", conn);
  DataTable dt = new DataTable();
  
  myDataAdapter.Fill(dt);
  
  dataGridView1.DataSource = dt;
  </code></pre>