Skip to end of metadata
Go to start of metadata
Contents Summary
 

Show Grid Lines When Converting From Excel

The Recipe

  • Setup conversion configuration
  • Define save options
  • Set save options to Html save option
  • Set setShowGridLines to true
  • Save results  

The Code

Show Hidden Sheets When Converting From Excel

The Recipe

  • Setup conversion configuration
  • Define save options
  • Set save options to Html save option
  • Set setShowHiddenSheets to true
  • Save results

The Code

Skip Empty Rows and Columns

Spreadsheet may contain empty rows and columns. In case, if the number of empty rows or columns are considerably large, the document conversion time could increase and it affects the performance. GroupDocs.Conversion for Java allows you to skip empty rows and columns when converting a spreadsheet to any other supported formatted document.

The Recipe

  • Setup conversion configuration
  • Define save options
  • Define CellsLoadOptions and set setSkipEmptyRowsAndColumns() to false
  • Save results 

The Code

Hide Comments

The Recipe

  • Setup conversion configuration
  • Define save options
  • Set setHideComments option to true
  • Convert document 
  • Save results 

The Code

Labels
  • No labels