GrapeCity Documents for Excel, Java Edition 4.2

添加对动态阵列公式的支持，并添加几个新的计算引擎功能。
8月 23, 2021
新版本

特性

  • Dynamic Array Formulas
    • GcExcel adds extensive support for adding dynamic array formulas to Microsoft Excel files through code. The new workbook.AllowDynamicArray will allow you to enable/disable the dynamic array formula in the worksheet. Once enabled, you can use these seven new functions and the dynamic array formula to give the results desired by your applications:
      • FILTER.
      • RANDARRAY.
      • SEQUENCE.
      • SINGLE.
      • SORT.
      • SORTBY.
      • UNIQUE.
    • Two new errors have also been added:
      • #Spill! - Indicates that a formula returns multiple results but can't return these values to neighboring cells.
      • #Calc! - Occurs when the calculation engine encounters a scenario it does not currently support.
  • Support for New Calc Engine Functions - The following new functions are now supported:
    • WEBSERVICE: helps to extract data from a webservice.
    • FILTERXML: returns specific data from XML.
    • ASC: changes full-width (double-byte) letters or katakana within a character string to half-width (single-byte) characters (helpful for JP and CN text).
    • DBCS: converts half-width (single-byte) letters within a character string to full-width (double-byte) characters (helpful for JP and CN text).
    • JIS: changes half-width (single-byte) letters or katakana within a character string to full-width (double-byte) characters.
    • XLOOKUP: supports approximate and exact matching, reverse search, and wildcards (* ?) for partial matches and searches in horizontal/vertical ranges.
    • XMATCH: performs a lookup and returns a position in vertical or horizontal ranges, supports approximate and exact matching, reverse search, and wildcards (* ?) for partial matches.
    • GcExcel introduces FormulaLocal and FormulaR1C1Local properties in IRange interface that work with the new ASC, DBCS, and JIS functions to retrieve or set localized formulas in the cells of a worksheet. These new properties work only on JP and CN cultures.
  • Support for External Workbook Links from the Web
    • With this release, workbooks on the web can now be referenced in an Excel workbook. When these workbooks are on the web, there is no need to manually open the workbooks and copy the data to use in the Excel file. Instead, reference the external workbook, eliminating any need for duplicate data entry or manual updates when data changes.
    • GcExcel adds support for adding web paths to external workbook links in the workbook. The IWorkbook.GetExcelLinkSources() function now supports the web path. Call the IWorkbook.UpdateExcelLinks() method to update the current workbook if data changes externally.
  • GcExcel Java now supports exporting charts to PDF - Chart utilization is an essential part of Excel spreadsheets. Most Excel documents for finance, sales, marketing and healthcare analyze data using Excel features to extract the summarized data. GcExcel now extends support for exporting charts to PDF in Java.
  • Document Properties for Workbook - GcExcel now supports new API to set Document Properties on the workbook. Some of these properties will also be supported on exporting to PDF.
    • The new IWorkbook.BuiltInDocumentPropertyCollection is a collection of built-in properties and users can modify the property value through workbook.BuiltInDocumentProperties.
    • The IWorkbook.CustomDocumentProperties is a collection of custom properties and users can use the 'Add' method to create new custom document property or the 'AddLinkToContent(..)' method to create a new document property that can link to named cells.
  • Get the Row and Column Grouping Information - GcExcel adds new API to get row and column grouping information through the List RowGroupInfo and List ColumnGroupInfo list types and with the help of this API, the following functionalities can be achieved:
    • Get the start index of the current group.
    • Get the end index of the group.
    • Get the level of current group.
    • Check whether the group is collapsed or not.
    • Get the parent row/column of the group.
    • Get child row/column of the group.
    • The Expand() or Collapse() methods can help to expand or collapse rows or columns.
  • Copy Hidden Rows to New Range - GcExcel adds new API IRange.Copy(IRange destination, PasteOption pasteOption) to copy hidden rows/columns. The API includes the additional property AllowPasteHiddenRange, which will control whether to copy the data of hidden rows/columns or not.
  • Control the Size of Exported JSON File - There are certain Excel files, which, if exported to JSON, produce large-sized files. It will now be possible to control the size of exported JSON files through the new SerializationOptions.IgnoreColumnRowInfoOutOfUsedRange option. This option will let you control whether to export the column row information out of the used range, which will help reduce the size of the exported JSON file.
  • Support Margin Settings for Text in a Shape - The Shape.TextFrame class now supports MarginBottom, MarginLeft, MarginTop and MarginRight properties to set the margins for text in shapes. This will give a better look to your Excel file and in addition, this support brings GcExcel closer to the Shape support provided in Microsoft Excel.
  • Expand/Collapse Grouped Items in Pivot Table - You can now programmatically Expand or Collapse grouped rows or columns in Pivot Tables by using the new IPivotItem.ShowDetail property to expand or collapse a grouped row/column. This will help you only view necessary details in long worksheets.
  • More features for GrapeCity SpreadJS Integration - GcExcel adds support for the following SpreadJS features adding more compatibility with the client-side SpreadJS product. Note, these features will work only with SpreadJS and PDF Export and are not supported in Microsoft Excel.
    • Support RowCount and ColumnCount in GcExcel for JSON I/O.
    • Get URL of a picture in JSON.
    • Support Pivot Table of SpreadJS through JSON I/O, Excel I/O and PDF Export.
    • Support for the following features:
      • Sheet TabStrip Position and properties.
      • Set size of Check Box, Check Box List and Radio Box List Cells.
      • hoverBackColor of Button Cell Type supported on JSON I/O.
      • buttonBackColor supported in JSON I/O and PDF Export.
      • New Options frozenTrailingColumnStickToEdge and frozenTrailingRowStickToEdge on JSON I/O.
GrapeCity Documents for Excel, Java Edition 4.2
WEBSERVICE function

Document Solutions for Excel, Java Edition

高速 Java Excel 电子表格 API 库。

索取报价 立即购买

有任何疑问吗?

透过Live Chat与我们的MESCIUS (formerly GrapeCity) 专家联络!