Exporting to PDF

SpreadJS supports PDF file export i.e. exporting a workbook (excel files with .xlsx extension) to PDF format (files with .pdf extension) via the savePDF method of the Workbook class.

The following table lists the parameters of the savePDF method:

Parameter	Description
successCallback	Call this function after export to pdf operation is successful.
errorCallback	Call this function when an error occurs.
options	You can choose from the following options while exporting to a PDF file: options.creator - You can specify the name of the application (for example : Adobe Framemaker) that created the original document from which it was converted. options.title - You can specify the title of the document options.author - You can specify the name of the person who created that document options.keywords - You can specify the keywords associated with the document options.subject - You can specify the subject of the document.
sheetIndex	You can export specific sheets in a workbook to PDF by specifying the sheet index of the sheet you want to export. If this argument is not given, all visible sheets will be exported by default.

The Export to PDF operation uses printInfo object for page setting and provides support for all the printing features that are available in SpreadJS.

For more information on custom export of PDF files, see Custom PDF Export.

While exporting to a PDF file, you can specify the font you want to embed in your PDF document. Users can embed both standard fonts (listed below) and the custom fonts (via registering a new font) for PDF export.

For more information on how to embed custom fonts while performing the Export to PDF operation, see Use Custom Font for PDF Export.

The following table lists the fourteen standard fonts that are supported in a PDF document:

Courier

Courier-Bold

Courier-Oblique

Courier-BoldOblique

Times

Times-Roman

Times-Bold

Times-Italic

Times-BoldItalic

Helvetica

Helvetica-Bold

Helvetica-Oblique

Helvetica-BoldOblique

Symbol

ZapfDingbats

Using Code

This example shows how to use the savePDF method to export Excel files to PDF files. The exported files are saved with a .pdf extension.

The first section of code lists the dependencies for executing the Export to PDF operation.

The second section of code illustrates how savePDF method can be used for exporting to PDF format.

JavaScript	Copy Code
<script src='.../spreadjs/gc.spread.sheets.all.x.xx.xxxxx.x.min.js' type='text/javascript'></script> <script src='.../spreadjs/plugins/gc.spread.sheets.print.x.xx.xxxxx.x.min.js' type='text/javascript'></script> <script src='.../spreadjs/plugins/gc.spread.sheets.pdf.x.xx.xxxxx.x.min.js' type='text/javascript'></script>

JavaScript

Copy Code

<script src='.../spreadjs/gc.spread.sheets.all.x.xx.xxxxx.x.min.js' type='text/javascript'></script>
<script src='.../spreadjs/plugins/gc.spread.sheets.print.x.xx.xxxxx.x.min.js' type='text/javascript'></script>
<script src='.../spreadjs/plugins/gc.spread.sheets.pdf.x.xx.xxxxx.x.min.js' type='text/javascript'></script>

JavaScript	Copy Code
spread.savePDF(function (blob) { var fileName = $('#fileName').val() \|\| 'download'; saveAs(blob, fileName + '.pdf'); }, function (error) { console.log(error); }, { title: 'Test Title', author: 'Test Author', subject: 'Test Subject', keywords: 'Test Keywords', creator: 'test Creator' });

Note: The following points should be kept in mind while exporting to PDF:

1) In order to export to an excel file, users need to reference the
file: gc.spread.sheets.pdf.*.*.*.min.js

2) Images are not base64 encoded. Hence, they may not be exported when a user makes use of file protocol schemes. It is necessary that users should use http or https protocol schemes while performing the export operation.