spreadsheet - Document Solutions for Excel, .NET Edition

Notas de la versión: Template Enhancements Enhanced Template language with better performance- The DsExcel Templates have been refactored, emphasizing enhanced performance and stability. The recent improvements include: Addressing the absence of a data source by treating it as null. Enabling OverwriteFillFormat ...

Notas de la versión: Some content in the hyperlink is escaped after loading the SJS file. The legend of chart in the exported PDF file is incorrect. The table range is not updated after data binding. Exception is thrown on exporting PDF file when workbook contains specific cell button. Exception is thrown on processing ...

Notas de la versión: The checkstatus of the checkbox is incorrect in the exported PDF file. Exception is thrown on exporting SJS file when data validation contains invalid formulas. Exception is thrown on getting cell value when the cell refers to non-existing worksheet. The formula changed after inserting a column ...

Notas de la versión: The captions of a Pivot Table item are reset after refreshing. Exception is thrown on exporting workbook to PDF file. Performance issue when copying cells to another workbook. The border in the exported HTML file is inconsistent with the display in SpreadJS. The processing time of the template has ...

Notas de la versión: The formula changes after inserting columns if the referenced worksheet does not exist. After importing SJS and SSJSON files exported by DsExcel into the SpreadJS designer, the charts appear differently. The cell value is incorrect after loading the SJS file exported by SpreadJS. The exported Excel ...

Descripción: High-speed Excel spreadsheet API for.NET. Document Solutions for Excel,.NET Edition (DsExcel, previously GcExcel) is a high-speed, small-footprint, server-side spreadsheet API that requires ... no dependencies on Excel. With full.NET support, you can generate, load, modify, and convert spreadsheets in.NET,.NET Framework,.NET Core, Mono, and Xamarin. Apps using the spreadsheet API can be deployed to cloud, ... object model which means you can import, calculate, query, generate, and export any spreadsheet scenario. Using DsExcel, you can programmatically create Excel reports, sorted and filtered tables, sorted ...

Notas de la versión: It takes more than 5 minutes to export specific SSJSON file to PDF. Unexpected diagonal border is exported in the XLSX file. The result of AGGREGATE formula is incorrect. The font style of shape is incorrect in the exported PDF file. The icon of conditional format in the exported HTML file is ...

Notas de la versión: 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, ...

Notas de la versión: After calling IWorksheet.copyAfter() method, an error occurs when opening the exported Excel file. Performance issue when calling IRange.Copy() method many times. The icon of conditional format in the exported PDF file is different from Excel and SpreadJS. Exception is thrown on copying sheet ...

Notas de la versión: Chart is not output correctly in PDF file when combo chart of scatter charts have no data. Exception is thrown on Workbook.processTemplate() method. The cell formatting is incorrect in the copied worksheet. Exception is thrown on calculating the function which refers to a non-exist worksheet. ...

Notas de la versión: There are unexpected lines in the exported Excel file after processing Template file. DataValidation Error Alert doesn't preserves after saving the Workbook. InvalidOperationException is thrown on specifying multiple ranges for a chart data source. The calculated result is inconsistent between ...

Notas de la versión: The result of XLOOKUP function is incorrect. The text wrapping position is inconsistent with SpreadJS. The picture is incorrect in the exported PDF file when picture has crop and rotation setting. The center header of printinfo is lost in the exported SSJSON file. Exception is thrown on loading the ...

Notas de la versión: The legend of deleted series in chart are displayed in the exported Excel file. Doughnut charts is lost in the exported PDF file. The wrap position is incorrect when text contains "-" charactor in the exported PDF file. The result of the formula in the defined name is not updated ...

Notas de la versión: 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. There are four options in the enum that the user can use accordingly to print the workbook: Duplex ...

Notas de la versión: Requested Registry access is not allowed error occur on setting the impersonate in the web.config for web app. The result of XIRR func is incorrect. InvalidFormulaException is thrown on opening an Excel file with XLOOKUP formula which refers to external Table formula. The result of reappling filter ...

Notas de la versión: Performance issue on processing Template file. Exception is thrown on calling IRange.Ungroup() method. The result of DATEDIF formula is incorrect in JP culture. Some cell content is lost after processing Template file. Some text is incomplete in the exported PDF file. Exception is thrown on copying ...

Capturas de pantalla: DsExcel.NET provides you with the ability to summarize large amounts of information in groups so that complex spreadsheets are easier to navigate. The data in rows or columns can be grouped ... to organize information and create custom views in a spreadsheet. 0 ...

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

Capturas de pantalla: 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 ...

Capturas de pantalla: 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 ... required. Moreover, the imported or generated spreadsheets can contain references to one another, such as you can reference full reports, sort and filter tables, sort and filter pivot tables, add charts, ...