在将Excel转换为HTML时,导出数据条、颜色刻度和图标集条件格式
Contents
[
Hide
]
您可以在将Excel文件转换为HTML时导出数据条、颜色刻度和图标集条件格式。这个特性在Microsoft Excel中得到部分支持,但是Aspose.Cells完全支持它。
在将Excel转换为HTML时,导出数据条、颜色刻度和图标集条件格式
以下截图显示了带有数据条、颜色刻度和图标集条件格式的sample excel file。您可以从给定链接下载sample excel file。
以下截图显示了Aspose.Cells输出的HTML文件,显示了数据条、颜色刻度和图标集条件格式。正如您所见,它看起来和sample excel file一模一样。
示例代码
以下示例代码将示例excel文件转换为HTML,这只是一个普通的Excel to HTML conversion。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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.getDataDir(ConvertingToHTMLFiles.class); | |
// Specify the file path | |
String filePath = dataDir + "Book1.xlsx"; | |
// Specify the HTML saving options | |
HtmlSaveOptions sv = new HtmlSaveOptions(SaveFormat.M_HTML); | |
// Instantiate a workbook and open the template XLSX file | |
Workbook wb = new Workbook(filePath); | |
// Save the HTML file | |
wb.save(dataDir + "output.html", sv); | |
// Print message | |
System.out.println("Excel to HTML conversion performed successfully."); |