About Document Solutions for Excel, .NET Edition

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, Windows, Mac, or Linux. Its powerful calculation engine and breadth of features means you'll never have to compromise design or requirements. The interface-based API is modeled on Excel's document 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 and filtered pivot tables, dashboard, add charts, sparklines, conditional formats, import and export Excel templates and also convert spreadsheets to PDF, HTML, or an image format. It also includes Document Solutions Data Viewer (DsDataViewer), a JavaScript viewer to open and view data documents on the client side.

Document Solutions for Excel, .NET Edition Features

Import/Export Features

  • Import and Export Excel in a .NET Application - Seamlessly import and export Excel-compatible XLSX, XLTX, XLSM files with no Excel dependency, with all formulas, formatting, and other settings.
  • PDF Export - Export Excel .xlsx spreadsheets to PDF at server side with various PDF options, including security settings and embedded form controls with HTML5 tags for autocomplete.
  • Image Exporting - Export a worksheet, cell range, shape, or chart to an image file on the server side in your application with various Image save options.
  • Templates - DsExcel .NET introduces Templates Support with comprehensive syntax and API to easily bind Excel documents to data and generate advanced and complex custom Excel reports.
  • Data Binding - DsExcel .NET supports one-way data binding with a cell, a worksheet, and Table binding to .NET data sources to easily fill in your data automatically.
  • Import Data - Use ImportData() function to quickly import just the data values from a specified range in an Excel file without loading the whole object model.
  • Import/Export Excel 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 fields, including HTML5 autocomplete types, to submit data forms to a server, import XML data, and import form data submitted on the client to a PDF.
  • PDF Export - Export Excel .xlsx spreadsheets to PDF at server side with various PDF options, including security settings and embedded form controls with HTML5 tags for autocomplete.
  • Page Setup - Get and set Page Setup attributes (left margin, bottom margin, paper size, and so on) on Excel workbook and import/export in XLSX and/or print to PDF or directly to a printer in Windows.
  • Templates - DsExcel .NET introduces Templates Support with comprehensive syntax and API to easily bind Excel documents to data and generate advanced and complex custom Excel reports.
  • Workbook Views - Programmatically set three predefined Workbook views, Normal, Page Layout, and Page Break Preview, which take effect on loading in Excel.
  • Print Excel file to printer (Windows) - Directly print Excel file to printer using interfaces IWorkbook.PrintOut and PrintOutOptions (supported in Windows environments only).

Calculation Features

  • Formulas (450+ Excel Functions) - Use hundreds of built-in functions and operators to perform complex calculations, add external formulas, or build your own custom functions and create what you need.
  • Dynamic Array Formula - Use Dynamic Array Formula functions and the '#' operator to pass and return multiple values from functions and spill results in a range of cells.
  • Custom Function - Custom functions allow you to easily create calculation functions for use in cell formulas using custom logic to return a value in your .NET app.
  • Formula Parser - Create, parse and modify formulas with GrapeCity.Document.Excel.Expression namespace to parse the formula expressions.
  • Table Formulas - Use absolute or relative structured references in formulas to reference to table cells for formulas that are more intuitive and easier to understand.
  • Pivot Table Formulas - Use the method GenerateGetPivotDataFunction from IRange interface to generate formulas using the GETPIVOTDATA function to get pivot table values.
  • Add Goal Seek to Spreadsheets - Programmatically determine the necessary input value to achieve a desired result, by setting a target output.
  • Linked Picture - A linked picture (also knows as Camera Shape) can be created using a reference to the actual data, table, or chart in your final dashboard.
  • Formula Tracing - Trace the formula references in your worksheet to find the Dependent and Precedent cells and automate your formula auditing to ensure calculation accuracy.
  • Ignore Errors in Excel - Ignore range errors in Excel and hide the annoying green triangle.
  • Excel Calculation Mode - Programmatically modify the Excel's mode of calculation to Automatic, Partial, or Manual.

Formatting, Style, and Theme Features

  • Workbooks and Worksheets - Create, import, export, use passwords, add sheets, cut and copy ranges, copy and move worksheets, activate, configure, delete, protect, and add iterative calculations.
  • Cell Rich Text - Apply rich text formatting using the IRichText interface including multiple font styles, colors, sizes, subscript and superscript text in the cells of the worksheet.
  • Templates - DsExcel introduces Templates Support with comprehensive syntax and API to easily bind Excel documents to data and generate advanced and complex custom Excel reports.
  • Themes - DsExcel API lets you apply built-in or custom Office themes to change the appearance of a workbook by replacing the colors and styles in one quick and easy operation.
  • Conditional Formatting - Create conditional formatting rules for individual cells or a range of cells based on cell values or a custom formula, including data bars, color scales, and icon sets.
  • Data Validation - Validate data by restricting the format and values that can be entered in cells of a worksheet, or create a drop-down list for the cell.
  • Range Operations - Get and set all style, formula, and other settings on cells, rows or columns in .NET Excel documents with the help of Range property of the IWorksheet interface.
  • Formatting - DsExcel provides many style, border, and format properties to customize the appearance of a range in your .NET Excel spreadsheet.
  • Tables - Manage Tables independently in Excel worksheets, format rows and columns, include totals row, and perform calculations using structured table column references.
  • Graphics - Use linear and gradient brushes and pattern fills with Shapes and Pictures in Excel workbooks for reporting, data visualization, and more.
  • Charts - DsExcel provides a comprehensive charting API to add all types of charts in Excel worksheets, including support for advanced template reporting and data binding.
  • Shapes - Embed Shapes and Pictures in a worksheet. You can insert arrows, lines, charts, slicers, pictures, general shapes and connectors, and group shapes.
  • Pictures - Add a picture to a worksheet using the AddPicture method of the worksheet's Shapes collection, or delete, cut, copy and duplicate pictures in the worksheet.
  • Templates - DsExcel introduces Templates Support with comprehensive syntax and API to easily bind to Images and generate advanced and complex custom Excel reports.
  • Linked Picture - A linked picture (also known as Camera Shape) can be created using a reference to the actual data, table, or chart in your final dashboard.
  • Barcodes - DsExcel supports 11 types of barcodes that can be added using a simple formula. Convert the formula result to picture using ConvertBarcodeToPicture() method.

Data and Visualization Features

  • Workbooks and Worksheets - Create, import, export, use passwords, add sheets, cut and copy ranges, copy and move worksheets, activate, configure, delete, protect, and add iterative calculations.
  • Templates - DsExcel introduces Templates Support with comprehensive syntax and API to easily bind Excel documents to data and generate advanced and complex custom Excel reports.
  • Forms - Create AcroForm fields, including HTML5 autocomplete types, to submit data forms to a server, import XML data, and import form data submitted on the client to a PDF.
  • Range Operations - Get and set all style, formula, and other settings on cells, rows or columns in .NET Excel documents with the help of Range property of the IWorksheet interface.
  • Formatting - DsExcel provides many style, border, and format properties to customize the appearance of a range in your .NET Excel spreadsheet.
  • Dynamic Array Formula - Use Dynamic Array Formula functions and the '#' operator to pass and return multiple values from functions and spill results in a range of cells.
  • Tables - Manage Tables independently in Excel worksheets, format rows and columns, include totals row, and perform calculations using structured table column references.
  • Pivot Tables - Add Pivot Table to Excel workbook for data summarization and aggregation, to automatically count, total, or average the data stored in a spreadsheet.
  • Conditional Formatting - Create conditional formatting rules for individual cells or a range of cells based on cell values or a custom formula, including data bars, color scales, and icon sets.
  • Grouping - Summarize large amounts of information in groups of columns and/or rows that expand and collapse so that complex spreadsheets are easier to navigate.
  • Cell Rich Text - Apply rich text formatting using the IRichText interface including multiple font styles, colors, sizes, subscript and superscript text in the cells of the worksheet.
  • Data Validation - Validate data by restricting the format and values that can be entered in cells of a worksheet, or create a drop-down list for the cell.
  • Find and Replace - Find and Replace text or formulas in a worksheet with various options including case, whole or partial match, match byte, replace format, search format, and more.
  • Filtering - DsExcel supports all types of filters including Date, Text, Number, Color, Icon, and more in tables or on a range using a worksheet range filter.
  • Data Binding - DsExcel supports one-way data binding with a cell, a worksheet, and Table binding to .NET data sources to easily fill in your data automatically.
  • Sorting - DsExcel provides the Sort method to perform data sorting on a range of cells by value, color, or icon, and supports sorting by column or row in a worksheet.
  • Slicer - Slicers are visual filters that you can use to filter 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 the data it contains, which can show as a popup or sticky note.
  • Hyperlinks - Link to a cell location in a worksheet, a web page, an external file, or an email address using a Hyperlink in a cell or shape to create a table of contents and more.
  • Themes - DsExcel API lets you apply built-in or custom Office themes to change the appearance of a workbook by replacing the colors and styles in one quick and easy operation.
  • Threaded Comments - Add, reply, and delete Threaded Comments, as well as move to next comment, move to previous comment and many more such operations.

Advanced Features

  • Templates - DsExcel introduces Templates Support with comprehensive syntax and API to easily bind Excel documents to data and generate advanced and complex custom Excel reports.
  • Forms - Create AcroForm fields, including HTML5 autocomplete types, to submit data forms to a server, import XML data, and import form data submitted on the client to a PDF.
  • Document Solutions Data Viewer - Open and view data documents (XLSX, CSV, SpreadJS) in web 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, to automatically count, total, or average the data stored in a spreadsheet.
  • Custom Function - Custom functions allow you to easily create calculation functions for use in cell formulas using custom logic to return a value in your .NET app.
  • Dynamic Array Formula - Use Dynamic Array Formula functions and the '#' operator to pass and return multiple values from functions and spill results in a range of cells.
  • Formula Parser - Create, parse, and modify formulas with GrapeCity.Documents.Excel.
  • Charts - DsExcel provides a comprehensive charting API to add all types of charts in Excel worksheets, including support for advanced template reporting and data binding.
  • PDF Export - Export Excel .xlsx spreadsheets to PDF at server side with various PDF options, including security settings and embedded form controls with HTML5 tags for autocomplete.
  • Linked Picture - A linked picture (also knows as Camera Shape) can be created using a reference to the actual data, table, or chart in your final dashboard.
  • SpreadJS Viewer - Use DsExcel on the server side to import/export Excel template files with SpreadJS as a viewer or editor in the browser (client side).
  • SpreadJS Feature Support - DsExcel supports SpreadJS features, adding more compatibility with the client-side SpreadJS product. View the complete supported features list here.
  • SpreadJS JSON I/O - DsExcel .NET supports more powerful and deep-level JSON I/O. Users could use JSON to interact with SpreadJS in a more flexible way.
  • Import/Export Excel Features To/From SpreadJS - Seamless import and export of SpreadJS file format (.sjs) to Excel files using .NET and various Open/Save options available.