Winnovative PDF Next Library for .NET Documentation
Excel
This class encapsulates the options to control the PDF document redering process.
The ExcelToPdfConverter class defines a reference to an object of this type
Definition
Namespace: Winnovative.Pdf.Next
Assembly: Winnovative.Pdf.Next.ExcelToPdf (in Winnovative.Pdf.Next.ExcelToPdf.dll) Version: 20.0.0
Assembly: Winnovative.Pdf.Next.ExcelToPdf (in Winnovative.Pdf.Next.ExcelToPdf.dll) Version: 20.0.0
C#
public class ExcelToPdfDocumentOptions- Inheritance
- Object ExcelToPdfDocumentOptions
Properties
| AutoResizePdfPageHeight | Automatically resize PDF page height to match content height. The default value is false |
| BottomMargin | The rendered PDF document bottom margin in points. 1 point is 1/72 inch. This property is used only when UsePageSettingsFromExcel is set to false. By default the left margin is 0 |
| ConvertOnlyFirstWorksheet | Gets or sets a value indicating whether only the first worksheet of the workbook should be converted. When false, all worksheets in the workbook are converted. The default value is false |
| DisplayWorksheetTitle | Gets or sets a value indicating whether the worksheet title is displayed at the top of each worksheet in the PDF document. The default value is true |
| EnableHeaderFooter | Indicates whether internal capabilities will be used to generate the header and footer based on the HeaderTemplate and FooterTemplate properties. This provides basic support for adding HTML with page numbering in the header and footer. For more advanced options, use the PdfHtmlHeader and PdfHtmlFooter properties instead. The default value is false. |
| FooterTemplate | The HTML template used for the PDF document footer. It should be valid HTML markup and may include the following CSS classes to inject dynamic values: date (formatted print date), title (document title), pageNumber (current page number) and totalPages (total number of pages). For example, <span class="title"></span> will render a span containing the document title. This template is used only if the EnableHeaderFooter property is true. For advanced scenarios, use the PdfHtmlFooter property. If null or empty, a default template will be applied. |
| HeaderTemplate | The HTML template used for the PDF document header. It should be valid HTML markup and may include the following CSS classes to inject dynamic values: date (formatted print date), title (document title), pageNumber (current page number) and totalPages (total number of pages). For example, <span class="title"></span> will render a span containing the document title. This template is used only if the EnableHeaderFooter property is true. For advanced scenarios, use the PdfHtmlHeader property. If null or empty, a default template will be applied. |
| LeftMargin | The rendered PDF document left margin in points. 1 point is 1/72 inch. This property is used only when UsePageSettingsFromExcel is set to false. By default the left margin is 0 |
| PageBreakBetweenWorksheets | Gets or sets a value indicating whether each worksheet starts on a new PDF page. The default value is true |
| PageNumberLimit | The maximum number of PDF pages to generate from conversion. The default value is 0 and the entire Excel document will be converted to PDF |
| PdfHtmlFooter | The generated PDF document footer based on a HTML template given by Html and HtmlBaseUrl properties or by the HtmlSourceUrl property |
| PdfHtmlHeader | The generated PDF document header based on a HTML template given by Html and HtmlBaseUrl properties or by the HtmlSourceUrl property |
| PdfPageOrientation | This property controls the orientation of the pages of the PDF document generated by the Excel to PDF converter. This property is used only when UsePageSettingsFromExcel is set to false. The default orientation is Portrait |
| PdfPageSize | This property controls the page size of the PDF document generated by the Excel to PDF converter. This property is used only when UsePageSettingsFromExcel is set to false. The default page size is A4 |
| RightMargin | The rendered PDF document right margin in points. 1 point is 1/72 inch. This property is used only when UsePageSettingsFromExcel is set to false. By default the left margin is 0 |
| TopMargin | The rendered PDF document top margin in points. 1 point is 1/72 inch. This property is used only when UsePageSettingsFromExcel is set to false. By default the left margin is 0 |
| UseFirstWorksheetPageSettings | Applies only when UsePageSettingsFromExcel is true. If true, page settings from the first worksheet are used for all worksheets. If false, page settings from the workbook's active worksheet are used for all worksheets (if an active worksheet is set). Has no effect when UsePageSettingsFromExcel is false. The default value is true |
| UsePageSettingsFromExcel | Gets or sets a value indicating whether to import page setup settings (paper size, margins, orientation) from the workbook and apply them to PdfDocumentOptions before rendering. The default value is true |
| Zoom | Gets or sets the Excel viewer zoom percentage as a positive number between 0 and 200. The default value of this property is 100 |
Methods
| AddEndPdf(Byte) | Add a PDF to the list of documents to be included after the converted HTML content in the final PDF |
| AddEndPdf(String) | Add a PDF from a file to the list of documents to be included after the converted HTML content in the final PDF |
| AddHtmlTemplate(Int32, Int32, Int32, String) | Creates a HTML Template object based on the HTML string and an optional base URL. The height of template is auto-resized. To create a template with fixed height use the method with height parameter |
| AddHtmlTemplate(Int32, Int32, Int32, Int32, String) | Creates a HTML Template object based on URL from which the HTML content should be retrieved. The height of template is fixed. If AutoResizeHeight is true, the HTML content may be scaled down to fit the specified height |
| AddHtmlTemplate(Int32, Int32, Int32, String, String) | Creates a HTML Template object to be rendered in PDF pages based on the HTML string and an optional base URL. The height of template is auto-resized. To create a template with fixed height use the method with height parameter |
| AddHtmlTemplate(Int32, Int32, Int32, Int32, String, String) | Creates a HTML Template object to be rendered in PDF pages based on the HTML string and an optional base URL. The height of template is fixed. If AutoResizeHeight is true, the HTML content may be scaled down to fit the specified height |
| AddHtmlTemplate(Int32, Int32, Int32, PdfTemplateHorizontalAlign, PdfTemplateVerticalAlign, String) | Creates a HTML Template object based on the HTML string and an optional base URL. Specifies the horizontal and the vertical alignment of the template on the PDF page. The alignment takes precedence over the X and Y coordinates when set to a value other than None. The height of template is auto-resized. To create a template with fixed height use the method with height parameter |
| AddHtmlTemplate(Int32, Int32, Int32, Int32, PdfTemplateHorizontalAlign, PdfTemplateVerticalAlign, String) | Creates a HTML Template object based on URL from which the HTML content should be retrieved. Specifies the horizontal and the vertical alignment of the template on the PDF page. The alignment takes precedence over the X and Y coordinates when set to a value other than None. The height of template is fixed. If AutoResizeHeight is true, the HTML content may be scaled down to fit the specified height |
| AddHtmlTemplate(Int32, Int32, Int32, PdfTemplateHorizontalAlign, PdfTemplateVerticalAlign, String, String) | Creates a HTML Template object to be rendered in PDF pages based on the HTML string and an optional base URL. Specifies the horizontal and the vertical alignment of the template on the PDF page. The alignment takes precedence over the X and Y coordinates when set to a value other than None. The height of template is auto-resized. To create a template with fixed height use the method with height parameter |
| AddHtmlTemplate(Int32, Int32, Int32, Int32, PdfTemplateHorizontalAlign, PdfTemplateVerticalAlign, String, String) | Creates a HTML Template object to be rendered in PDF pages based on the HTML string and an optional base URL. Specifies the horizontal and the vertical alignment of the template on the PDF page. The alignment takes precedence over the X and Y coordinates when set to a value other than None. The height of template is fixed. If AutoResizeHeight is true, the HTML content may be scaled down to fit the specified height. |
| AddStartPdf(Byte) | Add a PDF from a memory buffer to the list of documents to be included before the converted Excel content in the final PDF |
| AddStartPdf(String) | Add a PDF from a file to the list of documents to be included before the converted HTML content in the final PDF |
| Equals | (Inherited from Object) |
| Finalize | (Inherited from Object) |
| GetHashCode | (Inherited from Object) |
| GetType | (Inherited from Object) |
| MemberwiseClone | (Inherited from Object) |
| ToString | (Inherited from Object) |