Released: Oct 30, 2019

Updates in 3

Features

• 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
• Conversion of Excel Spreadsheets with Charts to PDF - GcExcel can convert Excel documents containing Column, Line, Pie, Bar, Area, XYScatter, Stock, Radar, and Combo charts to PDF.
• Conversion of Excel Spreadsheets with Slicers to PDF - With the v3 release, spreadsheets using slicers are now exported to PDF.
• 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.