# IronXL > IronXL is a .NET library for creating, editing, and managing Excel files in C# and VB.NET applications without requiring Microsoft Excel. ## Documentation ### Overview - [Get Started Overview](https://ironsoftware.com/csharp/excel/docs/): This web page provides comprehensive documentation on using the IronXL library for reading, writing, and exporting Excel files in C# and other .NET languages, including installation instructions, code examples, and platform compatibility details. ### Getting Started - [Deploying to AWS](https://ironsoftware.com/csharp/excel/get-started/aws/): This page provides guidance on using IronXL to support AWS Lambda Functions with .NET Core, offering code examples and links to resources for integrating AWS Toolkit into Visual Studio to create Lambda Function Projects. - [Deploying to Azure](https://ironsoftware.com/csharp/excel/get-started/azure/): This webpage provides a comprehensive guide on integrating IronXL with Azure, detailing steps for installation, performance recommendations, framework compatibility, and official support for Azure Functions, including a Docker tutorial and a code example. - [Read Excel Files in Blazor](https://ironsoftware.com/csharp/excel/get-started/blazor-read-excel-file-tutorial/): This page provides a comprehensive tutorial on how to read Excel files in a Blazor server-side application using the IronXL C# library, without relying on Interop. - [Work with Excel in C# without Interop](https://ironsoftware.com/csharp/excel/get-started/c-sharp-excel-interop/): This web page provides a guide on using IronXL as an alternative to C# Excel Interop for reading, creating, and modifying Excel files, eliminating the need for Interop. - [Setup in Docker](https://ironsoftware.com/csharp/excel/get-started/docker/): This webpage provides a comprehensive guide on setting up and running Excel applications using IronXL within Docker containers, offering step-by-step instructions for developers. - [Using License Keys](https://ironsoftware.com/csharp/excel/get-started/license-keys/): This page provides detailed instructions on obtaining, applying, and verifying IronXL license keys for C# applications, ensuring proper deployment and compliance without restrictions or watermarks. - [Use on Linux](https://ironsoftware.com/csharp/excel/get-started/linux/): This web page provides a comprehensive guide on setting up, configuring, and running Excel operations using IronXL in a Linux environment. - [Use on macOS](https://ironsoftware.com/csharp/excel/get-started/macos/): This web page provides a comprehensive guide on implementing IronXL for macOS, enabling C# developers to create, read, and manage Excel files with .NET Core and .NET 5 projects on macOS seamlessly. - [Work with Excel on .NET MAUI](https://ironsoftware.com/csharp/excel/get-started/read-create-excel-net-maui/): This web page provides a comprehensive guide on how to create, read, and edit Excel files in .NET MAUI applications using C# without relying on Interop, specifically tailored for Windows machines. - [Work with VB.NET Excel Files](https://ironsoftware.com/csharp/excel/get-started/vb-net-excel-files/): This web page provides a tutorial on reading and creating Excel files in VB.NET using IronXL, without relying on Interop, complete with code examples and step-by-step instructions. ### How-To Guides - [Add Comment](https://ironsoftware.com/csharp/excel/how-to/add-comment/): This page demonstrates how to programmatically add comments to Excel cells in C# using IronXL library's AddComment method, providing a simple API alternative to Microsoft Interop for adding notes, annotations, and explanations to spreadsheet cells with options for author attribution and visibility settings. - [Add, Extract, and Remove Images](https://ironsoftware.com/csharp/excel/how-to/add-extract-remove-worksheet-images/): This page documents IronXL's C# API for programmatically adding, extracting, and removing images in Excel worksheets, including code examples for inserting images with specific cell positioning, accessing image collections, and removing images by ID without requiring Excel Interop. - [Freeze Panes](https://ironsoftware.com/csharp/excel/how-to/add-freeze-panes/): This page provides a comprehensive guide on how to programmatically add freeze panes to Excel spreadsheets using C# and the IronXL library, explaining the CreateFreezePane method with code examples to lock specific rows and columns in place for improved data navigation in large spreadsheets. - [Add Rows and Columns](https://ironsoftware.com/csharp/excel/how-to/add-rows-columns/): This page provides a comprehensive guide on using IronXL's C# library to programmatically insert rows and columns into Excel spreadsheets without Office Interop, featuring code examples and methods like InsertRow/InsertRows and InsertColumn/InsertColumns. - [Read Excel Files in ASP.NET Web Apps](https://ironsoftware.com/csharp/excel/how-to/asp-net-mvc-read-excel-file/): This page provides a comprehensive tutorial on how to read Excel files in ASP.NET MVC applications using C# and the IronXL library, covering installation steps, project setup requirements, and code examples for converting Excel data to DataTables without Microsoft Office dependencies. - [Autosize Rows and Columns](https://ironsoftware.com/csharp/excel/how-to/autosize-rows-columns/): Tutorial page demonstrating how to programmatically auto-resize Excel rows and columns in C# using IronXL library's AutoSizeRow() and AutoSizeColumn() methods, which automatically adjust cell dimensions based on content without requiring Excel installation. - [Background Pattern & Color](https://ironsoftware.com/csharp/excel/how-to/background-pattern-color/): This page provides a tutorial on how to programmatically set Excel cell background patterns and colors in C# using the IronXL library, including code examples for applying fill patterns like diagonal crosshatch and colors like SeaGreen without using Microsoft Interop. - [Cell Border & Alignment](https://ironsoftware.com/csharp/excel/how-to/border-alignment/): This tutorial page demonstrates how to programmatically set cell borders and text alignment in Excel files using IronXL's C# library, providing code examples and API documentation for applying various border styles and horizontal/vertical text positioning without requiring Microsoft Office dependencies. - [Export to Excel in C#](https://ironsoftware.com/csharp/excel/how-to/c-sharp-export-to-excel/): This page provides a comprehensive guide for C# developers on how to export Excel files to various formats (XLSX, CSV, JSON, XML) using the IronXL library without requiring Microsoft Office dependencies. - [Open Excel Worksheets in C#](https://ironsoftware.com/csharp/excel/how-to/c-sharp-open-excel-worksheet/): This tutorial page demonstrates how to open and access Excel worksheets in C# using IronXL library's WorkBook.Load() and GetWorkSheet() methods, providing code examples and step-by-step instructions for loading various Excel file formats (.xlsx, .xls, .csv, .tsv) without requiring Excel Interop. - [Read XLSX File C#](https://ironsoftware.com/csharp/excel/how-to/c-sharp-read-xlsx-file/): This tutorial page demonstrates how to read XLSX Excel files in C# using the IronXL library, covering installation, loading workbooks, accessing worksheets, reading cell data, applying functions, and converting Excel data to DataTable/DataSet formats with code examples. - [Cell Font and Size](https://ironsoftware.com/csharp/excel/how-to/cell-font-size/): This page provides a comprehensive C# tutorial for programmatically setting Excel cell font properties (including size, family, bold, italic, underline, color, and other styling options) using the IronXL library without requiring Microsoft Office interop. - [Clear Cell](https://ironsoftware.com/csharp/excel/how-to/clear-cells/): This page documents how to use the IronXL C# library's ClearContents() method to programmatically remove data from Excel cells, ranges, rows, or columns while preserving formatting, providing code examples and explaining when to use different clearing approaches for automated Excel manipulation without requiring Microsoft Excel installation. - [Conditional Formatting](https://ironsoftware.com/csharp/excel/how-to/conditional-formatting/): A tutorial page that teaches developers how to programmatically apply conditional formatting to Excel spreadsheets using the IronXL C# library, covering rule creation with comparison operators, styling options, and methods for adding, retrieving, and removing conditional formatting from cell ranges without requiring Microsoft Excel Interop. - [Convert Spreadsheet File Types](https://ironsoftware.com/csharp/excel/how-to/convert-spreadsheet-file-types/): This webpage provides a comprehensive guide on converting Excel spreadsheet files to various formats (CSV, JSON, XML, HTML) using IronXL's C# library, featuring code examples and step-by-step instructions for developers needing to transform spreadsheet data between different file types in their .NET applications. - [Copy Cell](https://ironsoftware.com/csharp/excel/how-to/copy-cells/): This page provides a comprehensive tutorial on using IronXL's Copy method in C# to duplicate Excel cells, ranges, rows, and columns while preserving all formatting, formulas, and styling, with code examples demonstrating single-cell copying and explaining the method's parameters and capabilities. - [Create Spreadsheets](https://ironsoftware.com/csharp/excel/how-to/create-spreadsheet/): This tutorial page demonstrates how to create new Excel spreadsheets programmatically in C# using IronXL's WorkBook.Create() method, providing code examples and explaining the differences between XLSX and XLS formats without requiring Excel interop dependencies. - [Convert XLSX to CSV, JSON, XML](https://ironsoftware.com/csharp/excel/how-to/csharp-convert-xlsx-to-csv/): This page provides a comprehensive tutorial on how to use the IronXL C# library to programmatically convert XLSX Excel files to various formats including CSV, JSON, XML, and older Excel formats without requiring Microsoft Excel or Interop, featuring code examples and installation instructions. - [Create Excel Charts in C#](https://ironsoftware.com/csharp/excel/how-to/csharp-create-excel-chart-programmatically/): This page provides a comprehensive tutorial on using the IronXL C# library to programmatically create various types of Excel charts (column, line, pie, bar, area, scatter) by demonstrating the CreateChart(), AddSeries(), and Plot() methods with code examples and step-by-step installation instructions. - [Convert a Data Table to CSV](https://ironsoftware.com/csharp/excel/how-to/csharp-datatable-to-csv/): This page provides a comprehensive tutorial on converting C# DataTable objects to CSV files using the IronXL library, featuring installation instructions, code examples, and a step-by-step guide for implementing the one-line SaveAsCsv() method without requiring Microsoft Excel or complex loops. - [Edit Excel Files in C#](https://ironsoftware.com/csharp/excel/how-to/csharp-edit-excel-file/): This tutorial page teaches developers how to programmatically edit Excel files in C# using the IronXL library, covering operations like modifying specific cells, rows, columns, and worksheets without requiring Microsoft Office Interop, with code examples and step-by-step instructions. - [Create and Edit Charts](https://ironsoftware.com/csharp/excel/how-to/csharp-excel-chart-create-edit-tutorial/): This page provides a comprehensive C# tutorial for creating and editing Excel charts programmatically using the IronXL library, demonstrating how to generate various chart types (column, line, pie, bar, scatter, area) without Excel Interop dependencies through simple API calls and code examples. - [Merge and Unmerge Cells](https://ironsoftware.com/csharp/excel/how-to/csharp-excel-merge-cells/): This page provides a comprehensive tutorial on using IronXL's C# library to programmatically merge and unmerge Excel cells, explaining the methods, code examples, potential conflicts with Excel features like filtering and sorting, and best practices for cell merging in spreadsheet manipulation. - [Import Excel Data in C#](https://ironsoftware.com/csharp/excel/how-to/csharp-import-excel/): A tutorial page that demonstrates how to import Excel files (XLSX, CSV, etc.) into C# applications using the IronXL library without Microsoft Office or Interop dependencies, providing code examples and step-by-step instructions for loading, accessing, and manipulating spreadsheet data. - [Read a CSV in C#](https://ironsoftware.com/csharp/excel/how-to/csharp-read-csv-file/): This page provides a tutorial on how to read CSV files in C# using the IronXL library, demonstrating installation methods, code examples for loading CSV files with custom delimiters, and converting them to Excel format in .NET applications. - [Write CSV in .NET](https://ironsoftware.com/csharp/excel/how-to/csharp-write-to-csv-file/): This page provides a tutorial on how to write CSV files in C# .NET using the IronXL library, demonstrating how to convert Excel workbooks to CSV format with a single line of code without manual parsing. - [Edit Formulas](https://ironsoftware.com/csharp/excel/how-to/edit-formulas/): This tutorial page explains how to programmatically edit, set, and evaluate Excel formulas in C# using the IronXL library, which supports over 165 Excel functions and allows formula manipulation without requiring Microsoft Office installation. - [Edit Workbook Metadata](https://ironsoftware.com/csharp/excel/how-to/edit-workbook-metadata/): This page provides a tutorial on how to programmatically edit Excel workbook metadata (such as author, title, keywords, creation date, and other document properties) using IronXL's C# library without requiring Microsoft Interop. - [Import and export as DataSet](https://ironsoftware.com/csharp/excel/how-to/export-dataset-datatable/): This page provides a comprehensive guide for C# developers on how to import DataSets/DataTables into Excel workbooks and export Excel workbooks as DataSets/DataTables using the IronXL library, with code examples demonstrating simple method calls like LoadWorkSheetsFromDataSet() and ToDataSet() for seamless conversion between Excel and .NET data structures. - [Group and Ungroup](https://ironsoftware.com/csharp/excel/how-to/group-and-ungroup-rows-columns/): This tutorial page demonstrates how to programmatically group and ungroup rows and columns in Excel spreadsheets using C# and the IronXL library, providing code examples and explaining how to create collapsible sections for better data organization without requiring Excel Interop. - [Set Hyperlink](https://ironsoftware.com/csharp/excel/how-to/hyperlinks/): This page provides a comprehensive tutorial on how to programmatically create various types of hyperlinks (URLs, file paths, email addresses, and cell references) in Excel spreadsheets using the IronXL C# library, demonstrating code examples and explaining the implementation process without requiring Microsoft Office Interop. - [Load Spreadsheets](https://ironsoftware.com/csharp/excel/how-to/load-spreadsheet/): This page provides a comprehensive guide on using IronXL's C# library to load existing Excel files (XLSX, XLS, XLSM, XLTX), CSV, TSV, and DataSet objects into workbooks for data manipulation, featuring code examples and methods like WorkBook.Load() and LoadCSV(). - [Manage Worksheet](https://ironsoftware.com/csharp/excel/how-to/manage-worksheet/): This page provides documentation on how to programmatically manage Excel worksheets in C# using IronXL library, covering operations like creating, deleting, moving, and copying worksheets without requiring Microsoft Office Interop dependencies. - [Math Functions](https://ironsoftware.com/csharp/excel/how-to/math-functions/): This page documents how to use IronXL's built-in mathematical aggregation functions (Sum, Average, Min, Max) to perform calculations on Excel data ranges directly in C# without requiring Microsoft Office Interop, including code examples and implementation details. - [Named Range](https://ironsoftware.com/csharp/excel/how-to/named-range/): This tutorial page explains how to programmatically create, retrieve, and manage named ranges in Excel spreadsheets using IronXL's C# library, providing code examples and best practices for implementing named ranges to improve formula readability and code maintainability. - [Named Table](https://ironsoftware.com/csharp/excel/how-to/named-table/): This page provides a C# tutorial for using IronXL library to create named tables (Excel Tables) in Excel spreadsheets programmatically, demonstrating how to add structured data ranges with custom names, styles, and filtering options using the AddNamedTable method. - [Select Range](https://ironsoftware.com/csharp/excel/how-to/select-range/): This page provides a comprehensive guide on how to programmatically select and manipulate Excel cell ranges, rows, and columns in C# using the IronXL library without requiring Microsoft Office Interop, featuring code examples and syntax for operations like workSheet["A1:C3"], GetRow(), and GetColumn() methods. - [Set Cell Data Formats](https://ironsoftware.com/csharp/excel/how-to/set-cell-data-format/): This page provides a comprehensive guide on how to format Excel cells in C# using IronXL library without Interop dependencies, covering built-in formats (currency, dates, percentages) and custom number formats through the FormatString property, with code examples and practical implementation steps. - [Encrypt Workbook with Password](https://ironsoftware.com/csharp/excel/how-to/set-password-workbook/): This tutorial page demonstrates how to password-protect and encrypt Excel workbooks in C# using the IronXL library, covering methods to set passwords, access protected files, and remove encryption without requiring Microsoft Office Interop. - [Encrypt Worksheet with Password](https://ironsoftware.com/csharp/excel/how-to/set-password-worksheet/): This tutorial page explains how to password protect Excel worksheets in C# using IronXL's ProtectSheet method, demonstrating both basic single-line protection and advanced scenarios including protecting multiple sheets, removing protection, and handling already-protected worksheets programmatically. - [Sort Cell Range](https://ironsoftware.com/csharp/excel/how-to/sort-cells/): This page provides C# code examples and documentation for sorting Excel cells, columns, and ranges using the IronXL library, demonstrating both independent column sorting and range sorting by a specific column key while maintaining row relationships. - [Trim Cell Range](https://ironsoftware.com/csharp/excel/how-to/trim-cell-range/): This page explains how to use IronXL's C# library to trim empty border cells from Excel ranges, rows, and columns programmatically without requiring Microsoft Office Interop, providing code examples and explaining the trim functionality for cleaning Excel data. - [Write Excel Values in .NET](https://ironsoftware.com/csharp/excel/how-to/write-excel-net/): This tutorial page demonstrates how to write data to Excel files in C# using the IronXL library, covering basic cell value assignment, accessing worksheets, writing to specific cells and ranges, and replacing values programmatically with simple code examples. ### Product Updates - [Changelog](https://ironsoftware.com/csharp/excel/product-updates/changelog/): This web page provides detailed information on the latest enhancements, bug fixes, and updates for the IronXL Excel Library, aiding developers in improving their C# spreadsheet applications. - [Milestones: Enhancing](https://ironsoftware.com/csharp/excel/product-updates/milestones-enhancing/): This webpage on Iron Software's site discusses the significant performance and memory efficiency enhancements in the IronXL v2024.12.x update, which include a 40x increase in processing speed and a reduction in memory usage from 19.5 GB to under 1 GB, enabling efficient Excel automation even on lower-spec systems. - [Milestones: Performance](https://ironsoftware.com/csharp/excel/product-updates/milestones-performance/): This web page details the significant performance and memory improvements in the latest IronXL .NET Excel document library release, highlighting key efficiency gains and comparative metrics against previous versions and competitors. - [Milestones](https://ironsoftware.com/csharp/excel/product-updates/milestones/): This page offers a detailed chronology of significant developments and product updates for the IronXL for .NET library, highlighting key milestones and performance improvements since 2023. ### Troubleshooting Guides - [Apply a license key in IronXL](https://ironsoftware.com/csharp/excel/troubleshooting/apply-a-license-key-in-ironxl/): This web page provides a detailed guide on applying a license key in IronXL, including code examples for Python and C#, ensuring proper licensing of the Excel software. - [Excel Limitation: Data Validation for String Lists](https://ironsoftware.com/csharp/excel/troubleshooting/excel-limitation-data-validation-for-string-lists/): This web page discusses the limitations and workarounds for data validation of string lists in Excel using IronXL. - [File Size Limits](https://ironsoftware.com/csharp/excel/troubleshooting/file-size-limits/): This page provides troubleshooting guidance and solutions for managing file size limits in IronXL, a C# Excel library, focusing on resolving issues with older Excel file formats and optimizing large files. - [IronXL - Security CVE](https://ironsoftware.com/csharp/excel/troubleshooting/ironxl-security-cve/): This page provides detailed information on IronXL's security measures, CVE disclosures, and its robust protection against vulnerabilities, highlighting its DigiCert certification, lack of COM interfaces, and thorough code review process. - [Setting License Key in Web.config](https://ironsoftware.com/csharp/excel/troubleshooting/license-key-web.config/): This web page provides step-by-step guidance for resolving licensing issues with IronXL in ASP.NET projects by configuring the license key in the web.config file using the ConfigurationManager, specifically for versions between 2023.4.13 and 2024.3.20. ### Tutorials - [Create Excel Files in C#](https://ironsoftware.com/csharp/excel/tutorials/create-excel-file-net/): This web page provides a detailed tutorial on creating Excel files in C# without using Microsoft Office Interop, featuring step-by-step instructions for generating XLSX spreadsheets and applying various functions using IronXL. - [Use C# to Open & Write an Excel File](https://ironsoftware.com/csharp/excel/tutorials/csharp-open-write-excel-file/): This web page provides a comprehensive tutorial with code examples on writing to Excel files using C# without Interop, enabling users to open and manage Excel files and workbooks efficiently with IronXL. - [How to Read an Excel File in C#](https://ironsoftware.com/csharp/excel/tutorials/how-to-read-excel-file-csharp/): This web page provides a comprehensive tutorial for developers on reading Excel files in C# without using Interop, utilizing libraries for tasks such as data validation and conversion to databases. ### API Reference - [API Reference](https://ironsoftware.com/csharp/excel/object-reference/api/): Official index of classes, methods, and properties of the IronXL library (namespace: `IronXL.Excel`) ## Code Examples - [Add, Extract, and Remove Images in Excel with C#](https://ironsoftware.com/csharp/excel/examples/add-extract-remove-worksheet-images/): This web page provides C# code examples demonstrating how to add, extract, and remove images in Excel worksheets using the IronXL library. - [Master Excel Aggregate Functions in C#](https://ironsoftware.com/csharp/excel/examples/aggregate-excel-functions/): This page provides a guide and code examples for using Excel aggregate functions like SUM, AVERAGE, and COUNT in C# with IronXL. - [Auto-Resize Excel Rows and Columns in C#](https://ironsoftware.com/csharp/excel/examples/auto-resize-rows-and-columns/): This page provides C# code examples using the IronXL library to automate the resizing of rows and columns in Excel spreadsheets for enhanced readability and professional presentation. - [Combine Multiple Excel Ranges in C#](https://ironsoftware.com/csharp/excel/examples/combine-excel-ranges/): This page provides a tutorial on using IronXL in C# to merge multiple Excel ranges for enhanced data organization within workbook sheets, including practical code examples and detailed explanations. - [Convert Spreadsheet File Types](https://ironsoftware.com/csharp/excel/examples/convert-excel-spreadsheet/): This webpage provides a comprehensive tutorial on using IronXL in C# to convert Excel spreadsheets into various formats like XLSX, JSON, and HTML, facilitating seamless data manipulation and integration in applications. - [Convert Excel to HTML](https://ironsoftware.com/csharp/excel/examples/convert-excel-to-html/): This webpage provides a guide on converting Excel files to HTML using C# with IronXL, including code examples and customization options for the HTML output. - [Copy Excel Worksheets](https://ironsoftware.com/csharp/excel/examples/copy-an-excel-worksheet/): This web page provides a detailed code example and explanation on how to copy Excel worksheets within the same workbook or to another workbook using IronXL in C#. - [Create Excel Chart](https://ironsoftware.com/csharp/excel/examples/create-a-excel-line-chart/): This web page provides a comprehensive guide and example code on creating Excel line charts using C# and the IronXL library, including steps such as loading a workbook, entering data, initializing a chart, and saving the file. - [Create a new Excel File](https://ironsoftware.com/csharp/excel/examples/create-excel-spreadsheet/): This web page provides a comprehensive guide for developers on creating and styling Excel spreadsheets in C# using IronXL, including code examples and advanced formatting options. - [Edit Excel Metadata in C#](https://ironsoftware.com/csharp/excel/examples/edit-excel-metadata-csharp/): This page provides a comprehensive guide on editing Excel metadata programmatically using C# and IronXL, including code examples to update workbook properties like author, title, and subject efficiently for automated workflows. - [Excel Conditional Formatting](https://ironsoftware.com/csharp/excel/examples/excel-conditional-formatting/): This web page provides a comprehensive guide on implementing Excel conditional formatting using IronXL in C#, detailing how to apply formatting rules to improve data visualization. - [Excel Formulas in C#](https://ironsoftware.com/csharp/excel/examples/excel-formulas-csharp/): This web page provides a comprehensive guide and code examples for using IronXL to implement and evaluate Excel formulas in C# applications without relying on Office Interop. - [Excel Number Format](https://ironsoftware.com/csharp/excel/examples/excel-number-formats/): This web page provides a tutorial on using the IronXL library in C# to apply number formats to Excel cells, complete with code examples and downloadable resources. - [Excel Print Setup](https://ironsoftware.com/csharp/excel/examples/excel-print-setup/): This web page provides a detailed guide and code examples for setting up Excel print settings in C# using IronXL, focusing on configuring print layouts, headers, footers, and other customizable print options for optimized document printing. - [Excel to SQL via System.Data.DataSet](https://ironsoftware.com/csharp/excel/examples/excel-sql-dataset/): This web page provides a tutorial for using IronXL in C# to load and manage Excel data within SQL datasets, offering code examples to integrate Excel with SQL databases effectively. - [Excel to SQL and DataGrid via DataTable](https://ironsoftware.com/csharp/excel/examples/excel-sql-datatable/): This web page provides a code example and tutorial on converting Excel files to SQL DataTables using C# with IronXL, including interoperability with DataGrid and step-by-step instructions for implementation. - [Style Cells, Borders, and Fonts in Excel with C#](https://ironsoftware.com/csharp/excel/examples/excel-style-cells-borders-fonts/): This web page provides a comprehensive guide on how to style Excel cells, borders, and fonts using the IronXL library in C# projects. - [Update Excel Database Records](https://ironsoftware.com/csharp/excel/examples/excel-update-database-records/): This web page provides a comprehensive guide on using IronXL in C# to update SQL database records directly from Excel files, featuring step-by-step instructions, sample code, and insights into seamless data synchronization. - [Export Excel Spreadsheets in C#](https://ironsoftware.com/csharp/excel/examples/export-excel-spreadsheet/): This page provides a detailed guide and code examples for exporting Excel spreadsheets to various formats using IronXL in C#, enhancing data integration and simplifying reporting in .NET applications. - [Freeze Panes in Excel](https://ironsoftware.com/csharp/excel/examples/freeze-panes-in-excel/): This web page provides a comprehensive guide with code examples on how to freeze panes in Excel using C# and IronXL to enhance data navigation by locking specific rows and columns in place. - [Group & Ungroup Rows & Columns](https://ironsoftware.com/csharp/excel/examples/group-and-ungroup-rows-and-columns/): This web page provides a guide on using the IronXL C# library to efficiently group and ungroup rows and columns in Excel worksheets without using Interop. - [Insert New Rows & Columns](https://ironsoftware.com/csharp/excel/examples/insert-new-rows-and-columns/): This web page provides a tutorial on using the IronXL C# library to insert new rows and columns into Excel worksheets without requiring Office Interop, including code examples for implementation. - [Load Excel From SQL Database](https://ironsoftware.com/csharp/excel/examples/load-excel-from-sql-database/): This web page provides a detailed tutorial on using IronXL to load Excel data directly from SQL databases in C#, including example code and steps to automate data export in .NET applications. - [Protect Excel Files](https://ironsoftware.com/csharp/excel/examples/protect-excel-file/): This web page provides a comprehensive guide on using IronXL in C# to protect Excel files through password encryption and sheet-level protection, ensuring data security and controlled access in automated workflows. - [Load Excel Files without Interop](https://ironsoftware.com/csharp/excel/examples/read-excel/): This web page provides a detailed guide and code examples on how to read and manipulate Excel files using IronXL in C#, focusing on loading workbooks without Interop for tasks like data extraction, calculations, and automation. - [Repeat Rows & Columns in Excel via C#](https://ironsoftware.com/csharp/excel/examples/repeating-rows-and-columns-in-excel/): This web page provides C# code examples and instructions using IronXL to repeat specific rows or columns on every printed page of an Excel file, enhancing readability across multi-page spreadsheets. - [Select Excel Range](https://ironsoftware.com/csharp/excel/examples/select-excel-range/): This web page provides a tutorial on selecting Excel ranges programmatically in C# using IronXL, including examples for selecting specific ranges, rows, and columns, along with sorting and calculation methods. - [Sort Excel Ranges in C#](https://ironsoftware.com/csharp/excel/examples/sort-excel-range-csharp/): This web page provides a comprehensive guide and code examples for sorting data in Excel using C# with IronXL, demonstrating methods for sorting columns, rows, and specific ranges in .NET applications. ## Product Features - [Features](https://ironsoftware.com/csharp/excel/features/): This page provides an in-depth overview of IronXL's features for handling Excel files in C#, including capabilities for reading, writing, editing, and utilizing advanced functionalities such as formulas and charts in .NET applications. - [Create](https://ironsoftware.com/csharp/excel/features/create/): This web page from IronXL provides an overview of features for creating and customizing Excel workbooks in C# using IronXL's API, including capabilities such as creating spreadsheets from scratch, duplicating worksheets, setting worksheet positions, and customizing spreadsheet content. - [Edit](https://ironsoftware.com/csharp/excel/features/edit/): This web page provides detailed information on editing Excel workbooks using IronXL, including customization options such as styles, graphs, and images to enhance data analysis. - [Features](https://ironsoftware.com/csharp/excel/features/): This web page provides an in-depth overview of IronXL's features, showcasing its capabilities for creating, editing, saving, exporting, and securing Excel files using C# in .NET environments. - [Save & Export](https://ironsoftware.com/csharp/excel/features/save-export/): This web page provides an overview of the features offered by IronXL for saving and exporting Excel files in various formats, including XLS, XLSX, CSV, TSV, JSON, and HTML, and details how to import and export DataSets efficiently. - [Secure](https://ironsoftware.com/csharp/excel/features/secure/): This web page from IronXL provides information on securing Excel workbooks and worksheets through password protection and encryption features, ensuring data privacy and authorized access. - [Working with Data](https://ironsoftware.com/csharp/excel/features/working-with-data/): This web page provides an overview of IronXL's data manipulation features, enabling users to work with math functions and formulas directly within spreadsheets without the need for Microsoft Excel, including support for over 165 formulas and functions like Average, Sum, Min, and Max. ## Licensing - [Extensions](https://ironsoftware.com/csharp/excel/licensing/extensions/): This web page provides information on upgrading and renewing IronXL licenses to enhance Excel capabilities, increase user capacity, and add enterprise-level features. - [Licensing](https://ironsoftware.com/csharp/excel/licensing/): This page provides detailed information about IronXL's licensing options, usage limits, and upgrade opportunities for developing Excel-based applications in C#. - [Upgrades](https://ironsoftware.com/csharp/excel/licensing/upgrades/): This web page provides guidance on upgrading and renewing licenses for IronXL, helping users scale Excel functionalities in C# applications, unlock advanced features, and maintain ongoing support.