com.groupdocs.conversion.options.load

Class SpreadsheetLoadOptions

    • Constructor Detail

      • SpreadsheetLoadOptions

        public SpreadsheetLoadOptions()

        Initializes new instance of SpreadsheetLoadOptions class.

    • Method Detail

      • getFormat

        public final com.groupdocs.conversion.filetypes.SpreadsheetFileType getFormat()

        Input document file type.

      • setFormat

        public final void setFormat(com.groupdocs.conversion.filetypes.SpreadsheetFileType value)

        Input document file type.

      • getDefaultFont

        public final String getDefaultFont()

        Default font for spreadsheet document. The following font will be used if a font is missing.

      • setDefaultFont

        public final void setDefaultFont(String value)

        Default font for spreadsheet document. The following font will be used if a font is missing.

      • getFontSubstitutes

        public final List<FontSubstitute> getFontSubstitutes()

        Substitute specific fonts when converting spreadsheet document.

      • setFontSubstitutes

        public final void setFontSubstitutes(List<FontSubstitute> value)

        Substitute specific fonts when converting spreadsheet document.

      • getShowGridLines

        public final boolean getShowGridLines()

        Show grid lines when converting Excel files.

      • setShowGridLines

        public final void setShowGridLines(boolean value)

        Show grid lines when converting Excel files.

      • getShowHiddenSheets

        public final boolean getShowHiddenSheets()

        Show hidden sheets when converting Excel files.

      • setShowHiddenSheets

        public final void setShowHiddenSheets(boolean value)

        Show hidden sheets when converting Excel files.

      • getOnePagePerSheet

        public final boolean getOnePagePerSheet()

        If OnePagePerSheet is true the content of the sheet will be converted to one page in the PDF document. Default value is true.

      • setOnePagePerSheet

        public final void setOnePagePerSheet(boolean value)

        If OnePagePerSheet is true the content of the sheet will be converted to one page in the PDF document. Default value is true.

      • getOptimizePdfSize

        public final boolean getOptimizePdfSize()

        If True and converting to Pdf the conversion is optimized for better file size than print quality.

      • setOptimizePdfSize

        public final void setOptimizePdfSize(boolean value)

        If True and converting to Pdf the conversion is optimized for better file size than print quality.

      • getConvertRange

        public final String getConvertRange()

        Convert specific range when converting to other than spreadsheet format. Example: "D1:F8".

      • setConvertRange

        public final void setConvertRange(String value)

        Convert specific range when converting to other than spreadsheet format. Example: "D1:F8".

      • getSkipEmptyRowsAndColumns

        public final boolean getSkipEmptyRowsAndColumns()

        Skips empty rows and columns when converting. Default is True.

      • setSkipEmptyRowsAndColumns

        public final void setSkipEmptyRowsAndColumns(boolean value)

        Skips empty rows and columns when converting. Default is True.

      • getPassword

        public final String getPassword()

        Set password to unprotect protected document.

      • setPassword

        public final void setPassword(String value)

        Set password to unprotect protected document.

      • getHideComments

        public final boolean getHideComments()

        Hide comments.

      • setHideComments

        public final void setHideComments(boolean value)

        Hide comments.

      • isCheckExcelRestriction

        public boolean isCheckExcelRestriction()
        Whether check restriction of excel file when user modify cells related objects. For example, excel does not allow inputting string value longer than 32K. When you input a value longer than 32K, if this property is true, you will get an Exception. If this property is false, we will accept your input string value as the cell's value so that later you can output the complete string value for other file formats such as CSV. However, if you have set such kind of value that is invalid for excel file format, you should not save the workbook as excel file format later. Otherwise there may be unexpected error for the generated excel file.
        Returns:
        check restriction flag
      • setCheckExcelRestriction

        public void setCheckExcelRestriction(boolean checkExcelRestriction)
      • deepClone

        public final Object deepClone()

        Clones current instance.

        Returns: