DOCSEARCHbyAlgolia
Submit Docs

Aspose.Cells for .NET

repository·master·Indexed 42 days ago

https://github.com/aspose-cells/aspose.cells-for-.net

A comprehensive Excel Spreadsheet Programming API for generating, modifying, converting, rendering, and printing spreadsheets across .NET platforms. Includes support for C# and VB.NET, integration plugins for DNN, Umbraco, and Microsoft Dynamics CRM, and code comparisons with VSTO and NPOI.

Tokens
6.5K
Snippets
12
Records
39
Agent score
53%

What's inside Aspose.Cells for .NET

  1. Overview of Umbraco Export Members to Excel Add-on

    master

    The Export Members to Excel Add-on is an extension for Umbraco CMS that enables the export of Umbraco members into various spreadsheet and text formats using Aspose.Cells.

    After installation, a new node titled Export Members To Excel appears under the Members tree in the Umbraco backend. This interface allows users to select specific members and choose an output format for the export process.

    Key Features:

    • Supported Formats:
      • Microsoft Excel (.xls, .xlsx, .xlsb)
      • OpenDocument Spreadsheet (.ods)
      • CSV (Comma delimited) (.csv)
      • Tab delimited text (*.txt)
    • Export Options: Ability to export either all members or a specific selection of members.
    • Automatic Download: The exported document is automatically sent to the browser for downloading.
    • Server-side Backup: A copy of the exported document is automatically saved in the App_Data/AsposeMemberExport folder on the server.
    • Compatibility:
      • Works with Umbraco versions 4.5+ (including versions 6 and 7).
      • Compatible with .NET versions 2.0 and higher.

  2. Overview of Aspose.SiteFinity.FormBuilder.ToExcel

    master

    The Aspose.SiteFinity.FormBuilder.ToExcel module is a dynamic forms extension for Sitefinity that leverages Aspose.Cells for .NET. It enables users to generate dynamic questionnaires and surveys, capture user input, and save that data into spreadsheet formats.

    Key capabilities include:

    • Form Management: Add, update, and manage various field types (TextBox, Multiline TextBox, RadioButtons, CheckBox, and DropDownList).
    • Data Persistence: Save both form field settings and actual user input data into Excel.
    • Multi-format Export: Export collected data into several formats including Microsoft Excel (.xls, .xlsx, .xlsb), Tab-delimited text (.txt), CSV (.csv), and OpenDocument Spreadsheet (*.ods).
    • Automated Formatting: Automatically fits columns to content length and applies bold formatting to header columns.

  3. Overview of Aspose .NET Export GridView To Excel Control

    master

    The Export GridView To Excel Control is an ASP.NET server control designed to export the contents of an ASP.NET GridView into Microsoft Excel or OpenOffice Spreadsheets using the Aspose.Cells engine.

    It functions by adding an Export to Excel button directly above the GridView control. When a user clicks this button, the control dynamically generates the spreadsheet and triggers an automatic download to the user's local disk.

    Key Features:

    • Inheritance: Inherits from the default ASP.NET GridView control, meaning it retains all standard GridView features and properties.
    • Supported Formats: Export to Xlsx, Xlsb, Xls, Txt, Csv, and Ods.
    • Compatibility: Works with all .NET versions starting from .NET 2.0.
    • Customization:
      • Localize or customize the text of the Export button.
      • Apply custom CSS themes to the Export button.
      • Add custom headings to the top of the exported document.
    • Data Control:
      • Option to export only the current page or all pages when paging is enabled.
    • Server-side Storage: Option to save a copy of each exported document on the server at a configurable disk path.

  4. Overview of Aspose.Cells Dynamic Forms DNN Module

    master

    The Aspose.Cells Dynamic Forms DNN Module is a DotNetNuke (DNN) module designed to facilitate the generation of dynamic questionnaires and surveys. It leverages the Aspose.Cells engine to capture user input and manage spreadsheet data.

    Key capabilities include:

    • Form Building: Create and manage form fields such as TextBox, Multiline TextBox, RadioButtons, CheckBox, and DropDownList (including items within the list).
    • Data Management: Save user input directly into Excel spreadsheets and manage field settings within Excel.
    • Exporting: Export collected data into multiple formats including Microsoft Excel (.xls, .xlsx, .xlsb), Tab-delimited text (.txt), CSV (.csv), and OpenDocument Spreadsheet (*.ods).
    • Formatting: Automatically fits columns to content length and applies bold formatting to header columns.

  5. Overview of Aspose .NET Umbraco Data Exporter to Excel Module

    master
    The Aspose .NET Umbraco Data Exporter to Excel Module enables users to export data directly from local or remote MS SQL Server databases into various spreadsheet formats. It supports exporting data from database tables, views, or via custom SQL queries. This module leverages the spreadsheet building capabilities of Aspose.Cells to automate formatting and file generation.

  7. Available Aspose.Sitefinity Plugins

    master

    Aspose.Cells for .NET provides specific plugins/modules designed for integration with Sitefinity to facilitate spreadsheet operations. The available plugins are:

    • Aspose.SiteFinity.FormBuilder.ToExcel: Likely used for exporting Sitefinity Form Builder data to Excel formats.
    • Aspose.SiteFinity.ExportUsersToExcel: Used for exporting Sitefinity user data to Excel formats.

  8. Available Aspose.Cells for .NET Plugins for DNN

    master

    Aspose.Cells for .NET provides several specialized plugins and modules designed specifically for integration with DNN (DotNetNuke). These plugins leverage Aspose.Cells capabilities to perform data export and import operations within the DNN ecosystem.

    Available modules include:

    • Aspose.DNN.ExportUsersAndRolesToExcel: Facilitates exporting DNN users and their associated roles into Excel formats.
    • Aspose.DNN.ImportUsersFromExcel: Enables importing user data into DNN from Excel spreadsheets.
    • Aspose.DNN.DatabaseDataExporterToExcel: Allows for exporting general database data from DNN into Excel.
    • Aspose.DNN.DynamicFormBuilderExcel: Provides functionality for building dynamic forms that output to Excel.

  9. Compare Aspose.Cells and VSTO spreadsheet features

    master
    This documentation provides code comparisons between Aspose.Cells for .NET and Visual Studio Tools for Office (VSTO). It is designed to help developers migrating from VSTO to Aspose.Cells understand how to implement common spreadsheet tasks using the Aspose.Cells API. The comparison covers a wide range of features including cell manipulation, styling, worksheet management, and data processing.

  10. Aspose.Cells GUI-based .NET Controls

    master

    In addition to the core API, Aspose provides specialized controls for different application types:

    • Aspose.Cells.GridJs: Designed for .NET Core based web applications (canvas rendering).
    • Aspose.Cells.GridDesktop: Supports desktop applications.
    • Aspose.Cells.GridWeb: Designed for ASP.NET/.NET Core web applications (HTML DOM based).

  11. Features of the Aspose.Cells Dynamic Forms DNN Module

    master

    The module provides the following capabilities for form building and data management:

    Form Building

    • Add and update form fields.
    • Supported field types: TextBox, Multiline TextBox, RadioButtons, CheckBox, and DropDownList (including adding DropDownList items).
    • Manage field labels and visibility (Show/Hide).
    • Save form field settings directly in Excel.

    Data Management & Export

    • Save user input data into Excel.
    • Auto-fit columns to content length.
    • Apply formatting (e.g., Bold text for header columns).
    • Export data to multiple formats:
      • Microsoft Excel (.xls, .xlsx, .xlsb)
      • Tab delimited text (*.txt)
      • CSV (*.csv)
      • OpenDocument Spreadsheet (*.ods)
    • Select desired output format before exporting.
    • Automatic browser download of exported documents.

  12. Key Features of the Data Exporter Module

    master

    The module includes several automated spreadsheet processing features:

    • Auto-population: Automatically populates available Tables and Views from the connected database.
    • Column Formatting: Automatically applies 'Auto Fit' to columns based on content length and applies Bold formatting to header columns.
    • Data Handling: Includes an option to skip strings longer than 32,000 characters in Excel cells using LoadOptions to prevent errors.
    • Workflow: Allows users to select the desired output format before exporting, and the resulting document is automatically sent to the browser for download.