PdfSaveOptions

PdfSaveOptions class

Represents the options for saving pdf file.

Constructors

NameDescription
PdfSaveOptionsCreates the options for saving pdf file.

Properties

NameTypeDescription
EmbedStandardWindowsFontsbooleanTrue to embed true type fonts. Affects only ASCII characters 32-127. Fonts for character codes greater than 127 are alwa
BookmarkPdfBookmarkEntryGets and sets the PdfBookmarkEntry object.
ComplianceintGets or sets the PDF standards compliance level for output documents. The value of the property is PdfCompliance integer
SecurityOptionsPdfSecurityOptionsSet this options, when security is need in xls2pdf result.
ImageTypeImageFormatRepresents the image type when converting the chart and shape . NOTE: This member is now obsolete. Instead, Chart and Sh
CalculateFormulabooleanIndicates whether to calculate formulas before saving pdf file. The default value is false.
PdfCompressionintIndicate the compression algorithm The value of the property is PdfCompressionCore integer constant.
CreatedTimeDateTimeGets and sets the time of generating the pdf document. if it is not be set, it will be the time of generating the pdf.
ProducerStringGets and sets producer of generated pdf document. If the value is null, or a valid LICENSE is not set, string Aspose.Cel
OptimizationTypeintGets and sets pdf optimization type. The value of the property is PdfOptimizationType integer constant. Default value is
CustomPropertiesExportintGets or sets a value determining the way CustomDocumentPropertyCollection are exported to PDF file. Default value is Non
ExportDocumentStructurebooleanIndicates whether to export document structure.
DisplayDocTitlebooleanIndicates whether the window’s title bar should display the document title. If false, the title bar should instead displ
FontEncodingintGets or sets embedded font encoding in pdf. The value of the property is PdfFontEncoding integer constant. Default value
WatermarkRenderingWatermarkGets or sets watermark to output.
EmbedAttachmentsbooleanIndicates whether to embed attachment for Ole objects in Excel. Default value is false. The value must be false when PDF
ZoomBehaviorintThe value of the property is PdfZoomBehavior integer constant.
ZoomFactorint
DefaultFontStringWhen characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf
CheckWorkbookDefaultFontbooleanWhen characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf
CheckFontCompatibilitybooleanIndicates whether to check font compatibility for every character in text. The default value is true. Disable this prope
IsFontSubstitutionCharGranularitybooleanIndicates whether to only substitute the font of character when the cell font is not compatibility for it. Default is fa
OnePagePerSheetbooleanIf OnePagePerSheet is true , all content of one sheet will output to only one page in result. The paper size of pagesetu
AllColumnsInOnePagePerSheetbooleanIf AllColumnsInOnePagePerSheet is true , all column content of one sheet will output to only one page in result. The wid
IgnoreErrorbooleanIndicates if you need to hide the error while rendering. The error can be error in shape, image, chart rendering, etc.
OutputBlankPageWhenNothingToPrintbooleanIndicates whether to output a blank page when there is nothing to print. Default is true.
PageIndexintGets or sets the 0-based index of the first page to save. Default is 0.
PageCountintGets or sets the number of pages to save. Default is System.Int32.MaxValue which means all pages will be rendered..
PrintingPageTypeintIndicates which pages will not be printed. The value of the property is PrintingPageType integer constant. If content in
GridlineTypeintGets or sets gridline type. The value of the property is GridlineType integer constant. Default is Dotted type.
GridlineColorColor
TextCrossTypeintGets or sets displaying text type when the text width is larger than cell width. The value of the property is TextCrossT
DefaultEditLanguageintGets or sets default edit language. The value of the property is DefaultEditLanguage integer constant. It may display/re
SheetSetSheetSetGets or sets the sheets to render. Default is all visible sheets in the workbook: SheetSet.Visible .
DrawObjectEventHandlerDrawObjectEventHandlerImplements this interface to get DrawObject and Bound when rendering.
PageSavingCallbackIPageSavingCallbackControl/Indicate progress of page saving process.
EmfRenderSettingintSetting for rendering Emf metafile. The value of the property is EmfRenderSetting integer constant. EMF metafiles identi
CustomRenderSettingsCustomRenderSettings
SaveFormatintGets the save file format. The value of the property is SaveFormat integer constant.
ClearDatabooleanMake the workbook empty after saving the file.
CachedFileFolderStringThe cached file folder is used to store some large data.
ValidateMergedAreasbooleanIndicates whether validate merged cells before saving the file. The default value is false.
MergeAreasbooleanIndicates whether merge the areas of conditional formatting and validation before saving the file. The default value is
CreateDirectorybooleanIf true and the directory does not exist, the directory will be automatically created before saving the file. The defaul
SortNamesbooleanIndicates whether sorting defined names before saving file.
SortExternalNamesbooleanIndicates whether sorting external defined names before saving file.
RefreshChartCachebooleanIndicates whether refreshing chart cache data
CheckExcelRestrictionboolean
UpdateSmartArtbooleanIndicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSm
EncryptDocumentPropertiesboolean

Methods

NameDescription
setImageResampleSets desired PPI(pixels per inch) of resample images and jpeg quality. All images will be converted to JPEG with the spe

PdfSaveOptions()

Creates the options for saving pdf file.

PdfSaveOptions.EmbedStandardWindowsFonts property

True to embed true type fonts. Affects only ASCII characters 32-127. Fonts for character codes greater than 127 are always embedded. Fonts are always embedded for PDF/A-1a, PDF/A-1b standard. Default is true.

Type: boolean

PdfSaveOptions.Bookmark property

Gets and sets the PdfBookmarkEntry object.

Type: PdfBookmarkEntry

PdfSaveOptions.Compliance property

Gets or sets the PDF standards compliance level for output documents. The value of the property is PdfCompliance integer constant. Default is Pdf17.

Type: int

PdfSaveOptions.SecurityOptions property

Set this options, when security is need in xls2pdf result.

Type: PdfSecurityOptions

PdfSaveOptions.ImageType property

Represents the image type when converting the chart and shape . NOTE: This member is now obsolete. Instead, Chart and Shape are always rendered as vector elements(e.g. point, line) for rendering quality. This property will be removed 12 months later since June 2022. Aspose apologizes for any inconvenience you may have experienced.

Type: ImageFormat

PdfSaveOptions.CalculateFormula property

Indicates whether to calculate formulas before saving pdf file. The default value is false.

Type: boolean

PdfSaveOptions.PdfCompression property

Indicate the compression algorithm The value of the property is PdfCompressionCore integer constant.

Type: int

PdfSaveOptions.CreatedTime property

Gets and sets the time of generating the pdf document. if it is not be set, it will be the time of generating the pdf.

Type: DateTime

PdfSaveOptions.Producer property

Gets and sets producer of generated pdf document. If the value is null, or a valid LICENSE is not set, string Aspose.Cells vVERSION will be used.

Type: String

PdfSaveOptions.OptimizationType property

Gets and sets pdf optimization type. The value of the property is PdfOptimizationType integer constant. Default value is PdfOptimizationType.STANDARD

Type: int

PdfSaveOptions.CustomPropertiesExport property

Gets or sets a value determining the way CustomDocumentPropertyCollection are exported to PDF file. Default value is None. The value of the property is PdfCustomPropertiesExport integer constant.

Type: int

PdfSaveOptions.ExportDocumentStructure property

Indicates whether to export document structure.

Type: boolean

PdfSaveOptions.DisplayDocTitle property

Indicates whether the window’s title bar should display the document title. If false, the title bar should instead display the name of the PDF file. Default value is false.

Type: boolean

PdfSaveOptions.FontEncoding property

Gets or sets embedded font encoding in pdf. The value of the property is PdfFontEncoding integer constant. Default value is PdfFontEncoding.IDENTITY

Type: int

PdfSaveOptions.Watermark property

Gets or sets watermark to output.

Type: RenderingWatermark

PdfSaveOptions.EmbedAttachments property

Indicates whether to embed attachment for Ole objects in Excel. Default value is false. The value must be false when PDF/A compliance is set or pdf encryption is enabled.

Type: boolean

PdfSaveOptions.ZoomBehavior property

The value of the property is PdfZoomBehavior integer constant.

Type: int

PdfSaveOptions.ZoomFactor property

Type: int

PdfSaveOptions.DefaultFont property

When characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf,image. Set the DefaultFont such as MingLiu or MS Gothic to show these characters. If this property is not set, Aspose.Cells will use system default font to show these unicode characters.

Type: String

PdfSaveOptions.CheckWorkbookDefaultFont property

When characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf,image. Set this to true to try to use workbook’s default font to show these characters first. Default is true.

Type: boolean

PdfSaveOptions.CheckFontCompatibility property

Indicates whether to check font compatibility for every character in text. The default value is true. Disable this property may give better performance. But when the default or specified font of text/character cannot be used to render it, unreadable characters(such as block) maybe occur in the generated pdf. For such situation user should keep this property as true so that alternative font can be searched and used to render the text instead;

Type: boolean

PdfSaveOptions.IsFontSubstitutionCharGranularity property

Indicates whether to only substitute the font of character when the cell font is not compatibility for it. Default is false. We will try default font of Workbook and PdfSaveOption/system for cell font first.

Type: boolean

PdfSaveOptions.OnePagePerSheet property

If OnePagePerSheet is true , all content of one sheet will output to only one page in result. The paper size of pagesetup will be invalid, and the other settings of pagesetup will still take effect.

Type: boolean

PdfSaveOptions.AllColumnsInOnePagePerSheet property

If AllColumnsInOnePagePerSheet is true , all column content of one sheet will output to only one page in result. The width of paper size of pagesetup will be ignored, and the other settings of pagesetup will still take effect.

Type: boolean

PdfSaveOptions.IgnoreError property

Indicates if you need to hide the error while rendering. The error can be error in shape, image, chart rendering, etc.

Type: boolean

PdfSaveOptions.OutputBlankPageWhenNothingToPrint property

Indicates whether to output a blank page when there is nothing to print. Default is true.

Type: boolean

PdfSaveOptions.PageIndex property

Gets or sets the 0-based index of the first page to save. Default is 0.

Type: int

PdfSaveOptions.PageCount property

Gets or sets the number of pages to save. Default is System.Int32.MaxValue which means all pages will be rendered..

Type: int

PdfSaveOptions.PrintingPageType property

Indicates which pages will not be printed. The value of the property is PrintingPageType integer constant. If content in the sheet is sparse, there will be some pages are totally blank in the output pdf file. If you don’t want these blank pages, you can use this option to omit them.

Type: int

PdfSaveOptions.GridlineType property

Gets or sets gridline type. The value of the property is GridlineType integer constant. Default is Dotted type.

Type: int

PdfSaveOptions.GridlineColor property

Type: Color

PdfSaveOptions.TextCrossType property

Gets or sets displaying text type when the text width is larger than cell width. The value of the property is TextCrossType integer constant.

Type: int

PdfSaveOptions.DefaultEditLanguage property

Gets or sets default edit language. The value of the property is DefaultEditLanguage integer constant. It may display/render different layouts for text paragraph when different edit languages is set. Default is DefaultEditLanguage.AUTO .

Type: int

PdfSaveOptions.SheetSet property

Gets or sets the sheets to render. Default is all visible sheets in the workbook: SheetSet.Visible .

Type: SheetSet

PdfSaveOptions.DrawObjectEventHandler property

Implements this interface to get DrawObject and Bound when rendering.

Type: DrawObjectEventHandler

PdfSaveOptions.PageSavingCallback property

Control/Indicate progress of page saving process.

Type: IPageSavingCallback

PdfSaveOptions.EmfRenderSetting property

Setting for rendering Emf metafile. The value of the property is EmfRenderSetting integer constant. EMF metafiles identified as “EMF+ Dual” can contain both EMF+ records and EMF records. Either type of record can be used to render the image, only EMF+ records, or only EMF records. When EmfRenderSetting.EMF_PLUS_PREFER is set, then EMF+ records will be parsed while rendering to page, otherwise only EMF records will be parsed. Default value is EmfRenderSetting.EMF_ONLY .

Type: int

PdfSaveOptions.CustomRenderSettings property

Type: CustomRenderSettings

PdfSaveOptions.SaveFormat property

Gets the save file format. The value of the property is SaveFormat integer constant.

Type: int

PdfSaveOptions.ClearData property

Make the workbook empty after saving the file.

Type: boolean

PdfSaveOptions.CachedFileFolder property

The cached file folder is used to store some large data.

Type: String

PdfSaveOptions.ValidateMergedAreas property

Indicates whether validate merged cells before saving the file. The default value is false.

Type: boolean

PdfSaveOptions.MergeAreas property

Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is false.

Type: boolean

PdfSaveOptions.CreateDirectory property

If true and the directory does not exist, the directory will be automatically created before saving the file. The default value is false.

Type: boolean

PdfSaveOptions.SortNames property

Indicates whether sorting defined names before saving file.

Type: boolean

PdfSaveOptions.SortExternalNames property

Indicates whether sorting external defined names before saving file.

Type: boolean

PdfSaveOptions.RefreshChartCache property

Indicates whether refreshing chart cache data

Type: boolean

PdfSaveOptions.CheckExcelRestriction property

Type: boolean

PdfSaveOptions.UpdateSmartArt property

Indicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSmartArt() method and the cached shapes exist in the template file.

Type: boolean

PdfSaveOptions.EncryptDocumentProperties property

Type: boolean

setImageResample(desiredPPI, jpegQuality)

Sets desired PPI(pixels per inch) of resample images and jpeg quality. All images will be converted to JPEG with the specified quality setting, and images that are greater than the specified PPI (pixels per inch) will be resampled.

ParameterTypeDescription
desiredPPIintDesired pixels per inch. 220 high quality. 150 screen quality. 96 email quality.
jpegQualityint0 - 100% JPEG quality.