Click or drag to resize

ExcelToPdfArea Class

An Excel workbook drawn in a header or footer: its first page (or the page PageRanges names), rendered once at the size of the area and drawn on every page that shows the band, with its links.
Inheritance Hierarchy
SystemObject
  ExpertPdf.Anywhere.HtmlToPdfPdfElement
    ExpertPdf.Anywhere.HtmlToPdfExcelToPdfArea

Namespace: ExpertPdf.Anywhere.HtmlToPdf
Assembly: ExpertPdf.Anywhere (in ExpertPdf.Anywhere.dll) Version: 22.0
Syntax
public class ExcelToPdfArea : PdfElement

The ExcelToPdfArea type exposes the following members.

Constructors
 NameDescription
Public methodExcelToPdfArea(Stream)Creates an area that shows a workbook read from a stream, filling the band from its top left corner.
Public methodExcelToPdfArea(String)Creates an area that shows a Excel file, filling the band from its top left corner.
Public methodExcelToPdfArea(Single, Single, Stream)Creates an area that shows a workbook read from a stream, at a position in the band, to its right edge and bottom.
Public methodExcelToPdfArea(Single, Single, String)Creates an area that shows a Excel file, at a position in the band, to its right edge and bottom.
Public methodExcelToPdfArea(Single, Single, Single, Single, Stream)Creates an area that shows a workbook read from a stream in a rectangle of the band.
Public methodExcelToPdfArea(Single, Single, Single, Single, String)Creates an area that shows a Excel file in a rectangle of the band.
Top
Properties
 NameDescription
Public propertyAutoDetectComplexScriptGets or sets whether right-to-left and complex scripts are detected in text that does not say so. The default value is false.
Public propertyConvertBlankPagesGets or sets whether a page with nothing on it is drawn. The default value is false.
Public propertyConvertBlankSheetsGets or sets whether a sheet with nothing on it is drawn. The default value is false.
Public propertyFormat Gets or sets the format of the workbook. The default, Automatic, takes it from the file extension, or detects it from the content of a stream.
Public propertyGridLinesGets or sets whether the gridlines are drawn. The default follows each sheet's own print setting.
Public propertyHeightGets or sets the height of the area, in points; 0 or less reaches the bottom of the band.
Public propertyInternalLinksEnabledGets or sets whether the workbook's links to places in itself are live. The default value is true.
Public propertyLayoutGets or sets how each sheet is scaled onto the pages. The default is fitting each sheet on one page, since an area shows one page.
Public propertyLiveUrlsEnabledGets or sets whether the workbook's web links are live in the area. The default value is true.
Public propertyPageRangesGets or sets the page of the rendered workbook the area shows, for example "2". The default is the first page.
Public propertyPasswordGets or sets the password that opens an encrypted workbook.
Public propertySheetHeadersAndFootersGets or sets whether the sheets' own printed headers and footers are drawn. The default value is true.
Public propertyWidthGets or sets the width of the area, in points; 0 or less reaches the right edge of the band.
Public propertyWorksheetsGets or sets the sheets drawn, by name, separated by commas. The default is every visible sheet.
Public propertyXGets or sets the X position of the area in the band, in points.
Public propertyYGets or sets the Y position of the area in the band, in points.
Top
Remarks

Add it to the header or footer of the HTML to PDF converter with AddExcelToPdfArea(ExcelToPdfArea) / AddExcelToPdfArea(ExcelToPdfArea).

Every format the Excel to PDF converter reads is accepted: xlsx, xlsm, xltx, xltm, xls, xlt, csv, tsv, SpreadsheetML and markdown. The sheet is laid out on a page the size of the area, fitted onto it by default (Layout).

Example
PdfConverter pdfConverter = new PdfConverter();
pdfConverter.PdfDocumentOptions.ShowHeader = true;
pdfConverter.PdfHeaderOptions.HeaderHeight = 60;
pdfConverter.PdfHeaderOptions.AddExcelToPdfArea(new ExcelToPdfArea(0, 0, "sales.xlsx"));
byte[] pdf = pdfConverter.GetPdfBytesFromUrl("https://www.html-to-pdf.info");
See Also