Delete redundant spaces after line break while importing HTML

Please use HTMLLoadOptions.delete_redundant_spaces property and set it true to delete all the redundant spaces coming after the line break tag. By default, this property is false and redundant spaces are preserved in the output excel files.

Effect of setting the HTMLLoadOptions.delete_redundant_spaces 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.delete_redundant_spaces property. Please set it true or false to get the output as shown in the above screenshot.

	from aspose.cells import HtmlLoadOptions, LoadFormat, SaveFormat, Workbook
	from io import BytesIO

	# 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
	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
	byteArray = html.encode("utf-8")
	# Set Html load options and keep precision true
	loadOptions = HtmlLoadOptions(LoadFormat.HTML)
	loadOptions.delete_redundant_spaces = True
	# Convert byte array into stream
	stream = BytesIO(byteArray)
	# Create workbook from stream with Html load options
	workbook = Workbook(stream, loadOptions)
	# Access first worksheet
	sheet = workbook.worksheets[0]
	# Auto fit the sheet columns
	sheet.auto_fit_columns()
	# Save the workbook
	workbook.save(outputDir + "outputDeleteRedundantSpacesWhileImportingFromHtml.xlsx", SaveFormat.XLSX)

view raw HTML-DeleteRedundantSpacesWhileImportingFromHtml-1.py hosted with ❤ by GitHub

Convert Excel to HTML with headings Exclude Unused Styles during Excel to HTML conversion