create excel .net user interface - Document Solutions for Excel, .NET Edition

Description: a table or pivot table. Add built-in and custom slicer styles in Excel workbooks to create interactive reports. Comments- DsExcel enables users to write Comments for cells to add metadata information about ... applications. Excel Form Controls- Create Excel forms with standard Form controls and collect data from your users. Pivot Tables- Add Pivot Table to Excel workbook for data summarization and aggregation, ... features to/from SpreadJS- Seamless import and export of SpreadJS file format (.sjs) to Excel files using.NET and various Open/Save options available. Printing and PDF Export Features Forms- Create AcroForm ...

Screenshots: DsExcel.NET models its interface-based API on Excel's document object model. This means that users can import, calculate, query, generate, and export any spreadsheet scenario as and when ...

Screenshots: DsExcel.NET provides users with the ability to display aggregated data in a spreadsheet using pivot tables- a data summarization tool that can perform complex analysis of information stored in cells ...

Screenshots: Create matrix-like spreadsheet reports, complete with calculations, figures, sparklines, tables, and color themes. 0 ...

Release Notes: Chart. Direct Acroform Creation with DsExcel API- Introduced a new feature that allows users to create Acroforms directly using the DsExcel API when exporting spreadsheets to PDF. A new property, ... Export CSS with the style tag in HTML. Inline: Export CSS with the style attribute inside HTML elements. Set the First Page Number to 'Auto' in the Page Setup- When printing an Excel sheet, users ... formatting properties to the ITrendline interface to enhance the visual interpretation of trendlines. A new property, DataLabel, has been added to the ITrendline interface, allowing users to access the data ...

Release Notes: Adds support for dynamic array formulas along with several new calc engine functions. Dynamic Array Formulas GcExcel adds extensive support for adding dynamic array formulas to Microsoft Excel files ... 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 ... 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' ...

Release Notes: Create Excel Reports using Templates Create Microsoft Excel Reports using Templates- GcExcel introduces new template support with a comprehensive syntax and API to bind Excel documents to data ... 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 ... 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 ...

Release Notes: users to bypass errors and prevent the display of the green triangle at the top-left corner of a cell in Excel, DsExcel has introduced the IgnoredError property within the IRange interface. This property, ... is supported during Excel I/O, SpreadJS I/O, and SSJSON I/O. Support Table Reference in Cross Workbook Formulas- In large and complex Excel files, it is typical for formulas to incorporate references to data ... in other workbooks, whether internal or external. The conventional method of manually opening external workbooks, copying data, and integrating it into the Excel file is unnecessary. Instead, a more ...

Release Notes: fails to create json from the excel file. 0 ... value when using COUNT function with comma at last in GcExcel. NullPointerException when Deleting the Sheet from workbook using GcExcel API. Workbook corrupted after saving using GcExcel API. GCExcel ...

Release Notes: "=EDATE(NOW(),1)" calculated by GcExcel is different from Excel. NumberFormatException is thrown on loading a particular excel file with user.language=de. It takes too much time on opening a workbook. The grouped ... the original JSON file in the exported JSON. Exception is thrown on reading the JSON file. The exported Excel file is corrupted after deleting rows using GcExcel API. It takes too much time on calling the ToJson ... using GcExcel API. NullPointerException is thrown on copying a range from a specific Excel file to a new workbook using GcExcel API. The result in exported Excel file is incorrect after using ...

Release Notes: Adds Import data function which only imports data from Excel files, without loading the whole object model. Added support for Linked Pictures- Combining charts, data tables, conditional formatting, ... etc. all in one sheet can be complex. Since the size of these elements is often not uniform, presenting them in a single dashboard sheet can be difficult to accommodate. A linked picture can be created ... to the table changes. Added support for Microsoft Excel threaded comments which allow you to reply to inline or nested comments, as well as string several comments, together to form a conversation style thread. ...

Release Notes: template support: create Excel reports with tables, sparklines, fixed layout, and PDF forms. More pivot table enhancements. Shape z-order support. More features for SpreadJS integration. Image quality ... Adds the ability to export Excel spreadsheets and Excel ranges to HTML. Added additional functionalities to existing API to help you generate more secure Microsoft Excel reports with digital ... signatures, as well as converting them to other formats. The main highlights of this release are: Export Excel spreadsheets and Excel ranges to HTML. Digital signatures support in Excel spreadsheets. Enhanced ...

Release Notes: Define fixed layout for Microsoft Excel reports and fill data in a specific range. Support for exporting workbook/worksheet/ranges to HTML. Support for Digital Signatures API: add and sign signature lines, ... Adds support for generating PDF Forms from Excel templates. Support for generating PDF Forms from Microsoft Excel templates. Support for using sparklines and tables in Microsoft Excel templates. ... add and sign non-visible signatures, verify signatures, etc. Pivot Table enhancements: create multiple files from one pivot field, defer updating, sorting, field layout settings, etc. Support adjustment ...

Release Notes: Excel file. Freezing range changed after saving existing excel via GcExcel API. The image can not display when opening GcExcel exported HTML in QQ and outlook mailbox. The image border is wrong ... and then save an Excel with auto filter, an error occurs. IRR formula calculation result is different with Excel. Cell B2's value is different with Excel. Gradient and pattern fill are lost after GcExcel ... It takes a long time to load a ssjson. Cell value is wrong when opening Excel with DoNotCalculateAfterOpened is true. Exception is thrown after opening and saving Excel file. When ...

Release Notes: Add background images to worksheets. Add rich text to spreadsheet cells- You can set various font properties on the cell text through the API, and rich text is supported during Excel I/O, JSON I/O ... and PDF exporting. You can create rich text and then configure the font for a range of text characters; or add, enumerate, operate and configure all text runs of the rich text. Load, save, and preserve ... Excel files containing macros (I/O.xslm)- The macros are not executed, but are preserved when any operation is performed on the Excel file or during import/export. Add background image to worksheet- Set ...

Release Notes: There are four options in the enum that the user can use accordingly to print the workbook: Duplex.Default indicates the printer's default duplex setting. Duplex.Simplex indicates Single-sided printing. ... Adds support for double-sided printing. Added support for double-sided printing. GcExcel.NET supports the Duplex enum in PrintOutOptions class to enable/disable double-sided printing on a page. ...

Release Notes: Adds new API to add Microsoft Excel Form Controls. Added new API to add Microsoft Excel Form Controls. Added support for CASCADESPARKLINE formula. Added the ability to define Paginated Templates ... Improved debugging with additional details in InvalidFormulaException. Added support for adding and rendering SVG images. Excel Form Controls 0 ...

Release Notes: are not the same as Excel file. ArgumentOutOfRangeException or NullReferenceException is thrown on using GcExcel API in multi-threaded environment when there's TEXT function in workbook. The picture's ... position is incorrect in the exporting PDF file when some column is hidden. Some borders are lost in the exported Excel file after loading SSJSON file. The fontsize of cell is incorrect after loading ... the JSON file. NullPointerException is thrown on loading JSON file. The bottom border is lost in the exported PDF file. The tick labels' orientation of chart is changed in the exported Excel file. ...

Release Notes: Mode of overflow/mask. Added the ability to modify passwords of Microsoft Excel Documents. [Pivot Table] Added support for Calculated Field. Added support for JSON data source for template language. ... views (JSON I/O). Added the Import Data Function to Import Table, Range, or Worksheet from Excel Files. Added support for TableSheet (JSON I/O). Converting the imported Excel to JSON breaks all formulas ... [Template language]The result of sum function is incorrect in the exported XLSX file. [Template language]The cell values are not expected in the exported Excel file. [Template language]The IF formula is lost ...

Release Notes: are not copied when copying entire rows contains merge area. Formula result is different from Excel in Chinese culture. NullPointerException is thrown on calling toJson method for user specific Excel. The result ... is changed when importing JSON file exported by SpreadJS. IndexOutOfBoundsException is thrown on exporting JSON file for specific Excel file. Exception is thrown on saving an Excel file exported by GcExcel. ... The exported Excel file is corrupted when it contains specific linked objects. The exported Excel file is corrupted when it contains dynamic array formulas. NullReferenceException is thrown on opening some excel ...