com.groupdocs.editor.cells.cellstohtml

Class CellsToHtmlOptions

  • All Implemented Interfaces:
    IDocumentLoadOptions


    public class CellsToHtmlOptions
    extends Object
    implements IDocumentLoadOptions

    Allows to specify custom options for loading documents of all supportable Cells (Excel-compatible) formats

    • Nested Class Summary

      Nested Classes 
      Modifier and Type Class and Description
      static class  CellsToHtmlOptions.TextLoadOptions
      Subclass for loading text-based Cells documents (CSV, Tab-based etc.)
    • Method Summary

      Methods 
      Modifier and Type Method and Description
      boolean getExcludeHiddenWorksheets()
      Allows to exclude hidden worksheets in the input Cells document, so they will be totally ignored.
      boolean getOptimizeMemoryUsage()
      Enables memory optimization mechanisms during input document processing, which may degrade performance in some special cases, but on the other hand decrease memory usage.
      String getPassword()
      Allows to specify, modify and obtain the password, which will be used for opening the Cells document, if it is encoded.
      CellsToHtmlOptions.TextLoadOptions getTextOptions()
      Allows to specify options for loading text-based Cells documents
      int getWorksheetIndex()
      Allows to specify the 0-based index of the worksheet (tab) of the input Cells document, which should be converted to the HTML (see remarks).
      void setExcludeHiddenWorksheets(boolean value)
      Allows to exclude hidden worksheets in the input Cells document, so they will be totally ignored.
      void setOptimizeMemoryUsage(boolean value)
      Enables memory optimization mechanisms during input document processing, which may degrade performance in some special cases, but on the other hand decrease memory usage.
      void setPassword(String value)
      Allows to specify, modify and obtain the password, which will be used for opening the Cells document, if it is encoded.
      void setTextOptions(CellsToHtmlOptions.TextLoadOptions value)
      Allows to specify options for loading text-based Cells documents
      void setWorksheetIndex(int value)
      Allows to specify the 0-based index of the worksheet (tab) of the input Cells document, which should be converted to the HTML (see remarks).
    • Constructor Detail

      • CellsToHtmlOptions

        public CellsToHtmlOptions()
    • Method Detail

      • getExcludeHiddenWorksheets

        public boolean getExcludeHiddenWorksheets()

        Allows to exclude hidden worksheets in the input Cells document, so they will be totally ignored. Default is false - hidden worksheets are available and processed as normal.


        Several binary Cells formats (like XLSX) support hidden worksheets (tabs) concept. Document of such format, if it has more then one worksheet, may contain additional hidden worksheets. By default such hidden worksheets are available for processing, but with this option it is able to ignore them, like these hidden worksheets are absent and don't exist. When this option is enabled, you cannot select hidden workseet with the 'WorksheetIndex' property.

      • getOptimizeMemoryUsage

        public boolean getOptimizeMemoryUsage()

        Enables memory optimization mechanisms during input document processing, which may degrade performance in some special cases, but on the other hand decrease memory usage. Useful when processing huge documents and facing OutOfMemoryException. Default is false (memory optimization is disabled for the sake of better performance).

      • getPassword

        public String getPassword()

        Allows to specify, modify and obtain the password, which will be used for opening the Cells document, if it is encoded. Set to NULL or empty string in order to remove the password. Useless for text-based Cells documents like CSV.

      • getWorksheetIndex

        public int getWorksheetIndex()

        Allows to specify the 0-based index of the worksheet (tab) of the input Cells document, which should be converted to the HTML (see remarks).


        Most of Cells documents support a concept of tabs, i.e. they can be multitabbed. On the other hand, HTML format doesn't support such structure. Because of this GroupDocs.Editor can convert to the HTML only one specific tab of the input document, and this option allows to specify it. Tab index is 0-based, negative values are prohibited. If specified index exceeds the number of all tabs, the exception will be thrown. If input Cells document contains only one tab, this option will be ignored. Default value is 0 (first tab).

      • setExcludeHiddenWorksheets

        public void setExcludeHiddenWorksheets(boolean value)

        Allows to exclude hidden worksheets in the input Cells document, so they will be totally ignored. Default is false - hidden worksheets are available and processed as normal.


        Several binary Cells formats (like XLSX) support hidden worksheets (tabs) concept. Document of such format, if it has more then one worksheet, may contain additional hidden worksheets. By default such hidden worksheets are available for processing, but with this option it is able to ignore them, like these hidden worksheets are absent and don't exist. When this option is enabled, you cannot select hidden workseet with the 'WorksheetIndex' property.

      • setOptimizeMemoryUsage

        public void setOptimizeMemoryUsage(boolean value)

        Enables memory optimization mechanisms during input document processing, which may degrade performance in some special cases, but on the other hand decrease memory usage. Useful when processing huge documents and facing OutOfMemoryException. Default is false (memory optimization is disabled for the sake of better performance).

      • setPassword

        public void setPassword(String value)

        Allows to specify, modify and obtain the password, which will be used for opening the Cells document, if it is encoded. Set to NULL or empty string in order to remove the password. Useless for text-based Cells documents like CSV.

      • setWorksheetIndex

        public void setWorksheetIndex(int value)

        Allows to specify the 0-based index of the worksheet (tab) of the input Cells document, which should be converted to the HTML (see remarks).


        Most of Cells documents support a concept of tabs, i.e. they can be multitabbed. On the other hand, HTML format doesn't support such structure. Because of this GroupDocs.Editor can convert to the HTML only one specific tab of the input document, and this option allows to specify it. Tab index is 0-based, negative values are prohibited. If specified index exceeds the number of all tabs, the exception will be thrown. If input Cells document contains only one tab, this option will be ignored. Default value is 0 (first tab).