Xceed.Workbooks.NET 3.0.26322.8460

Xceed Workbooks for .NET – Spreadsheet Creation & Excel File Processing for .NET

Xceed Workbooks for .NET – Enterprise Spreadsheet & Excel Processing Library for .NET

Overview

Xceed Workbooks for .NET is an enterprise-grade spreadsheet processing library for creating, editing, and managing Excel workbooks programmatically. Generate XLSX files, import CSV/TXT data, apply formatting, protect worksheets, and automate spreadsheet workflows without requiring Microsoft Excel or Office interop.

Build financial reports, ERP exports, analytics dashboards, and business intelligence systems with full control over spreadsheet structure, formatting, and protection. Cross-platform compatible with ASP.NET, cloud applications, and modern .NET solutions.

Trusted by Fortune 500 companies and .NET developers worldwide.

Key Features

Workbook Creation & Management

• Create Excel workbooks from scratch
• Load and edit existing XLSX files
• Add, remove, rename, and reorder worksheets
• Duplicate worksheet structures
• Save and export workbooks programmatically
• No Excel installation required

Cell & Data Management

• Edit cell values directly
• Apply spreadsheet formulas
• Set cell data types
• Handle number formatting
• Merge and unmerge cells
• Auto-size columns and rows

Spreadsheet Formatting

• Apply fonts and text styling
• Configure borders and colors
• Set cell alignment and wrapping
• Apply background fills and patterns
• Customize row heights and column widths
• Professional spreadsheet layouts

Worksheet Protection

• Protect worksheets from editing
• Lock and unlock specific cells
• Restrict sheet operations
• Preserve data integrity
• Secure workbook structures
• Enterprise-grade access control

Data Import & Export

• Load XLSX files
• Import CSV and TXT data
• Export spreadsheets programmatically
• Stream workbook data
• Batch processing support
• Large dataset handling

Advanced Features

• Stream-based workbook processing
• Memory-efficient operations
• Parallel processing support
• No temporary file dependencies
• Cross-platform compatibility
• Fully managed .NET code

Installation

NuGet Package Manager

dotnet add package Xceed.Workbooks.NET

Package Manager Console

Install-Package Xceed.Workbooks.NET

Quick Start

Create an Excel Workbook

using Xceed.Workbooks.NET;

// Create a new workbook
var workbook = new Workbook();

// Add a worksheet
var sheet = workbook.AddWorksheet("Sales");

// Set header values
sheet.Cells[0, 0].Value = "Product";
sheet.Cells[0, 1].Value = "Q1 Sales";
sheet.Cells[0, 2].Value = "Q2 Sales";
sheet.Cells[0, 3].Value = "Total";

// Set data values
sheet.Cells[1, 0].Value = "Widget A";
sheet.Cells[1, 1].Value = 1500;
sheet.Cells[1, 2].Value = 2000;
sheet.Cells[1, 3].Value = "=B2+C2";

// Auto-fit columns
sheet.Columns[0].AutoFit();
sheet.Columns[1].AutoFit();

// Save the workbook
workbook.Save("Sales.xlsx");

Apply Spreadsheet Formatting

using Xceed.Workbooks.NET;

// Create workbook
var workbook = new Workbook();
var sheet = workbook.AddWorksheet("Formatted");

// Add header
sheet.Cells[0, 0].Value = "Item";
sheet.Cells[0, 1].Value = "Price";

// Style the header row
sheet.Cells[0, 0].Style.Bold = true;
sheet.Cells[0, 0].Style.Fill.BackgroundColor = System.Drawing.Color.Orange;
sheet.Cells[0, 1].Style.Bold = true;
sheet.Cells[0, 1].Style.Fill.BackgroundColor = System.Drawing.Color.Orange;

// Add data
sheet.Cells[1, 0].Value = "Product 1";
sheet.Cells[1, 1].Value = 99.99;

workbook.Save("Formatted.xlsx");

Load and Edit Existing Workbook

using Xceed.Workbooks.NET;

// Load existing workbook
var workbook = Workbook.Load("Report.xlsx");

// Get first worksheet
var sheet = workbook.Worksheets[0];

// Update cell value
sheet.Cells[1, 1].Value = "Updated Value";

// Protect the worksheet
sheet.ProtectSheet("MyPassword");

// Save changes
workbook.Save("Report_Updated.xlsx");

Import CSV Data

using Xceed.Workbooks.NET;

// Create workbook
var workbook = new Workbook();

// Load CSV data
var sheet = workbook.AddWorksheet("Imported");
var csvData = System.IO.File.ReadAllLines("data.csv");

int row = 0;
foreach (var line in csvData)
{
    var columns = line.Split(',');
    for (int col = 0; col < columns.Length; col++)
    {
        sheet.Cells[row, col].Value = columns[col];
    }
    row++;
}

workbook.Save("Imported.xlsx");

Core Capabilities

Workbook Operations

Cell & Data Management

Formatting & Styling

Data Import/Export

Protection & Security

Supported File Formats

Read & Write

Supported Frameworks

• .NET Framework 4.6.1+
• .NET Core 2.1+
• .NET Standard 2.0+
• .NET 5+
• .NET 6+
• .NET 7+
• .NET 8+

Supported Platforms

• Windows
• Linux
• macOS

Common Use Cases

• Financial Reporting - Generate financial statements and reports
• ERP Exports - Export enterprise data to spreadsheets
• CRM Data Management - Extract and format customer data
• Inventory Management - Track stock and create inventory reports
• Analytics Dashboards - Build data visualization and summary spreadsheets
• Invoice Generation - Create formatted invoice spreadsheets
• Data Migration - Convert data between systems using spreadsheets
• Business Intelligence - Generate BI reports and dashboards
• Budget Planning - Create budgets and financial forecasts
• Cloud Reporting - Generate reports in cloud-based applications

Free 45-Day Trial

Experience the full capabilities of Xceed Workbooks for .NET with a free 45-day trial. No credit card required.

Start Your Free Trial

Resources

• Product Page - Features and pricing
• Documentation - Complete API documentation
• API Reference - Detailed method and class reference
• Blog - Updates and articles
• Support - Technical support and forums
• Licensing - License information and pricing

Related Xceed Products

Document & Office Automation

• Xceed Words for .NET - Word document creation and PDF conversion
• Xceed PDF Library for .NET - PDF creation and manipulation
• DocX - Lightweight Word document library

File Transfer & Compression

• Xceed Zip for .NET - ZIP, TAR, GZip compression
• Xceed Real-Time Zip for .NET - Streaming ZIP compression
• Xceed SFTP for .NET - Secure SFTP file transfer
• Xceed FTP for .NET - FTP and FTPS file transfer

UI Components

• Xceed Toolkit Plus for WPF - Advanced WPF controls
• Xceed DataGrid for WPF - High-performance WPF DataGrid
• Xceed Toolkit for .NET MAUI - Cross-platform MAUI controls
• Extended WPF Toolkit - Open-source WPF controls

Getting Help

• Documentation - Complete API documentation and guides
• Support Portal - Get technical support
• NuGet Package - View on NuGet.org

License

Xceed Workbooks for .NET is a commercial product with a free 45-day trial. Various license options are available for development and production use. See licensing information for details.

Xceed Workbooks for .NET – Enterprise spreadsheet and Excel processing library for .NET applications.