FlexGrid
Group
The sample demonstrates how to export FlexGrid content to a PDF file. Grouping support.
Features
Sample
Export Settings:
Security settings:
Permissions (require owner password)
Description
This sample shows how the row grouping feature of the FlexGrid is supported in the FlexGridPdfConverter.
You can use the FlexGridPdfConverter, a PDFKit-based JavaScript library, to export FlexGrid to PDF (Portable Document Format) without using any server-side code.
To export a FlexGrid, you need to use the FlexGridPdfConverter.export function that takes the following arguments:
- embeddedFonts: Provides information to the export library, about various custom fonts to be embedded, such as URL, name, style, weight.
- styles: It is used to set up the style for the grid elements and link them with the embedded fonts.
- Export settings.
In this sample, you can change the following export settings using the menus above:
- scaleMode: Determines how the FlexGrid content should be scaled in order to fit the page.
- orientation: Determines the orientation of pages.
- exportMode: Determines which part of the FlexGrid should be exported (all of the data or only the current selection).
You can also specify some security settings, such as user password, owner password and permissions, to protect the exported PDF content.
Source
PDFExportGroupController.cs
using C1.Web.Mvc; using C1.Web.Mvc.Grid; using MvcExplorer.Models; using System; using System.Collections.Generic; using System.Linq; using System.Web.Mvc; using C1.Web.Mvc.Serialization; namespace MvcExplorer.Controllers { public partial class FlexGridController : Controller { private static IEnumerable<Sale> pdfExportGroupData = Sale.GetData(500); public ActionResult PDFExportGroup() { ViewBag.GroupedFlexGridData = pdfExportGroupData; return View(); } } }
PDFExportGroup.cshtml
@using C1.Web.Mvc.Grid @{ IEnumerable<Sale> groupedFlexGridData = ViewBag.GroupedFlexGridData; } @section Styles{ <style> .fixed-top { z-index: 999; position: fixed; top: 0px; } .reduce { padding-bottom: 0px; } </style> } @section Scripts{ <script> var groupedGrid, exportSettings, settingsDiv, securitySettingsDiv; c1.documentReady(function () { groupedGrid = wijmo.Control.getControl("#groupingFlexGrid"); settingsDiv = document.getElementById("exportSettingsDiv"); securitySettingsDiv = document.getElementById("securitySettingsDiv"); exportSettings = { exportMode: wijmo.grid.pdf.ExportMode.All, orientation: wijmo.pdf.PdfPageOrientation.Portrait, scaleMode: wijmo.grid.pdf.ScaleMode.ActualSize, version: "v1_4", }; }); function setScaleMode(menu) { menu.header = "@(Resources.FlexGrid.PDFExport_ScaleMode): <b>" + menu.selectedItem.Header + "</b>"; exportSettings.scaleMode = wijmo.grid.pdf.ScaleMode[menu.selectedItem.Header]; } function setOrientation(menu) { menu.header = "@(Resources.FlexGrid.PDFExport_Orientation): <b>" + menu.selectedItem.Header + "</b>"; exportSettings.orientation = wijmo.pdf.PdfPageOrientation[menu.selectedItem.Header]; } function setExportMode(menu) { menu.header = "@(Resources.FlexGrid.PDFExport_ExportMode): <b>" + menu.selectedItem.Header + "</b>"; exportSettings.exportMode = wijmo.grid.pdf.ExportMode[menu.selectedItem.Header]; } function setPermissionPrinting(menu) { menu.header = "@Resources.FlexGrid.PDFExport_Printing: <b>" + menu.selectedItem.Header + "</b>"; exportSettings.permissionPrinting = menu.selectedItem.Header; } function setVersion(menu) { menu.header = "PDF version: <b>" + menu.selectedItem.Header + "</b>"; switch (menu.selectedItem.Header) { case "1.3": exportSettings.version = "v1_3"; break; case "1.4": exportSettings.version = "v1_4"; break; case "1.5": exportSettings.version = "v1_5"; break; case "1.6": exportSettings.version = "v1_6"; break; case "1.7": exportSettings.version = "v1_7"; break; case "1.7 ExtensionLevel 3": exportSettings.version = "v1_7Ext3"; break; } } function getPassword(user) { return document.querySelector('#tb' + user + 'Password').value; } function getPermission(permissionName) { if (permissionName == 'Printing') { return exportSettings.permissionPrinting || 'NotAllowed'; } else { return document.querySelector('#cb' + permissionName).checked; } } function exportGroupedGrid() { var fontFile = { source: 'https://demo.grapecity.com/wijmo/sample/fonts/ipaexg.ttf', name: 'ipaexg' }, font = new wijmo.pdf.PdfFont('ipaexg'); wijmo.grid.pdf.FlexGridPdfConverter.export(groupedGrid, 'FlexGrid.pdf', { maxPages: 10, exportMode: exportSettings.exportMode, scaleMode: exportSettings.scaleMode, documentOptions: { userPassword: getPassword('User'), ownerPassword: getPassword('Owner'), version: exportSettings.version, permissions: { annotating: getPermission('Annotating'), contentAccessibility: getPermission('ContentAccessibility'), copying: getPermission('Copying'), documentAssembly: getPermission('DocumentAssembly'), fillingForms: getPermission('FillingForms'), modifying: getPermission('Modifying'), printing: getPermission('Printing') }, pageSettings: { layout: exportSettings.orientation }, header: { declarative: { text: '&[Page]\\&[Pages]\theader\t&[Page]\\&[Pages]' } }, footer: { declarative: { text: '&[Page]\\&[Pages]\tfooter\t&[Page]\\&[Pages]' } }, info: { author: 'C1', title: 'PdfDocument sample', keywords: 'PDF, C1, sample', subject: 'PdfDocument' } }, embeddedFonts: [fontFile], styles: { cellStyle: { backgroundColor: '#ffffff', borderColor: '#c6c6c6', font: font }, altCellStyle: { backgroundColor: '#f9f9f9' }, groupCellStyle: { backgroundColor: '#dddddd' }, headerCellStyle: { backgroundColor: '#eaeaea' } } }); } </script> } <div class="copy well" id="exportSettingsDiv"> <b>@Html.Raw(Resources.FlexGrid.PDFExport_ExportSettings)</b> @(Html.C1().Menu().Header(Resources.FlexGrid.PDFExport_ScaleMode + ": <b>ActualSize</b>").OnClientItemClicked("setScaleMode") .MenuItems(items => { items.Add("ActualSize"); items.Add("PageWidth"); items.Add("SinglePage"); })) @(Html.C1().Menu().Header(Resources.FlexGrid.PDFExport_Orientation + ": <b>Portrait</b>").OnClientItemClicked("setOrientation") .MenuItems(items => { items.Add("Portrait"); items.Add("Landscape"); })) @(Html.C1().Menu().Header(Resources.FlexGrid.PDFExport_ExportMode + ": <b>All</b>").OnClientItemClicked("setExportMode") .MenuItems(items => { items.Add("All"); items.Add("Selection"); })) <div id="securitySettingsDiv"> <p></p> <b>@Html.Raw(Resources.FlexGrid.PDFExport_SecuritySettings)</b> <div class="panel-body reduce"> <div class="row"> <div class="col-sm-3"> <input type="text" id="tbUserPassword" class="form-control" placeholder="@Resources.FlexGrid.PDFExport_UserPassword" /> </div> <div class="col-sm-3"> <input type="text" id="tbOwnerPassword" class="form-control" placeholder="@Resources.FlexGrid.PDFExport_OwnerPassword" /> </div> </div> <br /> <div class="row"> <div class="col-sm-3"> @(Html.C1().Menu().Header("PDF version: <b>1.4</b>").OnClientItemClicked("setVersion") .MenuItems(items => { items.Add("1.3"); items.Add("1.4"); items.Add("1.5"); items.Add("1.6"); items.Add("1.7"); items.Add("1.7 ExtensionLevel 3"); }).SelectedIndex(1)) </div> </div> <div class="panel-body reduce"> <div class="row"> <div class="col"> <b>@Resources.FlexGrid.PDFExport_Permissions</b> (<i>@Resources.FlexGrid.PDFExport_PermissionsNote</i>) </div> </div> <div class="row"> <div class="col-sm-3"> <div class="checkbox"> <label><input type="checkbox" id="cbAnnotating" />@Resources.FlexGrid.PDFExport_Annotating</label> </div> <div class="checkbox"> <label><input type="checkbox" id="cbContentAccessibility" />@Resources.FlexGrid.PDFExport_ContentAccessibility</label> </div> <div class="checkbox"> <label><input type="checkbox" id="cbCopying" />@Resources.FlexGrid.PDFExport_Copying</label> </div> <div class="checkbox"> <label><input type="checkbox" id="cbDocumentAssembly" />@Resources.FlexGrid.PDFExport_DocumentAssembly</label> </div> <div class="checkbox"> <label><input type="checkbox" id="cbFillingForms" />@Resources.FlexGrid.PDFExport_FillingForms</label> </div> <div class="checkbox"> <label><input type="checkbox" id="cbModifying" />@Resources.FlexGrid.PDFExport_Modifying</label> </div> </div> </div> @(Html.C1().Menu().Header(Resources.FlexGrid.PDFExport_Printing + ": <b>NotAllowed</b>").OnClientItemClicked("setPermissionPrinting") .MenuItems(items => { items.Add("NotAllowed"); items.Add("AllowLowResolution"); items.Add("AllowHighResolution"); })) </div> </div> </div> </div> <button class="btn btn-default" onclick="exportGroupedGrid()">@Html.Raw(Resources.FlexGrid.PDFExport_Export)</button> <br /> @(Html.C1().FlexGrid<Sale>().Id("groupingFlexGrid") .Bind(groupedFlexGridData) .SelectionMode(SelectionMode.ListBox) .HeadersVisibility(HeadersVisibility.All) .ShowGroups(true) .GroupBy("Product", "Country", "Amount") .CssClass("grid") .AllowMerging(AllowMerging.All) .AutoGenerateColumns(false) .Columns(bl => { bl.Add(cb => cb.Binding("ID")); bl.Add(cb => cb.Binding("Start").Header("Start Date").Format("d")); bl.Add(cb => cb.Binding("End").Header("End Date").Format("d")); bl.Add(cb => cb.Binding("Country")); bl.Add(cb => cb.Binding("Product")); bl.Add(cb => cb.Binding("Amount").Header("Amount22").Format("c").Aggregate(Aggregate.Sum)); bl.Add(cb => cb.Binding("Color")); bl.Add(cb => cb.Binding("Amount2").Header("Pending").Format("c2")); bl.Add(cb => cb.Binding("Discount").Format("p1")); bl.Add(cb => cb.Binding("Active")); }) ) @section Summary{ <p>@Html.Raw(Resources.FlexGrid.PDFExport_Summary) @Html.Raw(Resources.FlexGrid.PDFExport_Title1).</p> } @section Description{ <p><b>@Html.Raw(Resources.FlexGrid.PDFExport_Text3)</b></p> <p>@Html.Raw(Resources.FlexGrid.PDFExport_Text0)</p> <p>@Html.Raw(Resources.FlexGrid.PDFExport_Text1)</p> <ul> <li>@Html.Raw(Resources.FlexGrid.PDFExport_Li1)</li> <li>@Html.Raw(Resources.FlexGrid.PDFExport_Li2)</li> <li>@Html.Raw(Resources.FlexGrid.PDFExport_Li3)</li> </ul> <p>@Html.Raw(Resources.FlexGrid.PDFExport_Text2)</p> <ul> <li>@Html.Raw(Resources.FlexGrid.PDFExport_Li4)</li> <li>@Html.Raw(Resources.FlexGrid.PDFExport_Li5)</li> <li>@Html.Raw(Resources.FlexGrid.PDFExport_Li6)</li> </ul> <p>@Html.Raw(Resources.FlexGrid.PDFExport_Text8)</p> }
Documentation