如何使用C＃.NET使用DOM导出我的Excel中的css？ [英] How can I export css in my excel with data using DOM by C#.NET?

问题描述

这是我的代码。通过使用此代码，我可以导出excel中的所有表。但是我无法导出css类。因此，颜色和样式在网页中的diplaying没有在excel中显示。谁能帮助我提供正确的解决方案。如何导出CSS

This is my code. By using this code I can export all the table in excel. But I can not export css class. As a result the color and style is diplaying in webpage do not shown in excel. Can anyone help me by provide a right solution. How can I export the css

Worksheet worksheet1 = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets[1];

var itemset2 = webBrowser1.Document.GetElementById("t2");

string str = "";

int rowCount = itemset2.GetElementsByTagName("tr").Count;
int colCount = itemset2.GetElementsByTagName("tr")[0].GetElementsByTagName("td").Count;

for (var i = 0; i < rowCount; i++)
{
    for (var j = 0; j < colCount; j++)
    {

        str = itemset2.GetElementsByTagName("tr")[i].GetElementsByTagName("td")[j].InnerText;

        worksheet1.Cells[i + 1, j + 1] = str;

    }


}

和这是我的html页面示例：

and this is my html page sample:

<div id="t2" class="tblcss"> 
<table width="100%" cellpadding="0" cellspacing="0">
  <tr id=r1>
    <td>Telephony By Country</td>
    <td>Jan-2013</td>
    <td>Feb-2013</td>
    <td>Mar-2013</td>
  </tr>
  <tr id=r2>
    <td class="tdhighlight">Calls Offered</td>
    <td>33555</td>
    <td>28201</td>
    <td>27563</td>
  </tr>
  <tr id=r3>
    <td class="tdhighlight">Calls Answered</td>
    <td>32042</td>
    <td>27030</td>
    <td>26273</td>
  </tr>
  <tr id=r4> 
</table> </div>

推荐答案

这篇关于如何使用C＃.NET使用DOM导出我的Excel中的css？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！