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
    • Various features added v8.1 Released!
    Start your free trial Developer Forum (Technical Support)

    Why should I use DsExcel .NET?

    Fast 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 applications that use Excel spreadsheets 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's 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 product consultation Developer Forum (Technical Support)

    APIs for .NET, 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.

    < 성능 테스트 결과 (Windows) >

    Learn more about DsExcel .NET performance testing.

    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.

    Beyond simply exporting data, you can create and export Excel files containing charts, pivot tables, shapes, formulas, and formatting that work in real MS Excel. Translate dashboards created in HTML into Excel, allowing users to flexibly analyze their data. * Combine with Wijmo, a high-performance JavaScript data visualization control, to develop even more complete data analysis and monitoring solutions.

    Implement an Excel data collation solution quickly and easily.

    You can automate the collection of Excel data from various departments and employees online using standardized forms. DsExcel provides functions that retrieve data from specific cells using the same coordinate system as Excel. This allows you to quickly save only the necessary data to a database, creating raw data.

    Convert existing Excel files into a database quickly and easily.

    Using the DsExcel API's toJson/fromJson functions, you can easily convert Excel files to JSON strings and store them in a database. The converted JSON retains all Excel features, including formatting, functions, formulas, charts, and pivots. If necessary, DsExcel can be used to extract data from specific cells and save them as raw data. This allows you to work entirely on the web, rather than in Excel files.

    Implement a service that generates regular/irregular reports.

    DsExcel allows you to save your current Excel form files for reporting on a server or convert them to JSON for database storage. After loading the Excel form file or JSON file into DsExcel, you can input the required data from the database and generate and download Excel, PDF, and HTML reports, including Excel data visualization controls.

    Use it with SpreadJS to implement a complete web-based Excel solution.

    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

    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 details

    Learning DsExcel .NET by Feature

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

    See more details

    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 details

    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 details

    Create a variety of reports using DsExcel template forms.

    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"
    );

    Running the 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 product consultation Developer Forum (Technical Support)

    DsExcel .NET v8.1
    New features

    • Support for the HtmlSaveOptions.CellAttributeOptions property
    • Add cell address properties to Excel tables exported to HTML
    • Improved VLOOKUP and UNIQUE function performance
    • Enhanced features for SpreadJS compatibility
    • data chart
    • Data charts within report sheets
    • Data manager tables can be bound to data sources.
    • SpreadJS DataRange support
    See more new features

    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 details

    • Mac

      Check out the video above for more detailed explanations.

      See more details

    • Linux

      Check out the video above for more detailed explanations.

      See more details

    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,

    ￦2,515,000

    When used with SpreadJS,

    ￦1,650,000

    FAQ & Blog

    • DsExcel .NET License Guide and Application Method
    • Advanced Excel reporting and printing features with repeating headers and footers
    • Generate Excel reports in C# with enhanced Excel templates.
    • How to Convert Excel Sheets to PDF in .NET

    Introduction Inquiry

    Check online quotes and request quotes

    Request for product purchase consultation

    sales-kor@mescius.com

    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.


    1670 - 0583

    Application for issuance of development/distribution key

    To develop and deploy to a server using the DsExcel .NET API, you must purchase a project license and obtain a development/deployment key. Please apply through the development/deployment key issuance portal.

    Purchase Procedure

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

    • 1. Price confirmation and quote request

    • You can request a quote using any of the methods below:
    • Online quote confirmation and quote request
    • 1670-0583
    • sales-kor@mescius.com

    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
      Find out

    • 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