Excel to HTML - Use PresentationPreference Option for Better Layout

Contents
[ ]
// 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(ExceltoHTMLPresentationPreferenceOption.class);
// Instantiate the Workbook
// Load an Excel file
Workbook workbook = new Workbook(dataDir + "HiddenCol.xlsx");
// Create HtmlSaveOptions object
HtmlSaveOptions options = new HtmlSaveOptions();
// Set the Presenation preference option
options.setPresentationPreference(true);
// Save the Excel file to HTML with specified option
workbook.save(dataDir + "outPresentationlayout1.html");

You may the find the following articles regarding Excel to HTML conversion helpful

  • Prevent Exporting Hidden Worksheet Contents on Saving to HTML
  • Export Worksheet CSS Separately in Output HTML
  • Disable Downlevel Revealed Comments while saving to HTML
  • Export Document Workbook and Worksheet Properties in Excel to HTML conversion
  • Export print area range to HTML