High-Performance .NET Excel API library

List of Services

    You have full control over your spreadsheets without relying on Excel.

    • Supports .NET 6+ , .NET Core, .NET Framework, and Xamarin
    • Create, load, edit, and save spreadsheets
    • Parse, convert, and share spreadsheets
    • Save as XSLX, PDF, HTML, CSV, JSON, image, or SpreadJS file
    • Create custom reports using Excel (.xslx) templates
    • Deployment on Azure and AWS
    • Calculate formulas and format cells
    Download Free Trial

    Why Should I Use DsExcel .NET?

    High Speed and Efficiency

    Our lightweight API architecture saves memory and time. Process large amounts of data in an efficient and instantaneous manner.

    Flexible Themes and Components

    Take advantage of rich user resources, including flexible customizable themes, configurable components, summary data, custom styles, drawing objects, and an integrated calculation engine.

    Full .NET Support

    Available for .NET 6+, .NET Core, .NET Framework, Mono, Xamarin.iOS, and Xamarin.Android apps.

    Deploying Excel Spreadsheet-Based Applications to the Cloud

    Cloud-based deployment anywhere - Deploy to Azure, AWS, and AWS Lambda with Maven and DsExcel.

    Powerful Excel Compatibility

    Import pivot tables, notes, charts, conditional formatting, data validation, formulas, shapes and pictures, sparklines, and tables without loss.

    Based on Excel Document Object Model

    The interface-based API enables import, calculation, query, creation, and export operations across all spreadsheet scenarios. The VSTO-style API uses the same elements found in VS Tools for Office to create custom styles.

    Quickly create and edit Microsoft Excel documents using the DsExcel API for .NET. Develop powerful .NET-based Excel services that work seamlessly on desktop, web, mobile, and the cloud.

    Ask anything!

    Please share your vague concerns and questions about DsExcel with MESCIUS's expert team. We empathize with your concerns and are here to help.

    Online Consultation

    .NET Excel APIs. Done right. Look no further.

    MESCIUS Now Offers a Complete Excel API for .NET Developers

    DsExcel .NET can process large amounts of data in an efficient manner, making it possible to process large amounts of data in an instant.

    < Performance Test (Windows) >

    Learn More

    Try DsExcel .NET today.

    Click the tabs below to get new ideas through workflows for a variety of real-world situations.

    Implement export functionality that is fully compatible with Excel.

    Go beyond simply exporting data—create Excel files that include fully functional charts, pivot tables, shapes, formulas, and formatting, all working exactly as they do in Microsoft Excel. Transform your HTML dashboards into Excel, empowering users with flexible, self-service data analysis.


    * Combine this with Wijmo, the high-performance JavaScript data visualization control, to deliver a truly complete solution for data analysis and monitoring.

    Implement an Excel data collation solution quickly and easily.

    You can automate the collection of Excel data from multiple departments and employees on the web using standardized forms. With DsExcel’s Excel-compatible coordinate system, you can easily fetch data from specific cells. This enables you to quickly store only the required information in your database and transform it into reliable, business-ready data.

    Convert existing Excel files into a database quickly and easily.

    With the toJson/fromJson functions in the DsExcel API, you can easily convert Excel files into JSON strings for seamless database integration. The converted JSON preserves every detail—formatting, formulas, functions, charts, pivot tables, and more—without any loss. When needed, DsExcel also allows you to extract only the data from specific cells and store it as raw data. This creates a foundation for moving Excel-based workflows entirely to the web, eliminating file-bound limitations.

    Implement a service that generates regular/irregular reports.

    With DsExcel, you can store your existing Excel templates on the server or convert them into JSON for database integration. Once loaded back into DsExcel, you can populate them with data from your database and leverage Excel data visualization controls to generate professional reports in Excel, PDF, or HTML formats—all ready for download.

    Move Excel to the Web powered by SpreadJS.

    Using SpreadJS together, you can provide your end users with the same look and feel as Excel, while:

    On the backend side, you can use the DsExcel API to quickly process Excel data received from SpreadJS using powerful server resources.

    Additionally, you can enhance your security capabilities by performing secure data and Excel formula/calculation tasks on the server side.

    Learn More About SpreadJS

    DsExcel .NET Key Features

    • AI Functions

      Support for new AI functions enables plug-and-play integration with OpenAI, Azure OpenAI, Gemini, and more.


      * AI.QUERY — Data-driven question answering

      * AI.TRANSLATE — Multilingual translation

      * AI.TEXTSENTIMENT — Sentiment analysis (Positive / Negative / Neutral)

      View Demo

    • Excel Import and Export

      Seamlessly import and export Excel-compatible XLSX, XLTX, and XLSM files without relying on Excel.

      View Demo

    • Workbooks and Worksheets

      You can perform various tasks such as creating, importing, exporting, using passwords, adding sheets, cutting and copying ranges, copying and moving worksheets, activating, organizing, deleting, and protecting them.

      View Demo

    • Supports formulas, 450+ Excel functions, and user-defined functions

      Perform complex calculations using hundreds of built-in functions and operators, or build your own custom functions to create the formulas you need.

      View Demo

    • Pivot Table

      You can create an Excel data table and add a pivot table to automatically calculate, sum, or average your data.

      View Demo

    • Importing and Exporting SpreadJS .sjs Files

      SpreadJS provides the ability to import or export .sjs files to Excel and vice versa.

      Learn More
      View Demo

    • Custom Reports using Excel Templates

      Automate and generate comprehensive Excel reports, including invoices, sales reports, receipts, shipping labels, purchase orders, and more.

      Learn More
      View Demo

    DsExcel .NET Demo

    Getting Started with DsExcel .NET

    This step-by-step tutorial will help you start coding spreadsheets using DsExcel .NET right away. The tutorial will teach you various features and even provide code samples you can download and apply immediately.

    See More

    Learning DsExcel .NET by Feature

    Explore plenty of example code demonstrating how to use the basic features of DsExcel .NET.

    See More

    DsExcel .NET Showcase

    You can see the full code demonstrating how to create an Excel file. You'll also learn how to open an existing Excel file on the server side and update its contents.

    See More

    DsExcel .NET Template

    DsExcel introduces a new template approach, featuring a comprehensive syntax and API that allows you to bind Excel documents to data and generate advanced-looking Excel reports. With flexible syntax and simple notation for data expansion and formulas, the new template syntax and API allow you to easily define Excel templates and generate Excel reports that support a variety of use cases.

    See More

    Turn Excel Templates into Powerful Reports

    Step 1. Create a DsExcel Template

    After pre-entering the "DsExcel template syntax" above the specific Excel cells where the data will be inserted, create a form or resource folder on the server and save it. The template syntax reflects the data structure of your designed JSON or Java class.

    Step 2. Bind the Data Source to the Template

    Load the Excel template saved in Step 1 using DsExcel's Open method. Bind JSON, DataSet, Datable, Array, and other data to the loaded form using the AddDataSource method.

    // Create a workbook

    var workbook = new GrapeCity.Documents.Excel.Workbook();


    // Load template file named "Template_FamilytInfo.xlsx"

    var templateFile = this.GetResourceStream("xlsx\\Template_FamilyInfo.xlsx");

    workbook.Open(templateFile);


    // Get data from json file

    string jsonText = string.Empty;

    using (Stream stream = this.GetResourceStream("Template_FamilyInfo.json"))

    using (StreamReader reader = new StreamReader(stream))

    {

        jsonText = reader.ReadToEnd();

    }



    // Create JsonDataSource

    var datasource = new JsonDataSource(jsonText);


    // Add data source

    workbook.AddDataSource("ds", datasource);

    Step 3. Save as Excel

    Using the ProcessTemplate function, enter actual data on the form in Step 2, and then use the Save function to save it as an Excel file.

    // Called to process the template

    workbook.processTemplate();


    // Save as Excel file

    workbook.save("JsonFile.xlsx");

    Run Demo

    Ask anything!

    Please share your vague concerns and questions about DsExcel with MESCIUS's expert team. We empathize with your concerns and are here to help.

    Online Consultation

    DsExcel .NET v9.2
    New features

    🚀 Workbook and Excel I/O Enhancements

    • Lossless XLSX Handling for Equation Shapes : Preserves original Office Math structures and Shape Format settings when opening and saving workbooks
    • Custom XML Part API : Add, retrieve, enumerate, update, and remove workbook-level XML content via ICustomXmlPartCollection and ICustomXmlPart
    • Hidden Defined Names (IName.Visible) : Keep helper names available to formulas and automation logic while hiding them from the Name Manager
    • Form Controls Inside Grouped Shapes : Control properties and group hierarchy preserved across XLSX, SJS, and SSJSON workflows


    💡 Pivot Table Grouping API Support

    • Date Grouping : Group by second, minute, hour, day, month, quarter, or year with optional automatic layout placement
    • Number Range Grouping : Define start, end, and interval values to replace displayed items with range-based bins
    • Custom Grouping : Combine selected PivotItems into named, nestable groups
    • Ungrouping : Removes grouping and restores the original layout, with round-trip support across XLSX, SJS, and SSJSON


    ✨ SpreadJS Interoperability and Lossless I/O

    • Automatic AI Function Prefix Conversion : Converts between SJS.AI and AI prefixes during SJS and SSJSON import and export with no additional API required
    • DataManager-Sourced Pivot Table Round-Trip : XLSX export and IPivotTable.Update supported when a complete PivotCache is present
    • SpreadJS v19.2 Feature Preservation : Lossless I/O for Focus Cell, custom pivot subtotals, rounded cell borders, watermark background image options, and cell scenarios


    ✅ Additional Updates

    • This release also includes configurable invalid formula handling (InvalidFormulaHandling), a CSV formula injection mitigation option, XLTX template file support in DsDataViewer, local performance benchmark packages for .NET and Java, and expanded API reference documentation.
    See More

    Getting Started with DsExcel .NET

    Let's learn how to create an Excel document using the DsExcel .NET API on Windows, Mac, and Linux.

    Windows
    Mac
    Linux

    • Windows

      Check out the video above for more detailed explanations.

      See More

    • Mac

      Check out the video above for more detailed explanations.

      See More

    • Linux

      Check out the video above for more detailed explanations.

      See More

    DsExcel .NET Free Trial

    Download

    DsExcel .NET Pricing and Licensing

    * All amounts are exclusive of VAT.

    Project License

    This license is required to use and distribute the DsExcel .NET API, and requires the purchase of 1 copy per development project.

    When purchasing DsExcel .NET alone,

    $1,800

    with SpreadJS,

    $1,180

    Introduction Inquiry

    If you need more detailed product or purchase consultation regarding the introduction of DsExcel .NET, please contact us using a method that is convenient for you.


    Development/Deployment Key Application

    To develop with the DsExcel .NET API and deploy it to a server, you must purchase a project license and obtain a development/deployment key. Please apply for the key through the Development/Deployment Key Portal.

    Purchase Procedure

    Click on each button to see detailed information about each step of the purchasing process.

    • 1. Price Confirmation and Quote Request

      Please request a quotation using any of the methods below that are convenient for you.


    • 2. Order Request

      Please send the following three items to Email (asia.sales@mescius.com)


      1. Signed quotation (authorized signatory or company seal)
      2. Copy of business registration certificate (for companies)
      3. End-User information:

                1) Company Name (in English):

                2) Contact Person (in English):

                3)E-mail:


      Once your order request is received, we will issue the invoice via email.

    • 3. Price

      Bank Transfer


      Please make the payment to the account number indicated on the invoice you received.


    • 4. License issuance & Tax invoice issuance

      After payment is confirmed, we will send you an email with license issuance details.


      *To deploy the SpreadJS control on a server, you must purchase a deployment license and obtain a deployment key. Please request your deployment key through the Deployment Key Portal.


    Controls for .NET Developers

    • Spread.NET

      Global No. 1 Excel SpreadSheet Component
      • Excel import/export support
      • Support for 450+ Excel functions
      • Support for WinForms, ASP.NET, and WPF
      Learn More

    • ComponentOne

      .NET-based UI controls such as Chart, Grid, and Input
      • 400+ UI controls including grids, charts, reports, schedulers, and ribbons
      • Supports all .NET development platforms
      • Specialized controls for enterprise solutions
      Learn More

    • ActiveReports.NET

      .NET-based business reporting components
      • Report designer that requires no coding
      • Full report viewer
      • Supports WinForms, WPF, ASP.NET MVC, and .NET CORE
      Learn More

    • Forguncy

      A business web development solution built with Excel without coding.
      • Easy and quick web implementation with Excel features
      • Web development without HTML & CSS
      • Data collection and integration solution
      Learn More