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

请用HTMLLoadOptions.DeleteRedundantSpaces属性并设置它真的删除换行标记后的所有冗余空格。默认情况下，此属性是错误的并且在输出的 excel 文件中保留了多余的空格。

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

下面的截图展示了将这个属性设置为的效果错误的和真的.

待办事项：图片_替代_文本

下面的示例代码显示了HTMLLoadOptions.DeleteRedundantSpaces财产。请设定真的要么错误的获得如上图所示的输出。

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