Create Microsoft Excel Reports using Templates - GcExcel introduces new template support with a comprehensive syntax and API to bind Excel documents to data to generate Excel reports with advanced layouts. Key Features:
Simple language syntax
Define data expansion direction
Define Context for data expansion
Define range of data
Add data from multiple data sources
Group your data
Outline Group
Specify nested data fields
Define Formula functions
Define Sort expression
Define Expression fields
Set Styles
Multiple reports in one sheet
Add page breaks
Set inline fields
Add template field in Worksheet's name to generate multiple worksheets
New Excel 2016 Chart Types - With the v3 release, GcExcel adds the ability to add new Excel 2016 chart types to Excel files:
Treemap
Sunburst
Histogram and Pareto
Waterfall
Funnel
Security Options when Saving to PDF - Now users can set these options through the PdfSaveOptions.SecurityOptions, converting documents to PDF using GCExcel.
Owner password
User Password
Print Permission
Fill Form Permission
Document Properties when Saving to PDF - These properties can now be set through PdfSaveOptions.DocumentProperties, while saving an Excel spreadsheet to PDF.
PdfVersion
EmbedStandardWindowsFonts
Title
Author
Subject
Keywords
Creator
Producer
CreationDate
ModifyDate
Protect Workbook - This feature protects the workbook from modification using the IWorkbook.Protect() method. Operations that can be protected are: viewing hidden worksheets, adding, moving, deleting, hiding, or renaming worksheets. Additional operations that can be protected are: resizing or closing the workbook window and hide/unhide windows.
Chart Sheet - This option helps users to add a chart sheet that contains only the chart in the worksheet. It is also helpful while printing the sheet, the page orientation can be changed to read the chart in detail.
Add More Shape Features - Hyperlinks and Group/Ungroup Shapes - In addition to adding shapes to Excel files, you also add different features to shapes including:
Add hyperlink to shapes
Group/ungroup shapes
Calculate Outline Subtotal - You can automatically group repeating data and define a subtotal by defining simple parameters.
Get Precedents and Dependents of Formula Cell - A formula can be applied on a specific cell or the formula may reference some cell range. Two new APIs can help retrieve which cell range will affect the current formula cell, or which cell range the current cell will affect.
Shape Adjustment - Shapes can be adjusted using IShape.Adjustments API by setting the adjustment points. The geometry of entire shapes can be changed uniformly.
Sheet Background Image to PDF - Now users have the option to include a background image while converting an Excel spreadsheet to PDF, or ignore it.
Export Excel Files with Multiple Images to PDF with Reduced File Size - If a picture is used multiple times in an Excel file, GcExcel will have only one copy of the picture when exporting to PDF, to reduce the file size.
License Workbook Instance - Now, user can license just one instance of the workbook (not all).
Rename Pivot Fields and Data Fields - Pivot fields are named as per the data source. Sometimes, additional naming is required for the row, column, page and data fields of a pivot table.
Support GrapeCity SpreadJS Features - To better integrate with GrapeCity SpreadJS products, this release adds additional properties to the GcExcel API. You can now create Excel documents and apply these properties. These are also supported on Import/Export SSJSON.