1. GroupDocs Documentation
    2. /
    3. GroupDocs.Conversion Product Family
    4. /
    5. GroupDocs.Conversion for Java
    6. /
    7. Developer guide
    8. /
    9. Advanced usage
    10. /
    11. Loading
    12. /
    13. Load options for different document types
    14. /
    15. Load Spreadsheet document with options

    Load Spreadsheet document with options

    GroupDocs.Conversion provides the SpreadsheetLoadOptions class to give you better control over how the source spreadsheet document will be processed. The following options could be set:

    • setFormat allows you to specify explicitly the type of the source spreadsheet document. Available options are: Xls, Xlsx, Xlsm, Xlsb, Ods, Ots, Xltx, Xlt, Xltm, Tsv, Xlam, Csv.
    • setDefaultFont sets a default font. The following font will be used if a spreadsheet font is missing.
    • setFontSubstitutes sets substitute specific fonts from the source spreadsheet document.
    • setShowGridLines specifies that grid lines should be visible.
    • setShowHiddenSheets specifies that hidden sheet should be included in the converted document.
    • setOnePagePerSheet specifies that one sheet from the spreadsheet must be converted to a single page.
    • setConvertRange specifies that a specific range of cells must be converted. Example: “D1:F8”.
    • setSkipEmptyRowsAndColumns specifies that empty rows and columns must be ignored.
    • setPassword specifies a password to unlock the protected document.
    • setHideComments specifies that comments from the source spreadsheet must be hidden during conversion.

    Hide comments

    The following code snippet shows how to convert a spreadsheet and hide comments:

    import com.groupdocs.conversion.Converter;
import com.groupdocs.conversion.options.convert.PdfConvertOptions;
import com.groupdocs.conversion.options.load.SpreadsheetLoadOptions;
...
SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
loadOptions.setHideComments(true);
loadOptions.setOnePagePerSheet(true);

Converter converter = new Converter("sample.xlsx", loadOptions);
PdfConvertOptions options = new PdfConvertOptions();
converter.convert("converted.pdf", options);

    Show grid lines

    The following code snippet shows how to convert a spreadsheet and show grid lines:

    import com.groupdocs.conversion.Converter;
import com.groupdocs.conversion.options.convert.PdfConvertOptions;
import com.groupdocs.conversion.options.load.SpreadsheetLoadOptions;
...
SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
loadOptions.setShowGridLines(true);
loadOptions.setOnePagePerSheet(true);

Converter converter = new Converter("sample.xlsx", loadOptions);
PdfConvertOptions options = new PdfConvertOptions();
converter.convert("converted.pdf", options);

    Skip empty rows and columns

    The following code snippet shows how to convert a spreadsheet and skip empty rows and columns:

    import com.groupdocs.conversion.Converter;
import com.groupdocs.conversion.options.convert.PdfConvertOptions;
import com.groupdocs.conversion.options.load.SpreadsheetLoadOptions;
...
SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
loadOptions.setSkipEmptyRowsAndColumns(true);
loadOptions.setOnePagePerSheet(true);

Converter converter = new Converter("sample.xlsx", loadOptions);
PdfConvertOptions options = new PdfConvertOptions();
converter.convert("converted.pdf", options);

    Specify font substitution

    The following code snippet shows how to convert a spreadsheet and specify font substitution for missing fonts:

    import com.groupdocs.conversion.Converter;
import com.groupdocs.conversion.contracts.FontSubstitute;
import com.groupdocs.conversion.options.convert.PdfConvertOptions;
import com.groupdocs.conversion.options.load.SpreadsheetLoadOptions;
import java.util.ArrayList;
import java.util.List;
...
SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
List<FontSubstitute> fontSubstitutes = new ArrayList<FontSubstitute>();
fontSubstitutes.add(FontSubstitute.create("Tahoma", "Arial"));
fontSubstitutes.add(FontSubstitute.create("Times New Roman", "Arial"));
loadOptions.setDefaultFont("Helvetica");
loadOptions.setOnePagePerSheet(true);
loadOptions.setFontSubstitutes(fontSubstitutes);

Converter converter = new Converter("sample.xlsx", loadOptions);
PdfConvertOptions options = new PdfConvertOptions();
converter.convert("converted.pdf", options);

    Specify range

    The following code snippet shows how to convert a spreadsheet and specify the exact range of rows and columns to be converted:

    import com.groupdocs.conversion.Converter;
import com.groupdocs.conversion.options.convert.PdfConvertOptions;
import com.groupdocs.conversion.options.load.SpreadsheetLoadOptions;
...
SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
loadOptions.setConvertRange("10:30");
loadOptions.setOnePagePerSheet(true);

Converter converter = new Converter("sample.xlsx", loadOptions);
PdfConvertOptions options = new PdfConvertOptions();
converter.convert("converted.pdf", options);

    Include hidden sheets

    The following code snippet shows how to convert a spreadsheet including the hidden sheets:

    import com.groupdocs.conversion.Converter;
import com.groupdocs.conversion.options.convert.PdfConvertOptions;
import com.groupdocs.conversion.options.load.SpreadsheetLoadOptions;
...
SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
loadOptions.setShowHiddenSheets(true);
loadOptions.setOnePagePerSheet(true);

Converter converter = new Converter("sample.xlsx", loadOptions);
PdfConvertOptions options = new PdfConvertOptions();
converter.convert("converted.pdf", options);
    © Groupdocs 2001-2024. All Rights Reserved.