导入时删除换行后的多余空格 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-Java
	// The path to the documents directory
	String dataDir = Utils.getSharedDataDir(DeleteRedundantSpacesFromHtml.class) + "TechnicalArticles/";

	// 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 = html.getBytes();

	// Set Html load options and keep precision true
	HtmlLoadOptions loadOptions = new HtmlLoadOptions(LoadFormat.HTML);
	loadOptions.setDeleteRedundantSpaces(true);

	// Convert byte array into stream
	java.io.ByteArrayInputStream stream = new java.io.ByteArrayInputStream(byteArray);

	// Create workbook from stream with Html load options
	Workbook workbook = new Workbook(stream, loadOptions);

	// Access first worksheet
	Worksheet worksheet = workbook.getWorksheets().get(0);

	// Auto fit the sheet columns
	worksheet.autoFitColumns();

	// Save the workbook
	workbook.save(dataDir + "DRSFromHtml_out-" + loadOptions.getDeleteRedundantSpaces() + ".xlsx", SaveFormat.XLSX);

	System.out.println("File saved");