Export to PDF

PDF Exporter

In addition to the Excel format, you can also export a book model as a PDF file with io.keikai.api.Exporter

Example to export as a PDF

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
package io.keikai.essential;

import java.io.*;

import org.zkoss.util.media.AMedia;
import org.zkoss.zk.ui.Component;
import org.zkoss.zk.ui.select.SelectorComposer;
import org.zkoss.zk.ui.select.annotation.*;
import io.keikai.api.*;
import io.keikai.api.model.Book;
import io.keikai.ui.Spreadsheet;
import org.zkoss.zul.*;

public class ExportPdfComposer extends SelectorComposer<Component> {

    @Wire
    private Spreadsheet ss;
    @Wire("combobox")
    private Combobox combobox;

    Exporter exporter = Exporters.getExporter("pdf");
    
    
    @Listen("onClick = #exportPdf")
    public void doExport() throws IOException{
        Book book = ss.getBook();
        
        File file = File.createTempFile(Long.toString(System.currentTimeMillis()),"temp");
        FileOutputStream fos = null;
        try {
            fos = new FileOutputStream(file);
            exporter.export(book, file);
        }finally{
            if(fos!=null){
                fos.close();
            }
        }
        Filedownload.save(new AMedia(book.getBookName()+".pdf", "pdf", "application/pdf", file, true));
    }

    //omit some code for brevity
}

Line 21: Get an Exporter instance for PDF format.

Export Server Setup

The default chart engine is ZK Charts. With this engine, exporting spreadsheets that include charts to PDF needs extra export server chart data rendering at the server side. The easiest way is to adopt Highcharts official solution which is based on PhantomJS, a headless Webkit browser.

  1. download and install PhantomJS here.

  2. download Highcharts project here
    1. in this project, go to exporting-server -> phantomjs
  3. start export server by commanding “phantomjs highcharts-convert.js -host 127.0.0.1 -port 3003”
    1. you should move the PhantomJS executable file into this folder
      1. On Windows, the full name is phantomjs.exe
      2. On Mac or Linux, the full name is phantomjs
    2. you can customize host and port respectively by parameter -host and -port
  4. add properties into zk.xml
    1. there are three library properties to be used

Library properties about export server

This is the location to export server. When it doesn’t find this definition, JFreechart will be used to generate chart graphs. (Required)

1
2
3
4
<library-property>
    <name>io.keikai.chart.render.server.url</name>
    <value>http://127.0.0.1:3003</value>
</library-property>

Scale is a zoom factor that affects pixel density relative to the original, for example, 2 means double the resolution of the original. (Optional)

1
2
3
4
<library-property>
    <name>io.keikai.chart.render.server.scale</name>
    <value>1</value>
</library-property>

Default timeout is 10000 milliseconds (10 seconds) for waiting response from export server. (Optional)

1
2
3
4
<library-property>
    <name>io.keikai.chart.render.server.timeout</name>
    <value>10000</value>
</library-property>

After restarting server, ZK Charts will be shown when exporting PDF.

Load Excel Printing Setup

Spreadsheet exports its book model to a PDF file according to the page print setup you specify in Excel.

center

For example, you can add a header and footer, and it would look like:

center

You can also scale a sheet to fit into one page with row and column heading: center

Supported Page Setup

The page setup properties of Excel which are supported by Spreadsheet are listed below:

Page

  • Orientation
    • Portrait, Landscape
  • Scaling
    • Adjust to % normal size
    • Fit to pages wide by tall
  • Page size
  • First page number

Margins

  • Top
  • Header
  • Right
  • Footer
  • Bottom
  • Left

Center on Page

  • Horizontally
  • Vertically

Breaks

Header/Footer

  • Custom Header…
  • Custom Footer…
  • Different odd and even pages
  • Different first page

Sheet

  • Print area
  • Print titles
    • Rows to repeat at top
    • Columns to repeat at left
  • Print
    • Gridlines
    • Row and column headings
  • Page order
    • Down, then over
    • Over, then down

Comments