Export DataBar, ColorScale and IconSet Conditional Formatting while Excel to HTML Conversion

You can export DataBar, ColorScale and IconSet Conditional Formatting while converting your Excel file into HTML. This feature is partially supported by Microsoft Excel but Aspose.Cells supports it fully.

Export DataBar, ColorScale and IconSet Conditional Formatting while Excel to HTML Conversion

The following screenshot shows the sample excel file with DataBar, ColorScale and IconSet Conditional Formatting. You can download the sample excel file from the given link.

The following screenshot shows the Aspose.Cells output HTML file showing DataBar, ColorScale and IconSet Conditional Formatting. As you can see, it looks exactly like the sample excel file.

Sample Code

The following sample code converts the sample excel file into HTML which is just a normal Excel to HTML conversion.

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

Related Article

• Converting Excel Files to HTML