Delete redundant spaces after line break while importing HTML

Effect of setting the HTMLLoadOptions.DeleteRedundantSpaces property to false and true

The following screenshot shows the effect of setting this property to false and true.

todo:image_alt_text

Delete redundant spaces after line break while importing HTML

Programming Sample

The following sample code shows the usage of the HTMLLoadOptions.DeleteRedundantSpaces property. Please set it true or false to get the output as shown in the above screenshot.

// 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);