From_Excel_To_Pdf

Description

Exports the workbook in a PDF document using the specified options.


Excel options

AutoPageBreaks InArgument<Boolean>

Sets whether to position page breaks automatically.

CellsRange InArgument<String>

The range of cells to convert. If this field is not set to no value the entire worksheet will be taken into account.

ShowErrorsInCells InArgument<Boolean>

Sets whether to show errors in cells or not.

ShowFormulas InArgument<Boolean>

Sets whether to display the formula in each cell instead of the formula result: true, to display formulas; otherwise, false.

ShowGridlines InArgument<Boolean>

Sets whether grid lines are shown in the PDF file.

ShowHeadings InArgument<Boolean>

Sets whether row and column headings are shown in the PDF file.

TitleColumnsRange InArgument<String>

Specify columnss to be repeated on every printed page.

TitleRowsRange InArgument<String>

Specify rows to be repeated on every printed page.

WorksheetName InArgument<String>

The name of a worksheet, if a specific one needs to be converted. If this field is not set to no value all worksheets will be converted.


Input file

ExcelFile InArgument<IFileValue> REQUIRED

The Excel document to convert.


Metadata

PdfAuthor InArgument<String>

Sets the string to be added as a Author property of the resulting PDF file.

PdfKeywords InArgument<String>

Sets the string to be added as a Keywords property of the resulting PDF file.

PdfSubject InArgument<String>

Sets the string to be added as a Subject property of the resulting PDF file.

PdfTitle InArgument<String>

Sets the string to be added as a Title property of the resulting PDF file.


Misc


Page layout

BlackAndWhite InArgument<Boolean>

Sets whether to convert the worksheet in black and white or in color: true, to print the worksheet in black and white; otherwise, false.

CenterHorizontally InArgument<Boolean>

Sets whether worksheet data is centered horizontally on a converted page.

CenterVertically InArgument<Boolean>

Sets whether worksheet data is centered vertically on a converted page.

MarginBottom InArgument<Float>

Defines the bottom page margin for a printed sheet.

MarginFooter InArgument<Float>

Sets the space between a footer and bottom edge of a worksheet converted page.

MarginHeader InArgument<Float>

Sets the space between a header and top edge of a worksheet converted page.

MarginLeft InArgument<Float>

Defines the left page margin for a printed sheet.

MarginRight InArgument<Float>

Defines the right page margin for a printed sheet.

MarginTop InArgument<Float>

Defines the top page margin for a printed sheet.

MaxHeightInPages InArgument<Int32>

The number of pages in height to which the worksheet must fit when converted.

MaxWidthInPages InArgument<Int32>

The number of pages in width to which the worksheet must fit when converted.

Specifies page orientation for a printed sheet.

PaperKind InArgument<PaperKind>

Specifies paper size for a converted sheet.

ScalePercentage InArgument<Int32>

Sets the percentage by which to scale the worksheet content.


PDF options

ImageQuality InArgument<ImageQuality>

Sets the quality of images in the resulting PDF file.

PdfACompatibility InArgument<PdfACompatibility>

Specifies document compatibility with the PDF/A specification.