Support the layout of DIV tags while loading HTML to Excel workbook with Node.js via C++
Contents
[
Hide
]
Normally, the layout of div tags is ignored while loading HTML into an Excel workbook object. However, if you want the layout of div tags not to be ignored, then please set the HtmlLoadOptions.getSupportDivTag() property to true. The default value of this property is false.
The following sample code illustrates the usage of HtmlLoadOptions.getSupportDivTag() property. Please download the Aspose Logo used inside the input HTML and the output excel file generated by the code.
const path = require("path");
const fs = require("fs");
const AsposeCells = require("aspose.cells.node");
// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const exportHtml = `
<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>
<img src="${dataDir}/ASpose_logo_100x100.png" />
</td>
</tr>
</table>
</body>
</html>`;
const ms = Buffer.from(exportHtml, "utf-8");
// Specify HTML load options, support div tag layouts
const loadOptions = new AsposeCells.HtmlLoadOptions(AsposeCells.LoadFormat.Html);
loadOptions.setSupportDivTag(true);
// Create workbook object from the html using load options
const wb = new AsposeCells.Workbook(ms, loadOptions);
// Auto fit rows and columns of first worksheet
const ws = wb.getWorksheets().get(0);
ws.autoFitRows();
ws.autoFitColumns();
// Save the workbook in xlsx format
wb.save(path.join(dataDir, "DivTagsLayout_out.xlsx"), AsposeCells.SaveFormat.Xlsx);