Here's some code that reads in excel, formats to html, and writes to a file. I've got email code too, but I wasn't sure if you wanted to paste the html into the email, or add a html file as an attachment.
private void btnConvert_Click(object sender, System.EventArgs e)
{
try
{
//retrieve data from excel
DataTable dt = GetDataFromExcelSheet("c:\\new.xls","Sheet1",false);
//format data into html table
string html = GetHtmlFromDataTable(dt);
//write data to file
System.IO.StreamWriter writer = new System.IO.StreamWriter("C:\\Temp\\MyTable.html",false);
writer.Write(html);
writer.Flush();
writer.Close();
}
catch ( Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
private DataTable GetDataFromExcelSheet(string excelPath, string sheetName,bool hasHeaderRow)
{
string hdr = "No";
if (hasHeaderRow) hdr = "Yes";
System.Data.OleDb.OleDbConnection cnn = new System.Data.OleDb.OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excelPath +
";Extended Properties=\"Excel 8.0;HDR=" + hdr + ";IMEX=1\"");
System.Data.OleDb.OleDbDataAdapter da =
new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [" + sheetName + "$]", cnn);
DataSet ds = new DataSet();
cnn.Open();
da.Fill(ds,"ExcelSheet");
return ds.Tables[0];
}
private string GetHtmlFromDataTable(DataTable dt)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder("<TABLE>");
foreach (DataRow dr in dt.Rows)
{
sb.Append("<TR>");
foreach (object o in dr.ItemArray)
{
sb.Append("<TD>");
sb.Append(o as string);
sb.Append("</TD>");
}
sb.Append("</TR>");
}
sb.Append("</TABLE>");
return sb.ToString();
}