导入HTML时删除换行后多余空格

将HTMLLoadOptions.DeleteRedundantSpaces属性设置为false和true的效果

以下截图显示了将此属性设置为falsetrue的效果。

todo:image_alt_text

在导入HTML时删除换行后的多余空格

###编程示例

以下示例代码展示了HTMLLoadOptions.DeleteRedundantSpaces属性的用法。请将其设置为truefalse以获得上面截图中显示的输出。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Sample Html containing redundant spaces after <br> tag
string html = "<html> <body> <table> <tr> <td> <br> This is sample data <br> This is sample data<br> This is sample data</td> </tr> </table> </body> </html>";
// Convert Html to byte array
byte[] byteArray = System.Text.Encoding.UTF8.GetBytes(html);
// Set Html load options and keep precision true
HtmlLoadOptions loadOptions = new Aspose.Cells.HtmlLoadOptions(LoadFormat.Html);
loadOptions.DeleteRedundantSpaces = true;
// Convert byte array into stream
MemoryStream stream = new MemoryStream(byteArray);
// Create workbook from stream with Html load options
Workbook workbook = new Workbook(stream, loadOptions);
// Access first worksheet
Worksheet sheet = workbook.Worksheets[0];
// Auto fit the sheet columns
sheet.AutoFitColumns();
// Save the workbook
workbook.Save(outputDir + "outputDeleteRedundantSpacesWhileImportingFromHtml.xlsx", SaveFormat.Xlsx);