From Documentation

(Difference between revisions)
Jump to: navigation, search
m (Export Listbox/Grid)
m (PDF)
Line 27: Line 27:
====PDF====
====PDF====
-
<source lang="java" high="1,15">
+
<source lang="java" high="5,6">
@Command
@Command
public void exportGrid(@BindingParam("ref") Grid grid) throws Exception {
public void exportGrid(@BindingParam("ref") Grid grid) throws Exception {

Revision as of 07:47, 26 November 2012

Export Grid or Listbox to PDF or Excel

WarningTriangle-32x32.png This page is under construction, so we cannot guarantee the accuracy of the content!





  • Author
    Sam Chuang, Engineer, Potix Corporation
  • Date
    November 26, 2012
  • Version
    ZK 6.0 and later

Contents

Introduction

Web application developers often require to transform data into different format. For instance, to PDF format that enhance read accessibility and to Excel format that can further analyze data. This smalltalk is going to introduce a easy way that can transform from Grid or Listbox to PDF/Excel.

Demo

Grid/Listbox
Export Grid or Listbox to PDF or Excel demo.png

PDF
Export Grid or Listbox to PDF or Excel PDF Format.png

Excel
Export Grid or Listbox to PDF or Excel Excel Format.png

Usage

Export Listbox/Grid

As you can see the following sample code. Export Listbox/Grid to PDF or Excel is quite straightforward.

PDF

	@Command
	public void exportGrid(@BindingParam("ref") Grid grid) throws Exception {
		ByteArrayOutputStream out = new ByteArrayOutputStream();
		
		PdfExporter exporter = new PdfExporter();
		exporter.export(grid, out);
		
		AMedia amedia = new AMedia("FirstReport.pdf", "pdf", "application/pdf", out.toByteArray());
		Filedownload.save(amedia);		
		out.close();
	}

Excel

	@Command
	public void exportListboxToExcel(@BindingParam("ref") Listbox listbox) throws Exception {
		ByteArrayOutputStream out = new ByteArrayOutputStream();
		
		ExcelExporter exporter = new ExcelExporter();
		exporter.export(listbox, out);
		
		AMedia amedia = new AMedia("FirstReport.xlsx", "xls", "application/file", out.toByteArray());
		Filedownload.save(amedia);
		out.close();
	}

Export data by Renderer

Summary

Download

  • The demo web application can be downloaded here - Github
  • The export.jar can be downloaded here- Github


Comments



Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.