HTML excel工作簿加载时支持DIV标签布局
Contents
[
Hide
]
通常,将 HTML 加载到 Excel 工作簿对象时,会忽略 div 标签的布局。但是,如果你想让布局中的div标签不被忽略,那么请设置HTMLLoadOptions.SupportDivTag财产给真的 .该属性的默认值为错误的.
下面的示例代码说明了HTMLLoadOptions.SupportDivTag财产。请下载Aspose 徽标在输入 HTML 和输出excel文件由代码生成。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
var export_html = @" | |
<html> | |
<body> | |
<table> | |
<tr> | |
<td> | |
<div>This is some Text.</div> | |
<div> | |
<div> | |
<span>This is some more Text</span> | |
</div> | |
<div> | |
<span>abc@abc.com</span> | |
</div> | |
<div> | |
<span>1234567890</span> | |
</div> | |
<div> | |
<span>ABC DEF</span> | |
</div> | |
</div> | |
<div>Generated On May 30, 2016 02:33 PM <br />Time Call Received from Jan 01, 2016 to May 30, 2016</div> | |
</td> | |
<td>"; | |
export_html = export_html + " <img src=" + dataDir + "ASpose_logo_100x100.png" + @" /> | |
</td> | |
</tr> | |
</table> | |
</body> | |
</html>"; | |
using (MemoryStream ms = new MemoryStream(System.Text.Encoding.UTF8.GetBytes(export_html))) | |
{ | |
// Specify HTML load options, support div tag layouts | |
HtmlLoadOptions loadOptions = new HtmlLoadOptions(LoadFormat.Html); | |
loadOptions.SupportDivTag = true; | |
// Create workbook object from the html using load options | |
Workbook wb = new Workbook(ms, loadOptions); | |
// Auto fit rows and columns of first worksheet | |
Worksheet ws = wb.Worksheets[0]; | |
ws.AutoFitRows(); | |
ws.AutoFitColumns(); | |
// Save the workbook in xlsx format | |
wb.Save(dataDir + "DivTagsLayout_out.xlsx", Aspose.Cells.SaveFormat.Xlsx); | |
} |