# IronXL > The C# Excel Spreadsheet Library. Read and Write Excel documents in .NET Applications. Supports .NET Core and .NET Framework. ## Agent Skill - [IronXL Agent Skill](https://ironsoftware.com/excel/csharp/skill.md): Drop-in SKILL.md that teaches coding agents such as Claude Code, Cursor and GitHub Copilot to use IronXL correctly, covering installation, licensing, the core APIs and common pitfalls. ## Documentation ### Overview - [Master IronXL: A Step-by-Step Guide for Excel Manipulation](https://ironsoftware.com/excel/csharp/docs/): Learn how to use IronXL for Excel file manipulation in Visual Studio 2022. This guide covers installation, file modification, and exporting to various formats like CSV, XML, and JSON. ### Getting Started - [AWS Lambada Support | IronXL](https://ironsoftware.com/excel/csharp/get-started/aws/): IronXL fully supports AWS Lambda Function for .NET Standard Libraries, Core applications, .NET 5 and .NET 6 projects.. - [Azure Support | IronXL](https://ironsoftware.com/excel/csharp/get-started/azure/): Integrate IronXL with Azure for your Excel applications. Follow this guide to deploy and use Excel features on Azure. - [Blazor Read Excel File (Without Using Interop) | IronXL](https://ironsoftware.com/excel/csharp/get-started/blazor-read-excel-file-tutorial/): In this post, we'll share knowledge about the best and easy method for reading Excel document/worksheets in Blazor server side application using the IronXL C# library. - [C# Excel Interop Alternatives by IronXL (No Interop Needed)](https://ironsoftware.com/excel/csharp/get-started/c-sharp-excel-interop/): CSharp Excel Interop Workaround. Use the library tutorial to read, create, and modify Excel files without using Interop - [Docker Support | IronXL](https://ironsoftware.com/excel/csharp/get-started/docker/): Learn how to use IronXL in Docker. Follow this guide to set up and run your Excel applications in a containerized environment. - [Applying Software License Keys for IronXL .NET 10](https://ironsoftware.com/excel/csharp/get-started/license-keys/): Learn how to implement and manage license keys for IronXL in your C# applications. Ensure proper usage and compliance. - [Linux Support | IronXL & .NET 10 Compatibility Guide](https://ironsoftware.com/excel/csharp/get-started/linux/): Get started with using IronXL on Linux. Learn how to set up, configure, and run Excel operations in a Linux environment. - [macOS Support | IronXL for .NET 10](https://ironsoftware.com/excel/csharp/get-started/macos/): Implement IronXL in your MacOS applications. Follow this guide to create, read, and manage Excel files on MacOS with C#. - [.NET MAUI Excel in C# (Without Using Interop) | IronXL](https://ironsoftware.com/excel/csharp/get-started/read-create-excel-net-maui/): In this article, we will explain how to create and read Excel files in .NET MAUI apps using Windows machines. Let's get started. - [VB.NET Read Excel File (Without Using Interop) | IronXL](https://ironsoftware.com/excel/csharp/get-started/vb-net-excel-files/): VB NET Excel Files Functions Walkthrough. Easily work with your Excel VB.NET projects with these step by step examples. ### How-To Guides - [Add Comments to Excel Cells in C# Without Interop | IronXL](https://ironsoftware.com/excel/csharp/how-to/add-comment/): Add comments to Excel cells in C# using IronXL's AddComment method. No interop needed. Set author, content & visibility. Simple API for cell annotations. - [Add, Extract & Remove Images in Excel with C# | IronXL](https://ironsoftware.com/excel/csharp/how-to/add-extract-remove-worksheet-images/): Add, extract & remove images in Excel worksheets using C# with IronXL. Insert logos, extract graphics & manage images programmatically without Interop. - [C# Excel Freeze Panes: Lock Headers & Rows | IronXL](https://ironsoftware.com/excel/csharp/how-to/add-freeze-panes/): Lock Excel headers & rows in C# with IronXL. Add freeze panes programmatically to keep columns/rows visible while scrolling large spreadsheets. - [Add Rows & Columns to Excel in C# - No Interop | IronXL](https://ironsoftware.com/excel/csharp/how-to/add-rows-columns/): Add rows & columns to Excel in C# using IronXL. Insert, modify spreadsheets programmatically without Office Interop. Easy API for dynamic Excel editing. - [Read Excel Files in ASP.NET MVC with C# - IronXL Guide](https://ironsoftware.com/excel/csharp/how-to/asp-net-mvc-read-excel-file/): Learn to read Excel files in ASP.NET MVC using C# and IronXL. Convert Excel to DataTable without Office dependencies. Quick setup guide included. - [Auto Resize Excel Rows & Columns in C# | IronXL Tutorial](https://ironsoftware.com/excel/csharp/how-to/autosize-rows-columns/): Auto resize Excel rows & columns in C# with IronXL. Use AutoSizeRow() and AutoSizeColumn() methods to adjust cell dimensions based on content automatically. - [C# Excel Background Pattern & Color Tutorial | IronXL](https://ironsoftware.com/excel/csharp/how-to/background-pattern-color/): Master Excel cell styling in C# with IronXL. Set background patterns, colors & visual effects programmatically. No Interop needed. Quick tutorial & code. - [C# Excel Cell Border & Alignment Tutorial | IronXL Guide](https://ironsoftware.com/excel/csharp/how-to/border-alignment/): Master Excel cell borders & alignment in C# with IronXL. Apply styles like MediumDashed borders & center text without MS Office dependencies. - [C# Export to Excel: Convert XLSX, CSV, JSON & XML | IronXL](https://ironsoftware.com/excel/csharp/how-to/c-sharp-export-to-excel/): Export Excel files in C# to XLSX, CSV, JSON & XML formats using IronXL. Simple one-line conversions without Office dependencies. Complete guide. - [Open Excel Worksheets in C# | IronXL Tutorial Guide](https://ironsoftware.com/excel/csharp/how-to/c-sharp-open-excel-worksheet/): Learn to open Excel worksheets in C# using IronXL's WorkBook.Load() & GetWorkSheet() methods. Access .xlsx, .xls, .csv files with just 2 lines of code. - [C# Read XLSX Files Tutorial - Load Excel Data | IronXL](https://ironsoftware.com/excel/csharp/how-to/c-sharp-read-xlsx-file/): Learn to read XLSX files in C# using IronXL. Load Excel workbooks, access worksheets, read cell data & convert to DataTable with simple code examples. - [C# Excel Cell Font & Size Tutorial | IronXL Guide](https://ironsoftware.com/excel/csharp/how-to/cell-font-size/): Master Excel cell font styling in C# with IronXL. Set font size, family, bold, italic & colors programmatically without Office interop. Quick tutorial. - [Clear Excel Cells in C# - IronXL ClearContents Method](https://ironsoftware.com/excel/csharp/how-to/clear-cells/): Clear Excel cell contents in C# with IronXL ClearContents method. Remove data from cells, ranges & columns while preserving formatting. No Excel needed. - [C# Excel Conditional Formatting Guide | IronXL Tutorial](https://ironsoftware.com/excel/csharp/how-to/conditional-formatting/): Learn C# Excel conditional formatting with IronXL. Apply rules, styles & conditions to cells programmatically. No Interop needed. Tutorial & examples. - [Convert Excel to CSV, JSON & XML in C# | IronXL Guide](https://ironsoftware.com/excel/csharp/how-to/convert-spreadsheet-file-types/): Convert Excel to CSV, JSON & XML in C# with IronXL. Load XLS/XLSX files and export to multiple formats using simple SaveAs methods. Easy file conversion. - [Copy Excel Cells in C# - Examples & Tutorial | IronXL](https://ironsoftware.com/excel/csharp/how-to/copy-cells/): Copy Excel cells in C# with IronXL. Duplicate data, formulas & formatting between worksheets. Easy one-line cell, range & column copying. Tutorial & examples. - [Create New Excel Spreadsheets in C# | IronXL Tutorial](https://ironsoftware.com/excel/csharp/how-to/create-spreadsheet/): Learn to create Excel spreadsheets in C# using IronXL's WorkBook.Create() method. Generate XLSX/XLS files without Excel interop dependencies. - [C# Convert XLSX to CSV, JSON, XML Without Excel | IronXL](https://ironsoftware.com/excel/csharp/how-to/csharp-convert-xlsx-to-csv/): Convert XLSX to CSV, JSON & XML in C# with IronXL. Simple one-line commands transform Excel files without Interop. Free trial available. - [C# Create Excel Charts Programmatically | IronXL Guide](https://ironsoftware.com/excel/csharp/how-to/csharp-create-excel-chart-programmatically/): Create Excel charts in C# with IronXL. Generate column, line & pie charts programmatically using CreateChart(), AddSeries() & Plot() methods. - [C# DataTable to CSV Export: Easy IronXL Conversion Guide](https://ironsoftware.com/excel/csharp/how-to/csharp-datatable-to-csv/): Convert C# DataTable to CSV easily with IronXL. Export data using SaveAsCsv() method - no loops or complex code needed. Quick one-line conversion guide. - [C# Edit Excel Files Without Interop | IronXL Tutorial](https://ironsoftware.com/excel/csharp/how-to/csharp-edit-excel-file/): Edit Excel files in C# using IronXL. Modify cells, rows & worksheets programmatically without Interop. Fast, simple Excel editing tutorial & code examples. - [Create & Edit Excel Charts in C# Without Interop | IronXL](https://ironsoftware.com/excel/csharp/how-to/csharp-excel-chart-create-edit-tutorial/): Create & edit Excel charts in C# with IronXL. Generate column, line, pie charts programmatically without Excel Interop. Simple API for data visualization. - [C# Excel Cell Merge & Unmerge Tutorial | IronXL Guide](https://ironsoftware.com/excel/csharp/how-to/csharp-excel-merge-cells/): Merge & unmerge Excel cells in C# with IronXL. Simple methods like Merge() combine cells for headers & formatting. No Excel Interop needed. Tutorial & code. - [Import Excel Files in C# Tutorial | No Interop | IronXL](https://ironsoftware.com/excel/csharp/how-to/csharp-import-excel/): Import Excel files in C# with IronXL - no Interop needed. Load XLSX, CSV & more in one line. Access cells, ranges & worksheets instantly. - [C# Read CSV Files: Quick Tutorial with IronXL Library](https://ironsoftware.com/excel/csharp/how-to/csharp-read-csv-file/): C# Read CSV Files easily with IronXL LoadCSV method. One-line solution for reading CSV, custom delimiters & Excel conversion in .NET applications. - [Write CSV Files in C# .NET with IronXL | Step-by-Step](https://ironsoftware.com/excel/csharp/how-to/csharp-write-to-csv-file/): Learn to write CSV files in C# using IronXL. Convert Excel to CSV with one line of code. Step-by-step tutorial for .NET developers. No manual parsing needed. - [Edit Excel Formulas in C# - IronXL Formula Tutorial](https://ironsoftware.com/excel/csharp/how-to/edit-formulas/): Edit Excel formulas in C# with IronXL. Set Formula property, retrieve results with FormattedCellValue & recalculate with EvaluateAll(). 165+ formulas supported. - [Edit Excel Metadata in C# - Set Author & Title | IronXL](https://ironsoftware.com/excel/csharp/how-to/edit-workbook-metadata/): Edit Excel metadata in C# with IronXL. Set author, title & keywords programmatically. No Microsoft Interop needed. Quick & easy spreadsheet management. - [Import & Export DataSet/DataTable in C# Excel | IronXL](https://ironsoftware.com/excel/csharp/how-to/export-dataset-datatable/): Import & export Excel files as DataSet/DataTable in C# with IronXL. Convert workbooks to .NET DataSets & load data tables into Excel sheets easily. - [C# Excel Row Column Grouping - IronXL Tutorial Guide](https://ironsoftware.com/excel/csharp/how-to/group-and-ungroup-rows-columns/): Group Excel rows & columns in C# with IronXL. Create collapsible sections, organize data hierarchically. No Interop needed. Free trial available. - [Create Excel Hyperlinks in C# | Add Links with IronXL](https://ironsoftware.com/excel/csharp/how-to/hyperlinks/): Add Excel hyperlinks in C# with IronXL. Create clickable URLs, file paths, email links & cell references programmatically without Interop. - [Load Excel Files in C# with IronXL | Complete Guide](https://ironsoftware.com/excel/csharp/how-to/load-spreadsheet/): Load Excel files in C# using IronXL. Open XLSX, XLS, CSV & TSV files with WorkBook.Load(). Complete guide for .NET spreadsheet data manipulation. - [C# Excel Worksheet Management Without Interop | IronXL](https://ironsoftware.com/excel/csharp/how-to/manage-worksheet/): Manage Excel worksheets in C# with IronXL. Create, delete, move & copy sheets without Office Interop. Simple API for worksheet operations. Try it free! - [C# Excel Math Functions: Sum, Avg, Min, Max | IronXL](https://ironsoftware.com/excel/csharp/how-to/math-functions/): Master C# Excel math functions with IronXL. Calculate Sum, Avg, Min, Max on ranges instantly. No Interop needed for Excel data analysis in .NET apps. - [Add Named Range in Excel with C# | IronXL Tutorial](https://ironsoftware.com/excel/csharp/how-to/named-range/): Create & manage Excel named ranges in C# using IronXL. Add, retrieve & remove named ranges programmatically for cleaner formulas & better code readability. - [Add Named Tables in Excel with C# | IronXL Tutorial](https://ironsoftware.com/excel/csharp/how-to/named-table/): Learn to create Excel named tables in C# with IronXL. Add tables with custom styles, filters & ranges using simple AddNamedTable method calls. - [C# Excel Range Selection Without Interop | IronXL Guide](https://ironsoftware.com/excel/csharp/how-to/select-range/): Master C# Excel range selection with IronXL. Select cells, rows & columns using simple syntax like workSheet["A1:C3"]. No Office Interop needed. - [C# Excel Cell Formatting Guide (No Interop) | IronXL](https://ironsoftware.com/excel/csharp/how-to/set-cell-data-format/): Format Excel cells in C# with IronXL - no Interop needed. Set currency, date, percentage & custom formats using FormatString property. Easy API guide. - [Password Protect Excel Workbooks in C# | IronXL Tutorial](https://ironsoftware.com/excel/csharp/how-to/set-password-workbook/): Learn to password protect Excel workbooks in C# using IronXL. Set, remove & access encrypted files with simple code. No Interop needed. Tutorial & examples. - [C# Password Protect Excel Worksheet - IronXL Tutorial](https://ironsoftware.com/excel/csharp/how-to/set-password-worksheet/): C# password protect Excel worksheets with IronXL. Use ProtectSheet method to secure sheets, prevent modifications & control access. Easy tutorial guide. - [Sort Excel Cells in C# - Column & Range Sorting | IronXL](https://ironsoftware.com/excel/csharp/how-to/sort-cells/): Sort Excel cells in C# with IronXL. Easy column & range sorting in one line of code. Supports ascending/descending order for alphabetical & numerical data. - [How to Read Very Large Excel Files in C# with Forward-Only Streaming](https://ironsoftware.com/excel/csharp/how-to/stream-large-excel-files/): Read very large XLSX files in C# with IronXL's forward-only streaming reader. Use WorkBook.StreamRows to pull values row by row with flat memory, discover sheets with GetSheetNames, read by header name with StreamReadOptions, and feed batched ETL imports without loading the workbook. - [Trim Excel Cell Ranges in C# Without Interop | IronXL](https://ironsoftware.com/excel/csharp/how-to/trim-cell-range/): Trim Excel cell ranges in C# with IronXL. Remove empty border cells from ranges, rows & columns without Office Interop. Clean data efficiently. - [C# Write to Excel Files - IronXL .NET Tutorial](https://ironsoftware.com/excel/csharp/how-to/write-excel-net/): Learn to write Excel files in C# with IronXL. Set cell values, update ranges & automate spreadsheets easily. Step-by-step .NET tutorial with examples. ### Product Updates - [IronXL Product Updates | IronXL](https://ironsoftware.com/excel/csharp/product-updates/changelog/): Discover the newest enhancements, bug fixes, and updates for IronXL Excel Library to help you build better C# spreadsheet applications. - [Milestone: Enhancing Document Processing Efficiency | IronXL](https://ironsoftware.com/excel/csharp/product-updates/milestones-enhancing/): At Iron Software, we’re constantly innovating to deliver the best possible tools for developers. With the release of IronXL, we’re taking a step forward in Excel file processing. This update is more than just a performance boost, it enhances how you work with Excel files, combining exceptional speed with remarkable memory efficiency to unlock your development potential - [Milestone: Performance Improvements | IronXL](https://ironsoftware.com/excel/csharp/product-updates/milestones-performance/): IronXL Milestone: Huge Performance and Memory Increases. Read to learn how IronXL became the ultimate .NET Excel document library. - [Milestones | IronXL](https://ironsoftware.com/excel/csharp/product-updates/milestones/): A chronology of the most important developments to the IronXL for .NET library since its first release. ### Troubleshooting Guides - [Apply a License Key in IronXL: Step-by-Step | IronXL](https://ironsoftware.com/excel/csharp/troubleshooting/apply-a-license-key-in-ironxl/): Learn how to apply a license key in IronXL. Follow this step-by-step guide to ensure your Excel software is properly licensed. - [IronXL Data-Loading Method Performance](https://ironsoftware.com/excel/csharp/troubleshooting/data-loading-performance/): Loading large datasets cell by cell is slow in IronXL; switch to a DataTable or CSV load to cut generation time on the same file. - [Excel Limitation: Data Validation for String Lists | IronXL](https://ironsoftware.com/excel/csharp/troubleshooting/excel-limitation-data-validation-for-string-lists/): Learn about the limitations of data validation for string lists in Excel using IronXL. Understand how to work around these limitations effectively. - [IronXL File Size Limits: Troubleshooting and Fixes](https://ironsoftware.com/excel/csharp/troubleshooting/file-size-limits/): Troubleshoot file size limits in IronXL. Learn how to manage and optimize large Excel files effectively. - [IronXL Security CVE: Protect Your Applications](https://ironsoftware.com/excel/csharp/troubleshooting/ironxl-security-cve/): Stay informed about IronXL security updates and CVE disclosures. Learn how to address security vulnerabilities effectively. - [IronXL License Key Troubleshooting | IronXL](https://ironsoftware.com/excel/csharp/troubleshooting/license-key-web.config/): Solve issues with placing your IronXL license key in web.config. Get step-by-step guidance for ASP.NET projects. - [FileNotFoundException for IronXL.XmlSerializers on .NET 10](https://ironsoftware.com/excel/csharp/troubleshooting/saveas-filenotfoundexception-net-10/): A first-chance FileNotFoundException for IronXL.XmlSerializers appears when saving a workbook on .NET 10; enable Just My Code so the debugger stops breaking on the exception IronXL already handles internally. ### Tutorials - [C# Create Excel File in .NET (No Interop Step-by-Step)](https://ironsoftware.com/excel/csharp/tutorials/create-excel-file-net/): Create Excel files in C# without Microsoft Office. Generate XLSX spreadsheets, set cell values, apply formatting & formulas, and export data using IronXL. - [C# Write to Excel [Without Using Interop] | IronXL](https://ironsoftware.com/excel/csharp/tutorials/csharp-open-write-excel-file/): C#: Open Excel File Tutorial. Follow step-by-step with code examples to learn how to C# write to Excel, open Excel files, & open Excel workbooks. - [Read Excel Files in C# Without Interop - IronXL Tutorial & Code Examples](https://ironsoftware.com/excel/csharp/tutorials/how-to-read-excel-file-csharp/): Learn to read Excel files in C# using IronXL library. Complete tutorial with code examples for data validation, database export, and API integration. No Microsoft Office required. ### API Reference - [IronXL API Reference](https://ironsoftware.com/excel/csharp/object-reference/api/): Complete API documentation. ## Code Examples - [Code Example: Manipulate Worksheet Images in Excel | IronXL ](https://ironsoftware.com/excel/csharp/examples/add-extract-remove-worksheet-images/): Learn how to seamlessly add, extract, and remove images from Excel worksheets using IronXL in your C# applications. - [Code Example: Excel Aggregate Functions | IronXL ](https://ironsoftware.com/excel/csharp/examples/aggregate-excel-functions/): Discover how to use aggregate Excel functions (SUM, AVERAGE, COUNT, etc.) programmatically in C# with the help of IronXL. - [Code Examples: Auto-Resizing Excel Rows & Columns | IronXL](https://ironsoftware.com/excel/csharp/examples/auto-resize-rows-and-columns/): Automatically size rows and columns in Excel files using IronXL for neat, professional-looking spreadsheets in your C# projects. - [Code Example: Merge Excel Ranges Tutorial | IronXL for .NET](https://ironsoftware.com/excel/csharp/examples/combine-excel-ranges/): Learn to merge different ranges in Excel workbooks seamlessly using IronXL in your C# projects for easier data organization. - [C# Convert and Export (XLSX, XLS, XLSM, XLTX, CSV) | IronXL](https://ironsoftware.com/excel/csharp/examples/convert-excel-spreadsheet/): Convert Excel spreadsheets to various formats using IronXL in C#. Follow this tutorial to transform your data effortlessly. - [Convert Excel in C# to other File Formats | IronXL ](https://ironsoftware.com/excel/csharp/examples/convert-excel-to-html/): Learn how to convert Excel files to HTML using IronXL in C#. Follow this guide to create web-friendly HTML versions of your spreadsheets. - [Copy Excel Sheets in C# (Code Example) | IronXL](https://ironsoftware.com/excel/csharp/examples/copy-an-excel-worksheet/): Save time. With this code example you can copy an excel sheet to in another workbook in C#. - [Code Examples: Creating Excel Line Charts in C# | IronXL](https://ironsoftware.com/excel/csharp/examples/create-a-excel-line-chart/): Learn how to design visually appealing line charts in Excel directly from your C# code using IronXL. - [C# Create Excel SpreadSheet (XLS and XLSX), Code Examples | IronXL ](https://ironsoftware.com/excel/csharp/examples/create-excel-spreadsheet/): Create Excel spreadsheets from scratch using IronXL in C#. Follow this comprehensive guide to generate and customize your spreadsheets. - [Edit Excel Metadata in C#, Code Examples | IronXL ](https://ironsoftware.com/excel/csharp/examples/edit-excel-metadata-csharp/): Learn how to edit Excel metadata using IronXL in C#. Follow this guide to manage and update document properties effectively. - [Excel Conditional Formatting | IronXL ](https://ironsoftware.com/excel/csharp/examples/excel-conditional-formatting/): Implement conditional formatting in Excel using IronXL in C#. Learn how to apply formatting rules to enhance data visualization. - [Excel Formulas in C# (Code Example) | IronXL](https://ironsoftware.com/excel/csharp/examples/excel-formulas-csharp/): Make it perfect the first time. This code example can help you master Excel formulas in C# with IronXL. - [How to Set Number Format in Excel Using C# | IronXL](https://ironsoftware.com/excel/csharp/examples/excel-number-formats/): Master the C# IronXL library to format numbers in Excel using this simple code example. - [Excel Print Setup in C#, Code Examples | IronXL ](https://ironsoftware.com/excel/csharp/examples/excel-print-setup/): Learn how to set up Excel print settings using IronXL in C#. Follow this guide to configure and optimize your print layouts. - [C# Excel to DataSet, Code Examples | IronXL ](https://ironsoftware.com/excel/csharp/examples/excel-sql-dataset/): Load and manage Excel data from SQL datasets using IronXL in C#. Follow this tutorial to integrate Excel with SQL databases. - [Excel to SQL with DataTable in C# (Code Example) | IronXL](https://ironsoftware.com/excel/csharp/examples/excel-sql-datatable/): This code example can save you time. Convert Excel to SQL in C# in less than 7 minutes. - [C# Excel Styling Guide with IronXL | IronXL](https://ironsoftware.com/excel/csharp/examples/excel-style-cells-borders-fonts/): Customize the appearance of Excel worksheets using IronXL, including cell colors, borders, and fonts in your C# projects. - [Update Excel Database Records in C#, Code Examples | IronXL ](https://ironsoftware.com/excel/csharp/examples/excel-update-database-records/): Learn how to update database records using Excel and IronXL in C#. Follow this guide to synchronize your data efficiently. - [Code Example: Excel Spreadsheet Export | IronXL](https://ironsoftware.com/excel/csharp/examples/export-excel-spreadsheet/): Quickly export Excel data to various formats using IronXL in your .NET applications for easy sharing and analysis. - [Freeze Panes in Excel in C#, Code Examples | IronXL ](https://ironsoftware.com/excel/csharp/examples/freeze-panes-in-excel/): Learn how to freeze panes in Excel using IronXL in C#. Follow this guide to lock rows and columns for better data navigation. - [Excel C# Group & Ungroup Row & Column (No Interop) | IronXL](https://ironsoftware.com/excel/csharp/examples/group-and-ungroup-rows-and-columns/): Using IronXL C# library to apply grouping and ungrouping to rows and columns in Excel worksheet. - [C# Excel Insert New Rows & Columns (No Interop) | IronXL](https://ironsoftware.com/excel/csharp/examples/insert-new-rows-and-columns/): Using IronXL C# library to insert or add branch new rows and columns to worksheet. - [Load Excel From SQL Database in C#, Code Examples | IronXL ](https://ironsoftware.com/excel/csharp/examples/load-excel-from-sql-database/): Load Excel data directly from SQL databases using IronXL in C#. Follow this tutorial to import and manage your database data in Excel. - [Protect Excel Files in C# .NET | IronXL ](https://ironsoftware.com/excel/csharp/examples/protect-excel-file/): Learn how to protect Excel files using IronXL in C#. Follow this guide to apply security measures and safeguard your data. - [Reading Excel in C#, Code Examples | IronXL ](https://ironsoftware.com/excel/csharp/examples/read-excel/): Learn how to read Excel files using IronXL in C#. Follow this guide to extract and process data from Excel spreadsheets. - [Code Examples: Print Titles in Excel | IronXL ](https://ironsoftware.com/excel/csharp/examples/repeating-rows-and-columns-in-excel/): Learn to repeat specific rows or columns on every printed page of an Excel file using IronXL for streamlined reporting. - [Select Excel Range in C#, Code Examples | IronXL ](https://ironsoftware.com/excel/csharp/examples/select-excel-range/): Tutorial on selecting Excel ranges programmatically using IronXL. - [Code Example: Sorting Data in Excel using C# | IronXL](https://ironsoftware.com/excel/csharp/examples/sort-excel-range-csharp/): Learn how to organize Excel data by sorting specific ranges using IronXL in your .NET applications for improved readability. ## Product Features - [IronXL Excel Features in C# | IronXL](https://ironsoftware.com/excel/csharp/features/): Dive into IronXL’s capabilities for reading, writing, and editing Excel files in C# - including formulas, charts, and more. ## Licensing - [.NET Excel Library Licensing Terms | IronXL](https://ironsoftware.com/excel/csharp/licensing/): Understand the licensing options for IronXL. Learn about different licenses, pricing, and how to choose the right one for your needs. ## Blog ### Using IronXL - [Read Excel File Using Microsoft Office Interop Excel C#: And a Faster Way to Create Excel Files Without Office](https://ironsoftware.com/excel/csharp/blog/using-ironxl/excel-microsoft/): Read Excel files using Microsoft Office Interop Excel in C#, then switch to IronXL for server-safe, cross-platform Excel file creation without Office dependencies. - [Download Excel File in ASP .NET C#: Export Data to XLSX, CSV & More](https://ironsoftware.com/excel/csharp/blog/using-ironxl/download-excel-file/): Download Excel file in ASP.NET Core using C# and IronXL. Export data to XLSX, CSV, and XML from MVC controllers with MemoryStream and File() return. Code examples included. - [How to Create Pivot Tables in Excel with C# Without Interop](https://ironsoftware.com/excel/csharp/blog/using-ironxl/create-pivot-table-in-excel-using-csharp-interop/): Learn to create pivot tables in Excel using C# without Office dependencies. This guide covers both Excel Interop and IronXL with complete code examples. - [How to Export Excel Files in Blazor Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/blazor-export-excel-blog/): Learn how to export data to Excel in Blazor Server applications using IronXL. This guide covers project setup, service design, conditional formatting, multi-sheet reports, and error handling with complete C# code examples. - [How to Read Excel Files in C# Instead of Using StreamReader](https://ironsoftware.com/excel/csharp/blog/using-ironxl/read-excel-streamreader-blog/): Learn why StreamReader cannot read Excel files and how to use IronXL to load XLSX and XLS workbooks from disk or memory streams in C# .NET. - [How to Generate Excel Files in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/generate-excel-csharp-blog/): Learn how to generate Excel files in C# using IronXL, covering basic spreadsheet creation, formatting, formulas, and database integration without Office dependencies. - [Export DataTable to Excel C# Using OleDb vs IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-datatble-using-oledb/): Learn how to Export DataTable to Excel C# Using OleDb vs IronXL. - [Export Excel DataTable in C# | Convert Excel Data](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-excel-datatable/): Export Excel to DataTable in C# using IronXL. Convert worksheets, specific ranges, and workbooks to DataTable and DataSet objects without Microsoft Office. - [How to Read Open Office Excel Files in C# Without Excel Installed](https://ironsoftware.com/excel/csharp/blog/using-ironxl/read-open-office-excel/): Learn how to read Open Office Excel files in C# without Excel installed. Load XLS, XLSX, CSV files using IronXL library. Code examples for .NET developers. - [How to Import Excel to GridView in ASP.NET C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/import-excel-gridview/): Import Excel to GridView in ASP.NET C# using IronXL. Load XLS and XLSX files, convert to DataTable, and display data in GridView controls with simple code. - [Import CSV in C# | ASP.NET Core Tutorial | IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/import-csv/): Learn to import CSV files in ASP.NET Core using C#. Step-by-step tutorial covers file uploads, data parsing, model mapping, and database integration with IronXL. - [Importing an Excel File into DataTable with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/import-excel-datatable/): C# Import Excel File into DataTable with IronXL - [Release Excel Object C# | Stop Lingering Excel Processes with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/release-excel-object-csharp/): Release Excel objects in C# without COM headaches. This guide explains Interop cleanup challenges and shows how IronXL simplifies Excel file operations. - [How to Export to Excel from GridView in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-to-excel-from-gridview/): Export to Excel from GridView in ASP.NET C# using IronXL. Create genuine XLSX files without HtmlTextWriter errors. Code examples included. - [How to Open an Existing Excel File in VB.NET Without Office Installed Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/open-exsisting-excel-vb/): Learn how to open an existing Excel File in VB.NET without Office installed using IronXL. - [How to Close Excel Process in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-close-excel-process/): Learn how to close Excel process in C# using IronXL. - [VB.NET Excel Freeze Top Row: Keep Headers Visible While Scrolling](https://ironsoftware.com/excel/csharp/blog/using-ironxl/vb-net-excel-freeze-top-row/): Keep Excel headers visible while scrolling in VB.NET. Step-by-step guide to freezing rows and columns programmatically with IronXL's CreateFreezePane method. - [Build an Excel API for .NET Core: Create, Read, and Export XLSX Files](https://ironsoftware.com/excel/csharp/blog/using-ironxl/excel-api-net-core/): Learn to build an Excel API for .NET Core using IronXL. Create, read, and export XLSX files programmatically without Microsoft Office installation. - [C# CSV to XLSX: Convert CSV Files to Excel Format](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csv-to-xlsx/): Convert CSV to XLSX in C# using IronXL. Load CSV files, preserve data types, add charts, and export to Excel format without Microsoft Office dependencies. - [C# CSV Library: Complete Tutorial Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-csv-library/): Learn to use IronXL as your C# CSV library. Read, write, and convert between CSV & Excel formats with simple code examples. - [How to Convert a DataSet to Excel in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/convert-dataset-to-excel-vb-net/): Learn how to efficiently convert datasets to Excel in VB.NET using IronXL with this clear, step-by-step guide. - [How to Read a CSV File into a DataTable in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-read-csv-file-into-datatable/): Learn how to efficiently read CSV files into DataTable in C# using IronXL. Simple code examples for CSV parsing and database import included. - [How to Open an Excel File in C# Without Microsoft Office](https://ironsoftware.com/excel/csharp/blog/using-ironxl/vb-net-open-excel/): Learn to open and read Excel files in VB.NET without Microsoft Office. Simple IronXL tutorial with working code examples for XLSX/XLS processing. - [C# CSV File Reader: Parse and Process CSV Data with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-csv-file-reader-blog/): Master CSV file reading in C# with IronXL. Complete guide with code examples for parsing, converting, and processing CSV data in .NET applications. - [Streamline Data Processing with a C# CSV Parser (Guide)](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-csv-parser/): Discover how to streamline data processing with an efficient C# CSV parser, IronXL. - [How to Open Excel Files in C# with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-open-excel-tutorial/): Open Excel files in C# without Microsoft Office. IronXL provides a modern alternative to Interop with better performance and no Excel dependencies. - [Export DataGridView to Excel in C# with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-gridview-to-excel-vb-net/): Discover a practical VB.NET example for exporting GridView data to Excel, simplifying your data management tasks using IronXL. - [How to Write CSV Files in .NET with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/net-csv-writer-tutorial/): Learn to create a powerful .NET CSV writer with IronXL. Export Excel workbooks, preserve data types, and handle complex spreadsheet scenarios easily. - [How to Create Pivot Tables in Excel with C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/create-pivot-excel-blog/): Build Excel pivot tables in C# without Office dependencies. IronXL offers powerful data manipulation for creating pivot-style reports without Excel Interop complications. - [How to Export GridView to Excel XLSX in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-gridview-to-excle-xlsx/): Learn how to Export GridView to Excel XLSX in C# Using IronXL. - [How to Export GridView to Excel with Formatting in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-gridview-formatting/): Learn how to export GridView to Excel with formatting in C# Using IronXL. - [Export DataSet to Excel in C# Using IronXL | No Office Required](https://ironsoftware.com/excel/csharp/blog/using-ironxl/dataset-excel-vb/): Export DataTables and Datasets to Excel files in VB.NET without Microsoft Office. Step-by-step tutorial with working code examples using IronXL library. - [How to Export DataTable to Excel in C# Using Interop vs IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-excel-interop/): Learn how to Export DataTable to Excel C# Using Interop vs IronXL. - [C# CSV Reader and Writer: Create, Export, and Convert CSV Files with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-csv-reader/): Learn how to create CSV file in C# using IronXL. - [How to Read CSV Files in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/read-csv-net/): Learn how to read CSV files in C# using IronXL. - [C# DataGridView Export to Excel: Complete Guide with Formatting | IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/datgridview-excel/): Learn how to export DataGridView data to Excel files in C# with formatting. Complete tutorial covering Windows Forms, header styling, and alternating rows using IronXL. - [Export SQL Data to Excel in C# with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-sql-data/): Export SQL data to Excel using C# with IronXL. Learn to connect to SQL Server, retrieve DataTable records, and create Excel files with code examples. - [Best Way to Read Excel Files in C# | IronXL Step-by-Step Guide](https://ironsoftware.com/excel/csharp/blog/using-ironxl/best-way-read-excel-csharp/): Discover how to read Excel files in C# with IronXL—no Microsoft Office required. Simple API for XLSX, XLS, CSV parsing with practical code examples. - [How to Create Excel Spreadsheets in C# .NET Core Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/net-core-spreadsheet/): Learn how to create Excel Worksheets in C# Using IronXL. - [How to Read Excel Files in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/vb-net-read-excel/): Learn how to read Excel files in VB.NET using IronXL without Microsoft Office. - [How to Export DataGridView to Excel in C# with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-datagridview-vb-net-2010/): Learn how to export data from DataGridView to Excel in VB.NET using IronXL. - [How Do You Read CSV Files Fast in C# with IronXL?](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-csv-fast-reader/): Learn how to process CSV files using IronXL. - [C# Export DataGridView to Excel with Column Headers](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-export-datagridview-to-excel-with-column-header/): Learn how to export DataGridView data to Excel while preserving column headers. Step-by-step C# tutorial using IronXL library. - [ExcelDataReader Write Excel Files: Why It Can't and How IronXL Solves This](https://ironsoftware.com/excel/csharp/blog/using-ironxl/exceldatareader-write-excel/): Discover why ExcelDataReader can't write Excel files and how IronXL provides complete Excel reading and writing capabilities in C#. - [How to Export an HTML Table to Excel in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-export-html-table-to-excel/): Learn to convert HTML tables to Excel spreadsheets in C# using IronXL's flexible approach. No Office required, works cross-platform. - [C# Export List Object to Excel](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-export-list-object-to-excel/): Learn to export any C# list to Excel using IronXL's ImportData method. No Office Interop required. Simple code examples for generic lists and complex objects. - [How to Use the .NET Core CSV Reader with IronXL: Practical Examples](https://ironsoftware.com/excel/csharp/blog/using-ironxl/dotnet-core-csv-reader/): Learn to effectively use IronXL as the .NET Core CSV reader with practical examples. - [How to Export Data to an Existing Excel Template in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-export-excel-template-already-existing/): Discover how to efficiently export C# data to an existing Excel template to enhance your workflow using IronXL. - [How to Read CSV Files with Commas in Data Using C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-read-csv-with-comma-in-data/): Master parsing CSV files with embedded commas in C# using IronXL. Handle quoted fields and special characters effortlessly with our complete tutorial. - [Blazor Export to Excel: Complete Guide Using IronXL in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/blazor-export-excel/): Blazor export Excel files using IronXL. Learn to create, format, and download XLSX files in Blazor Server apps without Microsoft Office. Code examples included. - [How to Create Pivot Tables in Excel Using C# Without Office Dependencies?](https://ironsoftware.com/excel/csharp/blog/using-ironxl/create-pivot-excel/): Build Excel pivot tables in C# without Office dependencies. IronXL offers powerful data manipulation for creating pivot-style reports without Excel Interop complications. - [Alternative to Read Excel File Using StreamReader in C# - IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/read-excel-streamreader/): Learn how to read Excel files using StreamReader and IronXL in C# with this step-by-step guide. - [How to Generate Excel File in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/generate-excel-csharp/): Learn how to generate Excel files in C# using IronXL with this step-by-step guide. - [How to Save Data to CSV Format in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-save-to-csv/): Learn how to efficiently save and manage CSV files in C# using IronXL. - [How to Read a CSV File in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-csv-file-reader/): Master CSV file reading in C# with IronXL. Complete guide with code examples for parsing, converting, and processing CSV data in .NET applications. - [How to Write CSV Files in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-write-to-csv/): Master CSV file creation in C# with IronXL. Convert Excel to CSV, export DataTables, handle special characters. Quick setup, powerful results. - [How to Import Excel Data in C# Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-import-excel/): Learn how to import Excel data in C# using IronXL. - [How to Create an Excel Pivot Table in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/create-pivot-table-excel-csharp-interop-vs-ironxl/): Learn to create a pivot table in Excel using C# Interop and IronXL with this clear step-by-step guide. - [How to Export Template in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-data-excel-template-csharp/): Discover how to efficiently export C# data to an existing Excel template to enhance your workflow using IronXL. - [Why `ExcelDataReader` Can't Write Excel Files and How IronXL Solves This](https://ironsoftware.com/excel/csharp/blog/using-ironxl/exceldatareader-write-excel-ironxl/): Discover why ExcelDataReader can't write Excel files and how IronXL provides complete Excel reading and writing capabilities in C#. - [How to Export HTML Table to Excel in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/convert-html-table-to-excel-csharp/): Learn to convert HTML tables to Excel spreadsheets in C# using IronXL's flexible approach. No Office required, works cross-platform. - [How to Export a `DataGridView` to Excel with Column Headers in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-export-datagridview-to-excel-with-headers/): Learn how to export DataGridView data to Excel while preserving column headers. Step-by-step C# tutorial using IronXL library. - [How to Use a .NET Core CSV Reader with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/net-core-csv-reader/): Learn to effectively use IronXL as the .NET Core CSV reader with practical examples. - [How to Import, Read, and Manipulate Excel Data in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-import-excel-guide/): Learn how to import Excel data in C# using IronXL. - [How to Read an Excel File with `StreamReader` in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/read-excel-file-streamreader-csharp/): Learn how to read Excel files using StreamReader and IronXL in C# with this step-by-step guide. - [Generate Excel Files in C# Without Office Interop](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-generate-excel-tutoral/): Learn how to generate Excel files in C# using IronXL with this step-by-step guide. - [How to Create Excel Reports in C# with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/create-excel-report/): Create Excel report generation in C# using IronXL. Learn to build professional reports with formatting, formulas, and database integration. - [How to Create Excel Files in C#: Interop vs IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-excel-interop-alternatives/): Discover the best alternatives to Excel Interop for creating spreadsheets in C#. Compare features, licensing, and code examples of top Excel libraries. - [How to Export to Excel in a Blazor Using IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/blazor-export-to-excel/): Blazor export Excel files using IronXL. Learn to create, format, and download XLSX files in Blazor Server apps without Microsoft Office. Code examples included. - [How to Read CSV Files with Commas in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-read-csv-with-commas/): Master parsing CSV files with embedded commas in C# using IronXL. Handle quoted fields and special characters effortlessly with our complete tutorial. - [How to Create an Excel Pivot Table in C#?](https://ironsoftware.com/excel/csharp/blog/using-ironxl/create-excel-pivot-table-csharp/): Build Excel pivot tables in C# without Office dependencies. IronXL offers powerful data manipulation for creating pivot-style reports without Excel Interop complications. - [How to Save Data to CSV in C# with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-save-to-csv-tutorial/): Learn how to efficiently save and manage CSV files in C# using IronXL. - [How to Export a List of Objects to Excel in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-export-list-to-excel-tutorial/): Learn to export any C# list to Excel using IronXL's ImportData method. No Office Interop required. Simple code examples for generic lists and complex objects. - [How to Manage Excel Ranges in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-excel-range-tutorial/): In this tutorial, we will focus on working with Excel ranges using IronXL. We'll cover how to write, read, and manipulate ranges within an Excel file. - [How to Work with Excel Files in C#: Figure 1 - Tutorial](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-working-with-excel-tutorial/): Working with Microsoft Excel files in programming languages has become a significant requirement in today's modern programming paradigm - [How to Import Excel to SQL Server in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/import-excel-to-sql-server-in-csharp/): In many different business contexts, importing data from Excel into SQL Server is a typical necessity. Reading data from an Excel file and entering it into a SQL Server database are the tasks involved in this activity - [How to Autofit Cells in Excel Using C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-autofit-cells-excel-using-csharp/): In this article, we will learn how to autofit column width and height in Excel using C# and IronXL. - [How to parse an Excel file in Python](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-prase-excel-file-python/): We will examine how to parse an Excel file in Python using IronXL in this in-depth tutorial. - [How to Create a new Excel Workbook in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-create-excel-new-workbook/): We'll walk through the necessary steps, from setting up your development environment to writing the code that generates a new Excel workbook. - [How to Use C# Excel Font Style](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-excel-font-style/): However, this option isn't as flexible or convenient as alternative _solutions._ Hence, this post will discuss using IronXL, on how to use C# Excel to set font style. - [How to Rename Excel WorkSheet in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-rename-excel-worksheet/): In this article, we'll explore how to rename Excel files using IronXL library from IronSoftware. - [How to Read an Excel File in a C# Console Application](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-read-excel-file-csharp-console-application/): This article will guide you through the process of reading Excel files in a C# Console Application using the IronXL library - [How to Export Datagridview To Excel in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-datagridview-to-excel-csharp/): This tutorial provides a comprehensive guide on how to export data from a DataGridView control in a Windows Forms Application to an Excel file using the IronXL library in C# - [How to Read Data From CSV File And Store It In Database C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/read-data-from-csv-file-and-store-it-in-database/): This tutorial covers the steps to read data from a CSV file and store it in an SQL Server Database using C#, specifically utilizing the IronXL library - [How to Convert An Excel File to XML in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-convert-excel-to-xml-in-csharp/): It is an essential tool for organizing, evaluating, and using data to inform choices. In the article, we are going to learn how to convert Excel to XML in C#. - [How to Import an Excel File to SQL Database in VB .NET](https://ironsoftware.com/excel/csharp/blog/using-ironxl/vb-net-import-excel-to-sql-database/): In this article, we are going to see how VB .NET imports Excel files into the SQL Server database table without using the provider Microsoft.ace.oledb 12.0 data. - [How to Convert CSV File Into List in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-read-csv-file-into-list-tutorial/): In this tutorial for beginners, we are going to see how to read CSV files into a list in C# using the IronXL - [How to Save An Excel File in VB .NET](https://ironsoftware.com/excel/csharp/blog/using-ironxl/vb-net-save-excel-file-tutorial/): In this article, we're going to look at how you can use VB.NET to save Excel files with the help of IronXL. - [C# Excel Automation (Developer Tutorial)](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-excel-automation-tutorial/): In this article, we are going to see more about Excel automation in C# - [Work with Excel Files Without Microsoft Office in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-excel-library-without-office/): This makes it a go-to solution for server environments where installing Microsoft Office is not feasible due to licensing or server performance constraints. - [How to Convert Excel to Datatable in C# Without oledb](https://ironsoftware.com/excel/csharp/blog/using-ironxl/convert-excel-to-datatable-in-csharp-without-oledb/): In this article, we are going to convert Excel to datatable in C# without OLEDB connectivity. - [How to Concatenate or Merge Excel Files in C# Combine XLS](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-concatenate-or-merge-excel-files-in-csharp-combine-xls/): IronXL is a powerful Excel library that can be used to perform various types of Excel operations. In this article, we are going learn how to concatenate or merge Excel files in C# combine xls. - [How to Load An Excel File in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-load-excel-file-tutorial/): This article will demonstrate how to load Excel files using IronXL, a first-class Excel C# library, efficiently and programmatically. - [How to Export to CSV in .NET Core](https://ironsoftware.com/excel/csharp/blog/using-ironxl/net-core-export-to-csv-tutorial/): This article outlines the process of utilizing a .NET Core application to establish a framework for efficiently managing Excel spreadsheets, including reading and exporting to CSV format. - [How to Write A CSV File in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-write-csv-tutorial/): In this article, we will see how to write CSV files using a C# library named IronXL in a new project. - [How to Export to Excel With Formatting in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-export-to-excel-with-formatting-tutorial/): In this article, we'll discuss methods for exporting data from a CSV file to visually engaging Excel spreadsheets with cell stylings using IronXL. - [How to Export File to CSV in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-export-to-csv-tutorial/): IronXL, a first-class C# library that offers a wide range of features to read and export Excel spreadsheets to CSV files. - [How to Edit a Spreadsheet in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-spreadsheet/): This article explores spreadsheet manipulation in C# using IronXL, an advanced data manipulation library, without relying on user interface interactions. - [.NET Excel Library (Developer Tutorial)](https://ironsoftware.com/excel/csharp/blog/using-ironxl/net-excel-library-tutorial/): The C# IronXL library, a .NET Excel tool, allows users to read and convert Microsoft Excel documents to CSV files efficiently and programmatically. - [How to Open Excel File in ASP .NET Core](https://ironsoftware.com/excel/csharp/blog/using-ironxl/asp-net-core-open-excel-file-tutorial/): In this tutorial, we will learn how to open an Excel file in an ASP.NET Core application using the IronXL library. - [How to Merge Cells in Excel Without Losing Data](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-merge-cells-in-excel-without-losing-data/): IronXL enables merging multiple columns/cells in Excel programmatically, offering an efficient method for developers. - [How to Convert XLS to XLSX File in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-convert-xls-to-xlsx-file-tutorial/): Here in this article, we are going to explore the IronXL library to convert XLS to XLSX format in the C# console application. - [How to View Excel in ASP.NET](https://ironsoftware.com/excel/csharp/blog/using-ironxl/asp-net-excel-viewer-tutorial/): In this tutorial, we'll create an Excel viewer with ASP.NET MVC and IronXL, allowing users to display, edit, and navigate Excel files on their webpage. - [How To Write Data in CSV File in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-write-data-in-csv-file-in-csharp-tutorial/): Let's explore how IronXL allows you to save or export data from Excel files to various formats such as CSV or DataTable programmatically. - [How To Set Background Color in Excel Cell Using C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-set-background-color-in-excel-cell-using-csharp/): In C#, Excel is commonly used for spreadsheets and provides numerous formatting options, such as setting cell background colors. IronXL offers the simplest way to style cells. - [How To Disable Protected View in Excel Using C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-disable-protected-view-in-excel-using-csharp/): In this article we will see how you can easily disable the excel protected view message using Advance C# Excel Library IronXL. - [How to Open Excel File and Write Data in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/open-excel-file-write-data-csharp-tutorial/): This article explores using the IronXL library to read and write data to an Excel file in a C# console application with utmost efficiency. - [How to Export Huge Data From Datatable to Excel in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-export-huge-data-from-datatable-to-excel-csharp/): With a simple line of code, IronXL provides an effective approach in C# for exporting a large amount of data from a DataTable to an Excel sheet. - [How to Convert Excel to Datagridview in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/excel-to-datagridview-csharp-tutorial/): IronXL is a powerful C# library that enables Excel file reading with minimal code. Exporting data to a DataGridView demonstrates its efficiency in working with various Excel formats. - [How to Export to CSV in Blazor](https://ironsoftware.com/excel/csharp/blog/using-ironxl/blazor-export-to-csv-tutorial/): By the end of this tutorial, you'll be able to create a basic Blazor application that exports Excel data in various formats, including CSV. - [How to Convert Excel to Datatable in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/excel-to-datatable-csharp-tutorial/): This Excel to DataTable conversion can be done easily using IronXL, which provides an efficient method to handle Excel files in C#. - [How to Export File to Excel in .NET 6](https://ironsoftware.com/excel/csharp/blog/using-ironxl/net6-export-to-excel-tutorial/): Exporting data to Excel format can be easily done using IronXL. We can export data into various file types, such as XLS, XLSX, CSV, JSON, and XML, using IronXL. - [How to Export Datatable to Excel in ASP.NET Core](https://ironsoftware.com/excel/csharp/blog/using-ironxl/asp-net-export-datatable-to-excel/): In this article, we will explore the different ways to export DataTable to Excel file and the benefits of doing so. - [Read Excel Data and Insert into Database with C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-read-excel-data-and-insert-to-database-table-in-csharp/): IronXL provides excellent Excel support, ensuring a smooth process when it comes to extracting data from Excel sheets and inserting it into database tables. - [How to Convert Dataset to Excel in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-dataset-to-excel-tutorial/): In this article, we will explore how to use C# to export data from a dataset to an Excel spreadsheet using a market-leading C# Excel library - [How to Read CSV File in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-csvreader-tutorial/): In this article, we will explore how to create a C# CSV Reader using the IronXL library and utilize its powerful capabilities to interact with various Excel formats. - [How to Get Cell Value From Excel File in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-excel-get-cell-value-tutorial/): Understanding how to retrieve cell values in C# can help you manipulate and analyze data in Excel more efficiently and effectively. - [How to Export `DataTable` to CSV in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-export-csv-tutorial/): With IronXL, we can export and save files with a wide range of suffixes, including XLS, CSV, TSV, JSON, and others in a few lines of code. - [How to Import Excel File in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-import-excel-file-tutorial/): IronXL allows developers to import and read Excel files in C# without needing Excel installed. - [How to Convert Dataset to CSV in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/convert-dataset-to-csv-tutorial/): In the following article, we will learn about converting a C# dataset into a CSV file using IronXL at our convenience to enhance productivity. - [How to Write to an Excel File in VB.NET (The Easy Way)](https://ironsoftware.com/excel/csharp/blog/using-ironxl/vb-net-write-to-excel/): A comprehensive guide on how to programmatically create and write data to Excel files (XLSX, XLS, CSV) in VB.NET. Features code examples for common tasks. - [How to Freeze a Row in Excel (Beginner Guide)](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-freeze-row-in-excel-tutorial/): IronXL offer features like freeze panes to view content from different workbook areas simultaneously, enhancing productivity. - [How to Export CSV and Excel in Razor](https://ironsoftware.com/excel/csharp/blog/using-ironxl/razor-export-csv-excel-tutorial/): Web development that interacts with Excel and CSV files is simplified by Razor and IronXL for productivity. - [How to Unhide All Rows in Excel](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-unhide-all-rows-in-excel/): This article covers how to unhide all rows and columns in Excel and IronXL for improved data access and productivity. - [How to Export to Excel in ASP.NET Core](https://ironsoftware.com/excel/csharp/blog/using-ironxl/asp-net-core-export-excel-tutorial/): In this tutorial, we'll delve into the process of exporting data from an Excel file into JSON, CSV, or XML formats using ASP.NET Core. - [How to Export Datatable to Excel in VB.NET](https://ironsoftware.com/excel/csharp/blog/using-ironxl/export-datatable-to-excel-vb-net/): The IronXL library enables manipulation of Excel files in VB.NET, including exporting DataTables into different file formats with just a few lines of code. - [C# Fastest way to Export DataTable to Excel](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-fastest-way-export-datatable-to-excel/): IronXL from Iron Software is a C# .NET library, which helps create Excel files with ease. Multiple sheets can be added to the newly created Excel workbook. - [How to Read Excel File in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-excel-reader-tutorial/): IronXL is a C# Excel data reader library that allows developers to read, write, and manipulate Excel files without the need for Microsoft Excel on the machine. - [How to Open Excel Files in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-open-excel-file-tutorial/): This tutorial examines how IronXL can open, read, and edit Excel documents in C# projects, a vital part of modern business applications. - [How to Convert Table to Range in Excel](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-convert-table-to-range-excel/): This guide explains the process of transforming Excel data into a formatted table. IronXL is included to enhance interaction with tables, rows, columns, and cells. - [How to Fetch Data From Excel Sheet in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-fetch-data-from-excel-sheet-csharp/): This tutorial explores how to fetch data from Excel sheets and put it into DataTables in C# using IronXL. - [How to Create CSV File in C# (Step-By-Step) Tutorial](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-create-csv-file-tutorial/): The IronXL library assists in creating CSV files from data using the C#.NET class library in console applications in the most efficient manner. - [C# CSV Parser (Step-By-Step) Tutorial](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-csv-parser-tutorial/): The IronXL library helps to parse CSV files and convert them to XLSX or XLS files programmatically and efficiently with two lines of code. - [How to Generate an Excel File on Razor Pages](https://ironsoftware.com/excel/csharp/blog/using-ironxl/razor-pages-generate-excel-file/): This tutorial provides a straightforward method for generating and exporting Excel files or Excel reports with dummy data and header rows in Razor Pages using IronXL. - [Read CSV File Using C# (Code Example Tutorial)](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-read-csv-file-line-by-line/): The IronXL library provides an easy way to read CSV files in C#. Converting and editing Excel files has never been easier. - [C# Open Excel File Programmatically (Code Example Tutorial)](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-open-excel-file-programmatically/): Creating XLSX files programmatically can quickly become complicated. The IronXL C# library helps to simplify this process. - [Datatable to Excel in C# (Code Example Tutorial)](https://ironsoftware.com/excel/csharp/blog/using-ironxl/datatable-to-excel-csharp/): This guide will show you how to create an Excel file and efficiently export a DataTable to an Excel sheet using IronXL. This C# library offers a programmatic and automated way to interact with Excel files. - [How to Move Rows in Excel](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-move-rows-in-excel/): There are various ways to move rows or selected cells in Excel. The IronXL C# library offers programmatic ways to interact with rows, columns, and cells. - [How to Highlight Every Other Row in Excel](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-highlight-every-other-row-in-excel/): We often highlight Excel rows to emphasize important data. IronXL can automate this process, enhancing productivity. - [Reading CSV Files in C#: a Tutorial](https://ironsoftware.com/excel/csharp/blog/using-ironxl/reading-csv-files-in-cshap-tutorial/): The IronXL C# library offers first-class support for interacting with CSV files. This includes reading, writing, and complex parsing for each data type, thereby optimizing productivity. - [How to Lock Cells in Excel: a Step by Step Tutorial](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-lock-cell-in-excel/): Securing cells in Excel effectively locks editing and customization, ensuring confidentiality. Implementing the IronXL C# library enables a quick process and delivers a secure Excel file. - [How to Merge Cells in Excel: Step by Step Tutorial](https://ironsoftware.com/excel/csharp/blog/using-ironxl/how-to-merge-cells-in-excel/): Learning how to merge cells in Microsoft Excel and automate those common tasks using IronXL in C# to enhance productivity. - [How to Create a CSV File Using C# with IronXL](https://ironsoftware.com/excel/csharp/blog/using-ironxl/csharp-create-csv-file/): It is extremely easy to create and output a CSV file with IronXL. Follow the link to have full control over your Excel file with C#. - [Generate Excel Files in C#](https://ironsoftware.com/excel/csharp/blog/using-ironxl/generate-excel-file-csharp/): Generate Excel File C#, including XLSX, JSON, CSV, XML and other formats for your C# project programmatically. - [Install via .NET CLI (recommended for CI/CD pipelines)](https://ironsoftware.com/excel/csharp/blog/using-ironxl/dotnet-core-excel/): .NET Core Excel overview and example projects. The code samples demonstrate how to work with Excel programmatically. ### Compare to Other Components - [VB.NET Read Excel File Into Array: IronXL vs Microsoft Interop](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/vb-net-read-excel-array/): Complete guide to reading Excel files into arrays in VB.NET. Compare IronXL and Microsoft Interop approaches with working code examples and best practices. - [ASP.NET Export to Excel: IronXL vs ClosedXML vs EPPlus Compared](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/asp-net-export-to-excel/): Discover the best Excel export libraries for ASP.NET Core. Compare IronXL, ClosedXML, and EPPlus features, licensing, and code examples for C# developers. - [Create Excel Files in C# using Interop Comparison: IronXL and Alternative Libraries](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/create-excel-interop/): Discover the best alternatives to Excel Interop for creating spreadsheets in C#. Compare features, licensing, and code examples of top Excel libraries. - [Comparing Three Open Source C# Excel Libraries](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/csharp-excel-library-open-source/): This article will explore three C# Open Source Excel libraries designed to simplify Excel file manipulation in a .NET environment - [A Comparison between IronXL and GemBox.Spreadsheet](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/gembox-spreadsheet-excel-library-alternatives/): IronXL and GemBox.Spreadsheet both provide the methods to create, edit, and read Excel documents in the .NET framework. - [Zip Archive Tutorial for C# Developers Using IronXL](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/zip-archive-csharp-tutorial/): In this tutorial, we'll explore how to create ZIP files, extract data from compressed files, and manipulate ZIP archives in C# using relative path. - [EPPlus Read Excel to Datatable C# (IronXL Tutorial)](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/epplus-read-excel-to-datatable-csharp/): EPPlus is a powerful open-source library for creating and manipulating Excel files in C#. It provides a simple and intuitive API that allows developers to generate, read, and modify Excel spreadsheets programmatically, - [A Comparison Between IronXL and FastExcel for .NET](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/fastexcel-net-alternatives/): In this article, we will compare IronXL and FastExcel v4, highlighting the strengths and weaknesses of each library, and providing examples of how to use both in C#. - [A Comparison of IronXL and ClosedXML](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/closedxml-read-excel-csharp-alternatives/): IronXL and ClosedXML both provide methods to create, edit, and read Excel documents in the .NET framework. - [A Comparison between IronXL and GrapeCity Excel Viewer](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/grapecity-excel--viewer-alternatives/): GrapeCity's embedded bi platform offers limitless high-speed visual data exploration, allowing the everyday user to become data-driven to easily report solutions. - [A Comparison between IronXL and Syncfusion Excel](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/syncfusion-excel-alternatives/): The Syncfusion library provides an API for reading, writing, and manipulating Microsoft Excel (XLS) files. - [A Comparison between IronXL and Spire XLS](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/spire-xls-alternative-csharp-excel-library/): Spire.XLS for .NET is an object model Excel API that allows you to generate new Excel documents from templates, edit existing Excel documents, and convert Excel files in the .NET platform.. - [A Comparison between IronXL and CsvWriter](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/csvwriter-alternatives/): A .NET library for writing CSV files. Extremely fast, flexible, and easy to use. Supports writing of custom class objects. - [A Comparison between IronXL and CsvHelper](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/csvhelper-alternatives/): A .NET library for reading and writing CSV files. Extremely fast, flexible, and easy to use. Supports reading and writing of custom class objects. - [A Comparison of IronXL and NPOI](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/npoi-alternative-by-ironxl/): NPOI is the .NET version of the POI Java project at http://poi.apache.org/. POI is an open-source project that can help you read/write xls, doc, ppt files. It has a wide range of applications. - [A Comparison of IronXL and Aspose Cells](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/aspose-cells-alternative-by-ironxl/): Aspose.Cells for .NET is a spreadsheet programming library that allows software developers to manipulate and convert spreadsheet files from within their own applications - [A Comparison between IronXL and Epplus](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/epplus-read-create-excel-alternative/): EPPLus has an API that allows you to work with Office Excel documents. EPPlus is a.NET library that reads and writes Office OpenXML-formatted Excel files. This library is available as a package from NuGet. - [A Comparison between IronXL and Microsoft Office Interop Excel](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/microsoft-office-excel-interop-alternative/): IronXL and Microsoft Excel Interop both provide the methods to create, edit, and read excel documents in .NET Framework. The next question is to decide which C# Excel library is best suited for your project. - [A Comparison between IronXL and Aspose Cells](https://ironsoftware.com/excel/csharp/blog/compare-to-other-components/aspose-cells-read-excel-file-alternative/): IronXL and Aspose Cells both provide the methods to create, edit, and read excel documents in .NET Framework. The next question is to decide which C# Excel library is best suited for your project. ### Excel Tools - [How to Insert a PDF into Excel: 7 Methods That Work (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-insert-a-pdf-into-excel/): Need a contract, invoice, or report attached to a spreadsheet? Learn 7 methods to insert a PDF into Excel, from the Object command to embedding it as an icon. - [How to Calculate Percentage Increase in Excel (Complete Guide)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-calculate-percentage-increase-in-excel/): Need to compare this month against last, or budget against actual? Learn every method to calculate percentage increase in Excel with a single formula. - [How to Convert TXT to Excel: 8 Methods That Work (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-convert-txt-to-excel/): Need a text file turned into a spreadsheet fast? Learn 8 methods to convert TXT to Excel, from the built-in Text/CSV import to handling delimiters and fixed-width data. - [How to Calculate Percentage Change in Excel (Every Method)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-calculate-percentage-change-in-excel/): Need to measure growth or decline between two numbers? Learn every method to calculate percentage change in Excel, for sales, budgets, headcount, and traffic data. - [How to Group Columns in Excel: 7 Methods That Tidy Up a Wide Spreadsheet](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-group-columns-in-excel/): Spreadsheet running off the screen? Learn 7 methods to group columns in Excel, from a single keyboard shortcut to collapsing months into quarterly subtotals. - [How to Merge and Center in Excel: Every Method, Shortcut, and Fix (Complete Guide)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-merge-and-center-in-excel/): Need a title or label to span multiple columns in Excel? Learn every method to merge and center cells, plus fixes for when the button is greyed out. - [How to Remove Data Validation in Excel: 9 Methods That Work (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-remove-data-validation-in-excel/): Data validation blocking entries it shouldn't? Learn 9 methods to remove data validation in Excel, from the Clear All button to removing rules across a workbook. - [How to Add Trendline in Excel: Every Method Explained (2026 Guide)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-add-a-trendline-in-excel/): Need to visualize the direction hiding in your data? Learn every method to add a trendline in Excel, from the Chart Elements button to customizing the trendline type. - [How to Separate Text in Excel: 7 Methods That Work in Any Version (Complete Guide)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-separate-text-in-excel/): Need to split one column into several in Excel? Learn 7 methods to separate text, from Text to Columns and Flash Fill to formulas that work in any version. - [Excel: How to Change Theme to Office (Every Method, Explained)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-change-theme-to-office-in-excel/): Workbook colors and fonts looking off-brand? Learn every method to change the theme back to Office in Excel, so fonts, colors, and charts match the standard look. - [How to Indent in Excel (5 Easy Methods)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-indent-in-excel/): Need to indent cell content in Excel? Learn 5 easy methods, from the Increase Indent button on the Home tab to keyboard shortcuts and custom formatting. - [How to Remove Page Breaks in Excel (Complete Guide)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-remove-page-breaks-in-excel/): Worksheet not printing the way you expect? Learn every method to remove page breaks in Excel, from Reset All Page Breaks to clearing individual manual breaks. - [How to Print Gridlines in Excel: Every Method That Works (Complete Guide)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-print-gridlines-in-excel/): Gridlines missing from your printed spreadsheet? Learn every method to print gridlines in Excel, from the Page Layout checkbox to fixing borders that won't show. - [How to Subtract Dates in Excel (9 Methods for Days, Months, and Business Days)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-subtract-dates-in-excel/): Need to calculate days, months, or business days between two dates? Learn 9 methods to subtract dates in Excel, from simple subtraction to DATEDIF and NETWORKDAYS. - [How to Break Links in Excel: Every Method Explained (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-break-links-in-excel/): Getting the 'this workbook contains links' warning in Excel? Learn every method to break external links, from Edit Links to finding hidden references in formulas. - [How to Group Rows in Excel: Every Method, Shortcut, and Fix (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-group-rows-in-excel/): Need to collapse detail rows into summary sections? Learn every method to group rows in Excel, from the Shift+Alt+Right shortcut to the Group and Outline tools. - [How to Create Clean Dashboard in Excel: 6 Methods That Actually Work (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-create-a-clean-dashboard-in-excel/): Want a dashboard that surfaces key metrics at a glance? Learn 6 methods to build a clean Excel dashboard, from instant charts to slicers and conditional formatting. - [How to Do Regression in Excel: Every Method, Step by Step (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-do-regression-in-excel/): Need to run a regression analysis in Excel? Learn every method, from the Data Analysis ToolPak to trendline and LINEST formulas, to predict one variable from another. - [How to Print an Excel Spreadsheet (.NET10 & C#)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-print-an-excel-spreadsheet/): Excel columns cutting off when you print? Learn every method to print an Excel spreadsheet cleanly, from page orientation and scaling to setting a print area. - [How to Delete a Sheet in Excel: A Complete Guide (.NET 10, C#)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-delete-a-sheet-in-excel/): Need to remove unwanted tabs from your workbook? Learn every method to delete a sheet in Excel, from the right-click menu and keyboard shortcuts to automation. - [Excel: How to Hide Divide by Zero Error (.NET & C# Guide)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-hide-divide-by-zero-error-in-excel/): Tired of #DIV/0! cluttering your spreadsheet? Learn every method to hide divide by zero errors in Excel, from IFERROR and IF functions to conditional formatting. - [How to Remove Spaces in Excel: .NET10 Guide (Methods & Formulas)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-remove-spaces-in-excel/): Extra spaces breaking your VLOOKUP or SUMIF formulas? Learn every method to remove spaces in Excel, from Find & Replace and TRIM to fixing non-breaking spaces. - [How to Make a Calendar in Excel (.NET10 Developers Guide)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-make-a-calendar-in-excel/): Need to build a calendar in Excel? Learn every method, from built-in templates to a dynamic SEQUENCE formula, for annual and monthly calendar views. - [How to Count Cells with Text in Excel: A Step-by-Step Guide (.NET 10, C#)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-count-cells-with-text-in-excel/): Need to count cells containing text in Excel? Learn every method, from COUNTIF with wildcards to COUNTA and advanced array formulas for skipping numbers and blanks. - [How to Add Developer Tab in Excel [C# & .NET 10 Guide]](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-add-developer-tab-in-excel/): Can't find the Developer tab in Excel? Learn how to enable it on Windows and Mac, unlock VBA, form controls, and add-ins, plus fixes for common display issues. - [How to Randomize a List in Excel (.NET, C#)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-randomize-a-list-in-excel/): Need to shuffle a list or draw random samples in Excel? Learn every method to randomize a list, from the RAND helper column and SORTBY to locking your random values. - [How to Transpose Data in Excel: 5 Easy Methods to Switch Rows and Columns (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-transpose-data-in-excel/): Need to switch rows and columns in Excel? Learn 5 easy methods to transpose data, from Paste Special and the TRANSPOSE function to Power Query and dynamic arrays. - [How to Group Sheets in Excel: 4 Easy Methods for Working with Multiple Worksheets (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-group-sheets-in-excel/): Need to apply the same edits across multiple worksheets in Excel? Learn 4 easy methods to group sheets, from selecting tabs to grouping all sheets and ungrouping. - [How to Use IF Function in Excel: 5 Easy Methods for Logical Formulas and Data Decisions (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-use-if-function-in-excel/): Need to build logical formulas in Excel? Learn 5 easy methods to use the IF function, from basic syntax and nested IFs to combining it with AND, OR, and other functions. - [How to Undo in Excel: 5 Simple Methods to Reverse Mistakes](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-undo-in-excel/): Made a mistake in Excel? Learn 5 simple methods to undo actions instantly, from keyboard shortcuts and the Quick Access Toolbar to recovering previous states. - [How to Superscript in Excel: 4 Easy Methods for Formatting Text and Numbers (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-superscript-in-excel/): Need to format exponents, units, or ordinal numbers in Excel? Learn 4 easy methods to apply superscript, from the Format Cells dialog to symbols and VBA automation. - [How to Make All Cells the Same Size in Excel: 5 Easy Methods for Perfectly Aligned Spreadsheets (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-make-all-cells-the-same-size-in-excel/): Uneven rows and columns making your spreadsheet look messy? Learn 5 easy methods to make all cells the same size in Excel, from row height and column width to Select All. - [How to Insert Header in Excel: 5 Simple Methods for Organizing Spreadsheet Data (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-insert-header-in-excel/): Need to add headers to organise your spreadsheet data in Excel? Learn 5 simple methods, from manual header rows and Page Layout headers to freezing and automation. - [How to Remove Drop Down List in Excel (Every Method, 2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-remove-drop-down-list-in-excel/): Need to get rid of a drop-down list in Excel without losing your data? Learn every method to remove one, from Data Validation Clear All to bulk removal across ranges. - [How to Compare Two Columns in Excel: 7 Fast Methods for Any Spreadsheet](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-compare-two-columns-in-excel/): Need to spot differences or matches between two columns in Excel? Learn 7 fast methods, from Ctrl+\ shortcuts and conditional formatting to IF, EXACT, and VLOOKUP formulas. - [How to Sort Columns in Excel: Every Method, Step by Step](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-sort-columns-in-excel/): Need to organise data in Excel by column? Learn every method to sort columns, from one-click quick sort and custom sort dialogs to SORT formulas and multi-column sorting. - [How to Create a Scatter Plot in Excel: Made Easy](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-create-a-scatter-plot-in-excel/): Need to visualise the relationship between two numeric variables? Learn every method to create a scatter plot in Excel, from the Insert tab to keyboard shortcuts and macros. - [How to Remove Table Formatting in Excel (4 Quick Methods)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-remove-table-formatting-in-excel/): Need to strip table formatting from an Excel worksheet? Learn 4 quick methods to remove table styles, convert tables to ranges, and clear leftover colours and borders. - [How to Copy a Formula in Excel (7 Quick Methods for Every Situation)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-copy-a-formula-in-excel/): Need to copy formulas across cells, columns, or sheets in Excel? Learn 7 quick methods, from fill handle and paste special to absolute references and keyboard shortcuts. - [How to Insert Multiple Rows in Excel: 6 Methods That Actually Work](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-insert-multiple-rows-in-excel/): Tired of clicking insert one row at a time in Excel? Learn 6 practical methods to insert multiple rows at once, from keyboard shortcuts and right-click to VBA macros. - [How to Add Error Bars in Excel: Every Method, From Fastest to Most Advanced](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-add-error-bars-in-excel/): Need to show data uncertainty in your Excel charts? Learn every method to add error bars, from the Chart Elements shortcut to custom values and advanced formatting. - [How to Change Drop Down List in Excel: Every Method That Actually Works](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-change-drop-down-list-in-excel/): Need to update or edit a drop down list in Excel? Learn every method that actually works, from Data Validation to named ranges, tables, and dynamic sources. - [How to Freeze a Column in Excel: 8 Methods (Plus Troubleshooting)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-freeze-a-column-in-excel/): Need to keep columns visible while scrolling sideways in Excel? Learn 8 practical methods to freeze columns, plus troubleshooting for panes that refuse to stick. - [How to Add Bullet Points in Excel (10 Simple Methods)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-add-bullet-points-in-excel/): Need to add bullet points inside Excel cells? Learn 10 simple methods, from Alt + 7 shortcuts and symbol menus to custom formats, formulas, and multi-line lists. - [How to Hide Columns in Excel: 7 Methods Every User Should Know](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-hide-columns-in-excel/): Need to clean up your spreadsheet by hiding columns in Excel? Learn 7 reliable methods, from keyboard shortcuts to right-click menus, grouping, and macros. - [How to Alphabetize in Excel: 8 Methods That Cover Every Use Case](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-alphabetize-in-excel/): Need to sort data alphabetically in Excel? Learn 8 practical methods, from the Sort dialog and right-click menu to the SORT function, VBA macros, and shortcuts. - [How to Multiply in Excel: 8 Methods That Save Real Time](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-multiply-in-excel/): Need to multiply numbers, cells, or columns in Excel? Learn 8 practical methods, from the asterisk operator and PRODUCT function to SUMPRODUCT and Paste Special. - [How to Unprotect an Excel Sheet: 7 Methods That Actually Work (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-unprotect-an-excel-sheet/): Locked out of an Excel sheet? Learn 7 proven methods to unprotect any worksheet in seconds, with or without the password. Step-by-step, no fluff. - [How to Mail Merge from Excel to Word: A Complete Step-by-Step Guide (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-mail-merge-from-excel-to-word/): Need to create personalized letters, labels, or emails fast? Learn how to mail merge from Excel to Word step by step, with formatting tips and common fixes. - [How to Freeze a Row in Excel: Every Method Explained (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-freeze-a-row-in-excel/): Tired of column headers disappearing as you scroll? Learn every method to freeze a row in Excel, from the top row and first column to multiple rows and split panes. - [How to Find Standard Deviation in Excel: Made Easy](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-find-standard-deviation-in-excel/): Need to measure data variability in Excel? Learn 5 practical methods to find standard deviation, using STDEV.S, STDEV.P, the Insert Function dialog, and error bars. - [How to Hide Cells in Excel: 6 Methods Every User Should Know](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-hide-cells-in-excel/): Need to clean up a spreadsheet or protect sensitive data? Learn 6 reliable methods to hide cells in Excel, from right-click options and shortcuts to custom formats. - [How to Shift Columns in Excel (Step-by-Step Guide)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-shift-columns-in-excel/): Need to rearrange columns in Excel without losing data? Learn 6 practical methods to shift columns, from drag-and-drop with Shift to cut-and-insert and Power Query. - [How to Lock Rows in Excel (Step-by-Step Guide)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-lock-rows-in-excel/): Need to keep header rows visible while scrolling through large datasets? Learn every method to lock rows in Excel, from the View tab to multiple rows and columns. - [How to Merge 2 Columns in Excel: Every Method Explained (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-merge-2-columns-in-excel/): Need to combine two columns in Excel without losing data? Learn every method, from the ampersand operator and CONCAT to TEXTJOIN, Flash Fill, and Power Query. - [How to Put a Drop Down in Excel: Every Method Explained (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-put-a-drop-down-in-excel/): Want to keep data entry clean and consistent in Excel? Learn every method to put a drop down in a cell, from simple lists and named ranges to dynamic and dependent menus. - [How to Do Subtraction in Excel: Every Method Explained (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-do-subtraction-in-excel/): Need to subtract in Excel? Learn every method, from the minus sign and cell references to subtracting columns, percentages, dates, time values, and negative numbers. - [How to Use VLOOKUP in Excel: A Complete Step-by-Step Guide](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-use-vlookup-in-excel/): Need to look up data across columns in Excel? Learn VLOOKUP step by step, from basic syntax and exact matches to common errors and advanced INDEX MATCH combos. - [How to Unfreeze Panes in Excel: 4 Simple Methods for Smooth Navigation (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-unfreeze-panes-in-excel/): Need to restore full scrolling in your Excel worksheet? Learn 4 simple methods to unfreeze panes, using the ribbon, keyboard shortcuts, and troubleshooting fixes. - [How to Work Out SD on Excel: 5 Simple Methods for Accurate Data Analysis (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-work-out-sd-on-excel/): Need to calculate standard deviation in Excel for finance, research, or reporting? Learn 5 simple methods using built-in functions, formulas, and developer tools. - [How to Enter Within a Cell in Excel: 4 Simple Methods for Clean Formatting (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-enter-within-a-cell-in-excel/): Need to add line breaks inside an Excel cell without jumping to the next row? Learn 4 simple methods to enter within a cell, using shortcuts, wrap text, and formulas. - [How to Split Cells in Excel: 5 Practical Methods for Cleaner Data (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-split-cells-in-excel/): Stuck with messy data crammed into one column? Learn 5 reliable methods to split cells in Excel, using Text to Columns, formulas, Flash Fill, and Power Query. - [How to Insert Checkbox in Excel: 5 Methods for Interactive Spreadsheets (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-insert-checkbox-in-excel/): Want to turn your spreadsheet into an interactive worksheet? Learn 5 reliable methods to insert checkboxes in Excel, from the Developer tab to formulas and shortcuts. - [How to Use Excel: A Practical Beginner Guide for Real Workflows (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-use-excel/): New to Excel? Learn how to use it for real workflows, from cells and formulas to formatting, data tools, and automation basics, with practical examples throughout. - [How to Unhide Columns in Excel: A Complete Step-by-Step Guide](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-unhide-columns-in-excel/): Hidden columns blocking your view in Excel? Learn every method to unhide columns, from the right-click trick to keyboard shortcuts and recovering column A. - [How to Add Drop Down List in Excel: The Complete 2026 Professional Guide](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-add-drop-down-list-in-excel/): Need to enforce clean data entry in Excel? Learn every method to add a drop-down list, from simple comma-separated options to dynamic, dependent, and named ranges. - [How to Combine Two Columns in Excel: A Complete Step-by-Step Guide](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-combine-two-columns-in-excel/): Need to merge first and last names, addresses, or any two columns in Excel? Learn every method, from Flash Fill and Ampersand formulas to CONCAT and TEXTJOIN. - [How to Wrap Text in Excel: A Complete Step-by-Step Guide](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-wrap-text-in-excel/): Tired of long text overflowing or getting cut off in Excel cells? Learn every method to wrap text, from the one-click ribbon button to manual line breaks and shortcuts. - [How to Remove Duplicates in Excel: A Complete Step-by-Step Guide](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-remove-duplicates-in-excel/): Need to clean up duplicate entries in Excel without losing important data? Learn every method to remove duplicates, from the one-click button to advanced formula tricks. - [How to Create a Drop-Down List in Excel: The Ultimate Step-by-Step Guide](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-create-a-drop-down-list-in-excel/): Need to control data entry and prevent typos in Excel? Learn every method to create a drop-down list, from simple comma-separated lists to dynamic, dependent menus. - [How to Find Duplicates in Excel: The Ultimate Step-by-Step Guide](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-find-duplicates-in-excel/): Need to spot duplicate entries in Excel before they skew your data? Learn every method to find duplicates, from conditional formatting shortcuts to formulas and filters. - [How to Highlight Duplicates in Excel: A Complete Step-by-Step Guide](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-highlight-duplicates-in-excel/): Need to spot duplicate entries in Excel without altering your data? Learn every method to highlight duplicates, from conditional formatting shortcuts to advanced rules. - [How to Merge Cells in Excel: A Comprehensive Guide](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-merge-cells-in-excel/): Need to merge cells in Excel without breaking your sorting, filters, or formulas? Learn every method, from ribbon shortcuts to pro-level alternatives that keep data intact. - [How to Work Out Standard Deviation on Excel: A Step-by-Step Tutorial (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-work-out-standard-deviation-on-excel/): Need to calculate standard deviation in Excel? Learn the STDEV.S and STDEV.P formulas, when to use each, named ranges, error bars, and common troubleshooting tips. - [How to Unhide Rows in Excel: A Quick Tutorial (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-unhide-rows-in-excel/): Hidden rows in your spreadsheet? Learn every method to unhide rows in Excel, from the right-click trick to top-row recovery, filters, protection, and VBA. - [How to Strikethrough in Excel: Step-by-Step Tutorial (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-strikethrough-in-excel/): Need to mark items as done or flag invalid data in Excel? Learn every method to apply strikethrough, from the Ctrl + 5 shortcut to conditional formatting and VBA. - [How to Sum a Column in Excel: Everything You Need to Know (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-sum-a-column-in-excel/): Need to total a column of numbers in Excel? Learn every method, from AutoSum and keyboard shortcuts to SUM formulas, named ranges, and table totals. - [How to Add a Row in Excel: Made Easy (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-add-a-row-in-excel/): Need to insert a row in Excel? Learn every method, from the right-click shortcut to bulk insertions, table rows, keyboard shortcuts, and VBA automation. - [How to Check Duplicates in Excel: Every Method Explained (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-check-duplicates-in-excel/): Need to find or remove duplicates in Excel? Learn every method, from conditional formatting and COUNTIF to Power Query and the Remove Duplicates feature. - [How to Password Protect an Excel File: Everything You Need to Know](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-password-protect-an-excel-file/): Need to lock down a spreadsheet with sensitive data? Learn every method to password protect an Excel file, from the 15-second fix to advanced options. - [How to Remove Empty Rows in Excel: Made Easy](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-remove-empty-rows-in-excel/): Blank rows breaking your formulas, pivots, or sorting? Learn every reliable method to remove empty rows in Excel, including edge cases and bulk cleanup tricks. - [How to Move Columns in Excel: The Practical Guide](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-move-columns-in-excel/): Need to rearrange columns in Excel without overwriting your data? Learn every reliable method to move columns, from drag-and-drop to cut-and-insert and beyond. - [How to Subtract in Excel: Every Method Explained (2026)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-subtract-in-excel/): Need to subtract numbers, cells, columns, dates, or percentages in Excel? Learn every method with clear examples and formulas you can use right away. - [How to Lock a Row in Excel: Everything You Need to Know](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-lock-a-row-in-excel/): Need to keep a row visible while scrolling or protect it from edits? Learn every method to lock a row in Excel, with step-by-step instructions for both approaches. - [How to Pin a Row in Excel: 5 Methods That Actually Work](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-pin-a-row-in-excel/): Need to keep your header row visible while scrolling? Learn 5 proven methods to pin a row in Excel, from the one-click fix to VBA macros and edge cases. - [How to Enable Macros in Excel (Every Method, Step by Step)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-enable-macros-in-excel/): Macros disabled in Excel? Learn every way to enable them, from the one-click fix to Trust Center settings, with troubleshooting for every edge case. - [How to View PowerPoint Files in C#](https://ironsoftware.com/excel/csharp/blog/excel-tools/csharp-powerpoint-viewer-tutorial/): In this article, we will create C# PowerPoint Viewer without installing MS PowerPoint Viewer. - [How to Use Create PowerPoint from a Template in C#](https://ironsoftware.com/excel/csharp/blog/excel-tools/csharp-create-powerpoint-from-template/): In this post, we'll look at how to use C# to create a PowerPoint from a template - [Test Your Regex Patterns with .NET Regex Tester](https://ironsoftware.com/excel/csharp/blog/excel-tools/net-regex-tester/): This article delves into the capabilities of .NET Regex Tester, providing insights and examples into its usage and integration with IronXL - [How to Read Excel File in Java (Tutorial)](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-read-excel-file-in-java-tutorial/): Reading an Excel file can be complicated at times. Reading Excel files in Java is also a little different to reading Word files in Java because of Excel's cells. - [How to Switch Columns in Excel](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-switch-columns-in-excel/): This tutorial covers how To switch or shift multiple columns. To change adjacent columns is something most people got to do quite often. - [How to Add Up a Column in Excel](https://ironsoftware.com/excel/csharp/blog/excel-tools/how-to-add-up-column-in-excel/): This tutorial covers how To sum the total of a whole column, which are some things most people got to do quite often. ### Videos - [How to Open an Excel File in VB.NET without Interop | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-open-an-excel-file-in-vb-dotnet-without-interop-ironxl/): This video tutorial shows how to open and work with existing Excel files in VB.NET using IronXL. Load XLSX spreadsheets, read worksheet and cell data, and edit files programmatically, no Microsoft Excel or Interop needed. - [How to Merge Excel Cells Without Losing Data | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-merge-excel-cells-without-losing-data-ironxl/): This video tutorial shows how to merge cells in Excel without losing data using C# and IronXL. Combine cell ranges while preserving existing values to build clean reports, dashboards, and formatted spreadsheets from code. - [How to Read a CSV File into a DataTable in C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-read-a-csv-file-into-a-datatable-in-csharp-ironxl/): This video tutorial shows how to read a CSV file into a DataTable in C# using IronXL. Import CSV data and work with rows, columns, and structured datasets for reporting tools, data migration, and ETL workflows in .NET. - [How to Open an Excel Worksheet in C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-open-an-excel-worksheet-in-csharp-ironxl/): Discover how to open and analyze Excel worksheets in C# effortlessly with IronXL. This video tutorial walks you through the process, ensuring you can seamlessly integrate Excel capabilities into your applications, enhancing data handling and productivity. - [Tutorial How to Read Excel File in Blazor NET | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/tutorial-how-to-read-excel-file-in-blazordotnet-ironxl/): Need to work with Excel files in your Blazor applications? This tutorial demonstrates how to leverage IronXL for reading both .xls and .xlsx files, enhancing your Blazor apps' data handling capabilities. Follow our step-by-step guide to integrate this functionality seamlessly. - [How to Convert an Excel File to XML in C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-convert-an-excel-file-to-xml-in-csharp-ironxl/): Discover how to transform Excel files into XML format using C# and the IronXL library. This video tutorial provides step-by-step instructions to convert your data into a structured XML format, which is essential for effective data exchange and interoperability across different platforms. - [How to Convert a Dataset to CSV in C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-convert-a-dataset-to-csv-in-csharp-ironxl/): Discover how to convert a DataSet to CSV in C# effortlessly with IronXL. This video provides a straightforward tutorial using a fast and flexible Excel library for .NET, ensuring you can handle data export efficiently and accurately. - [How to View Excel Files in ASP .NET | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-view-excel-files-in-asp-dotnet-ironxl/): Discover how to implement an Excel viewer in your ASP.NET application using IronXL, eliminating the need for Excel installation. This tutorial provides a step-by-step guide to embedding and viewing Excel files seamlessly. - [How to Import Excel Data in a C# Console Application | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-import-excel-data-in-a-csharp-console-application-ironxl/): This video demonstrates how to read an Excel file in a C# console application using IronXL. It provides a step-by-step guide to loading spreadsheets and accessing their data without needing Microsoft Office installed. - [How to Convert a CSV File Into a List in C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-convert-a-csv-file-into-a-list-in-csharp-ironxl/): Discover how to handle CSV files in C# using IronXL in this tutorial. You'll learn to import data, parse rows and columns, and manage file content seamlessly. Perfect for beginners looking to enhance their data processing skills. - [How to Export a List of Objects to Excel in C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-export-a-list-of-objects-to-excel-in-csharp-ironxl/): Discover how to efficiently export a C# List to an Excel file in your .NET applications using IronXL. This video guide walks you through the step-by-step process, allowing you to automate reports and data management tasks with ease. - [How to Import and Export as a DataSet in C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-import-and-export-as-a-dataset-in-csharp-ironxl/): Discover how to transform your .NET DataTable or DataSet into Excel files seamlessly with IronXL. This tutorial walks you through the process of exporting structured data to .xlsx files, enhancing your data management capabilities. - [How to Clear Cell Contents in Excel with C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-clear-cell-contents-in-excel-with-csharp-ironxl/): Discover how to programmatically clear data from Excel cells in your .NET applications using IronXL. From individual cell values to entire rows, this tutorial guides you through the process step-by-step, enhancing your data manipulation skills. - [How to Add Comments to Excel Cells in C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-add-comments-to-excel-cells-in-csharp-ironxl/): Discover how to manage Excel cell comments seamlessly with C# and IronXL. This video tutorial guides you through the process of adding, editing, and removing comments in Excel spreadsheets without needing Interop. Perfect for developers looking to enhance their automation capabilities in Excel. - [How to Import an Excel File into a SQL Database in VB NET | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-import-an-excel-file-into-a-sql-database-in-vbdotnet-ironxl/): This tutorial demonstrates how to import Excel data into a SQL Server database using VB.NET and IronXL, bypassing OLEDB and Office Interop. Gain insights on efficiently migrating data without cumbersome dependencies, enhancing your database management skills. - [How to Read Data from a CSV File and Store It in a Database Using C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-read-data-from-a-csv-file-and-store-it-in-a-database-using-csharp-ironxl/): Discover how to automate CSV imports into your SQL Server database using C# and IronXL. This tutorial provides a step-by-step guide to efficiently read and insert CSV data into SQL Server, streamlining your data management processes. - [How to Autofit Cells in Excel Using C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-autofit-cells-in-excel-using-csharp-ironxl/): Discover how to automatically adjust cell dimensions in Excel using C# and IronXL. This video tutorial guides you through the process of autofitting columns and rows, ensuring your spreadsheets appear polished and professional with minimal effort. - [How to Export DataGridView to Excel in C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-export-datagridview-to-excel-in-csharp-ironxl/): Discover how to seamlessly export DataGridView to Excel in your C# applications using IronXL. This tutorial guides you through the process, ensuring a smooth integration with WinForms or WPF. Enhance your app's functionality and data manipulation capabilities with this straightforward method. - [How to Write to Excel Files in NET with C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-write-to-excel-files-indotnet-with-csharp-ironxl/): Learn the process of writing data to Excel files using IronXL in your .NET applications. This tutorial provides a clear and easy-to-follow guide to enhance your data handling capabilities. - [How to Copy Cells using IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-copy-cells-using-ironxl/): This video tutorial demonstrates how to copy cells, ranges, rows, or columns in Excel using C# and IronXL, eliminating the need for Interop. It provides a step-by-step guide to efficiently duplicate Excel data programmatically, enhancing your data manipulation skills. - [How to Set Cell Font Size in Excel Using C# | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-set-cell-font-size-in-excel-using-csharp-ironxl/): Learn how to programmatically trim whitespace from Excel cells using C# and the IronXL library. This tutorial provides a step-by-step guide to clean up your Excel data efficiently, enhancing your data processing capabilities. - [How to Convert Excel to DataTable in C# Without oledb | IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-convert-excel-to-datatable-in-csharp-without-oledb-ironxl/): Discover how to convert Excel files into DataTables in C# without relying on OLEDB. This video tutorial guides you through the process of using IronXL to seamlessly import Excel data into your .NET applications, enhancing efficiency and simplifying your code. - [Tutorial A Comparison Between IronXL and ClosedXML 1](https://ironsoftware.com/excel/csharp/blog/videos/tutorial-a-comparison-between-ironxl-and-closedxml-1/): Learn the differences between IronXL and ClosedXML to make an informed decision for your project needs. This video provides a detailed comparison of both tools, covering features, performance, and ease of use, helping you select the most suitable option for handling Excel files efficiently. - [How to Trim Cell Ranges in Excel Using IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-trim-cell-ranges-in-excel-using-ironxl/): Discover how to efficiently trim whitespace from Excel cells using the IronXL library in C#. This tutorial guides you through the process of programmatically cleaning up your Excel data, ensuring that your datasets are tidy and accurate. - [How to Add Named Table in Excel Using C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-add-named-table-in-excel-using-csharp-ironxl/): Learn to define and manage named tables in Excel using C# with IronXL. This tutorial covers creating, formatting, and utilizing named tables for efficient data handling in your Excel projects. - [How to Set Cell Data Formats in Excel](https://ironsoftware.com/excel/csharp/blog/videos/how-to-set-cell-data-formats-in-excel-ironxl-tutorial/): Learn how to format cell data in Excel using C# and the IronXL library. - [How to Merge and Unmerge Cells in Excel](https://ironsoftware.com/excel/csharp/blog/videos/how-to-merge-and-unmerge-cells-in-excel-ironxl/): Learn to efficiently merge and unmerge cells in Excel using the IronXL Library. - [How to Trim Excel Worksheet Cell Ranges in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-trim-excel-worksheet-cell-ranges-in-csharp-ironxl/): Discover how to trim unnecessary spaces from Excel data using C# with IronXL. This tutorial offers a straightforward approach to enhance your data management skills by cleaning up cell range data effectively. - [How to Manage Excel Named Ranges in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-manage-excel-named-ranges-in-csharp-ironxl/): Discover how to streamline Excel data management in C# by using named ranges with IronXL. This tutorial provides a comprehensive guide on adding and managing named ranges, enhancing your productivity and coding efficiency. - [How to Edit Worksheet Formulas in Excel Using C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-edit-worksheet-formulas-in-excel-using-csharp-ironxl/): Discover how to programmatically modify Excel formulas using C# with IronXL. This tutorial will guide you through reading, editing, and saving changes in Excel files, offering a practical solution for developers. - [How to Apply Conditional Formatting to Cells](https://ironsoftware.com/excel/csharp/blog/videos/how-to-apply-conditional-formatting-to-cells-ironxl/): Discover how to apply conditional formatting to Excel files programmatically using the IronXL library in C#. This tutorial provides a step-by-step guide to enhance data visualizations and automate tasks, making your Excel files more insightful and visually appealing. - [How to Read an Excel File in Blazor using C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-read-an-excel-file-in-blazor-using-csharp-ironxl/): Discover how to integrate Excel file reading capabilities into your Blazor applications using IronXL. This tutorial offers step-by-step instructions to streamline data handling in C# environments. - [How to Manage Excel Worksheets in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-manage-excel-worksheets-in-csharp-ironxl/): Discover how to manage Excel worksheets using IronXL in C#. This tutorial guides you through creating, modifying, and organizing worksheets, ensuring efficient management of Excel files. Follow along to enhance your coding skills and make the most of IronXL's powerful features. - [How to Read Excel Files in C# using IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-read-excel-files-in-csharp-using-ironxl/): This tutorial provides a detailed guide on reading Excel files in C# using the IronXL library. It covers installation, loading workbooks, selecting worksheets, reading data, and using aggregate functions. The tutorial aims to equip developers with the skills needed to manipulate Excel data effectively. - [How to Write an Excel File in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-write-an-excel-file-in-csharp/): This tutorial video guides you through reading and writing Excel files using IronXL in C#. Learn to manipulate Excel data efficiently in Visual Studio 2022. The video covers setting up the environment, reading data, validating formulas, and saving modified files. - [How to Create an Excel File in C# using IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-create-an-excel-file-in-csharp-using-ironxl/): This tutorial provides a comprehensive guide on creating Excel files in C# using IronXL. It covers installation, workbook creation, cell formatting, formula application, and sheet protection, offering a seamless way to manage Excel files programmatically without Microsoft Excel. - [How to Write to Excel Files in .NET with C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-write-to-excel-files-in-net-with-csharp-ironxl/): This tutorial provides a step-by-step guide on how to write and modify Excel files using IronXL in .NET with C#. It covers writing values to cells, updating specific ranges, and performing text replacements. Learn to use dynamic values and explore various functionalities to enhance your Excel file manipulation skills. - [How to Create and Read Excel Files in VB .NET](https://ironsoftware.com/excel/csharp/blog/videos/how-to-create-and-read-excel-files-in-vb-dotnet/): This tutorial covers the process of creating and reading Excel files in VB.NET using IronXL. It provides step-by-step guidance, including setting up your environment, importing necessary namespaces, creating workbooks and worksheets, and reading data from Excel files. - [How to Sort Cell Ranges in Excel Using IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-sort-cell-ranges-in-excel-using-ironxl/): This tutorial explores sorting ranges in Excel using the IronXL library in C#. Learn to sort columns in ascending and descending order, making data organization easier. The tutorial covers setting up IronXL, importing namespaces, and executing the sorting process. - [How to Set a Password on an Excel Worksheet in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-set-a-password-on-an-excel-worksheet-in-csharp-ironxl/): This tutorial explores the process of password protecting Excel worksheets using the IronXL library in C#. It covers installation, loading workbooks, setting and removing sheet protection, and saving changes, providing a comprehensive guide for developers working with Excel files programmatically. - [How to Set a Password for a Workbook in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-set-a-password-for-a-workbook-in-csharp-ironxl/): This tutorial video demonstrates how to set a password for Excel workbooks using IronXL in C#. Learn to secure your spreadsheet data with a simple encrypt method. The video walks you through loading an Excel file, applying a password, and verifying the security measure, encouraging further exploration of IronXL's capabilities. - [How to Select a Range in Excel Using C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-select-a-range-in-excel-using-csharp-ironxl/): This tutorial delves into selecting cell ranges in Excel utilizing IronXL. From setting up your project in Visual Studio to executing the program, discover how to simplify Excel manipulation with IronXL. - [How to Read and Create Excel Files in .NET MAUI Using C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-read-and-create-excel-files-in-dotnet-maui-using-csharp-ironxl/): This tutorial demonstrates how to create, read, and edit Excel files using .NET MAUI and Iron Excel. Learn to design the application interface and implement key functionalities like file creation, modification, and storage with comprehensive guidance. - [How to Use Math Functions in Excel](https://ironsoftware.com/excel/csharp/blog/videos/how-to-use-math-functions-in-excel-ironxl/): Explore how to leverage the IonXL library in C# to enhance Excel's math functions. This tutorial guides you through importing the library, loading workbooks, and performing calculations like sum, average, maximum, and minimum on Excel data. - [How to Load Existing Spreadsheets in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-load-existing-spreadsheets-in-csharp/): Discover how to load existing Excel spreadsheets and CSV files into C applications using Iron XL. This tutorial covers installation, necessary imports, and methods for handling different file formats, enabling seamless data integration and manipulation. - [How to Create Hyperlinks in Excel Using C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-create-hyperlinks-in-excel-using-csharp-ironxl/): This tutorial covers the process of setting up hyperlinks in Excel using the Iron XL library. It provides detailed steps on linking cells within the same sheet, across different sheets, and to external files, enhancing the interactivity of Excel files. - [How to Group and Ungroup Rows and Columns in Excel](https://ironsoftware.com/excel/csharp/blog/videos/how-to-group-and-ungroup-rows-and-columns-in-excel-ironxl/): Discover how to organize Excel data by grouping and ungrouping rows and columns using the IronXL Library. This tutorial provides a clear, step-by-step guide from installing necessary libraries to implementing code and saving your grouped data. Enhance your Excel navigation with easy expand and collapse features. - [How to Edit Workbook Metadata in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-edit-workbook-metadata-in-csharp-ironxl/): Master the art of editing Excel workbook metadata using IronXL in C#. This tutorial guides you through setting up a project in Visual Studio, loading Excel files, and modifying metadata properties like author and comments. Discover the power of IronXL to enhance your Excel file management skills. - [How to Create and Edit Excel Charts in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-create-and-edit-excel-charts-in-csharp-ironxl/): This tutorial guides you through creating and editing Excel charts in C using the Iron XL library. Learn to load workbooks, create charts, customize titles, and save your work efficiently. Discover how to programmatically manage charts in Excel for dynamic data presentations. - [How to Edit Excel File in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-edit-excel-file-in-csharp-ironxl/): This tutorial guides you through editing Excel files in C using Iron Excel. It demonstrates various techniques to modify cell values, replace content, and manage worksheets effectively. By the end, you'll be equipped to perform advanced Excel manipulations in your C projects. - [How to Create New Spreadsheets in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-create-new-spreadsheets-in-csharp-ironxl/): Discover how to create spreadsheets in C using Iron XL. This tutorial guides you through installing the necessary packages, creating workbooks, and saving them in preferred formats. Learn to utilize Iron XL's functionalities to tailor spreadsheets to your needs. - [How to Copy Cell Content in Excel in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-copy-cell-content-in-excel-in-csharp-ironxl/): Discover the power of IronXL for automating Excel tasks using C#. This tutorial covers copying single cells, entire rows, columns, and ranges programmatically. Follow along to enhance your efficiency in handling Excel files. - [How to Convert Spreadsheet Files to JSON, CSV, XML & More with IronXL in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-convert-spreadsheet-files-to-json-csv-xml-and-more-with-ironxl-in-csharp/): Explore the powerful Excel manipulation capabilities of Iron Software in C#. This tutorial walks you through importing, exporting, and transforming Excel files using IronXL within Visual Studio. Learn how to convert data into various formats like CSV, JSON, XML, and HTML effortlessly. - [How to Export Excel Data Using C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-export-excel-data-using-csharp/): This tutorial demonstrates how to export Excel data into CSV, JSON, and XML formats using C# and the IronXL library. Follow along to learn the process of setting up a console application in Visual Studio 2022 and utilizing IronXL's functions to save data in different formats. - [How to Use Excel Interop in C# Alternatively](https://ironsoftware.com/excel/csharp/blog/videos/how-to-use-excel-interop-in-csharp-alternatively-ironxl/): This tutorial guides users through using Iron Excel to read and manage Excel files without interop. It explains loading workbooks, accessing specific worksheets, and retrieving cell values, both individually and in ranges. The tutorial concludes by encouraging viewers to explore Iron Excel's capabilities. - [How to Set Cell Borders and Alignment in Excel](https://ironsoftware.com/excel/csharp/blog/videos/how-to-set-cell-borders-and-alignment-in-excel-ironxl/): This tutorial guides you through the process of setting cell borders and alignments in Excel using C# with IronXL and the Iron Software Drawing Library. Learn how to create a workbook, set thick borders with customized colors, and explore various border types and alignment options for enhanced Excel sheets. - [How to Read Excel File in Blazor NET](https://ironsoftware.com/excel/csharp/blog/videos/how-to-read-excel-file-in-blazor-net-ironxl/): This tutorial guides you through setting up an Excel file viewer in a Blazor Server application using IronXL. It covers installation, coding, and execution processes, allowing you to integrate Excel data viewing into your web app efficiently. Follow the steps to seamlessly display Excel data on your Blazor web page. - [How to Set Cell Background Patterns and Color in Excel](https://ironsoftware.com/excel/csharp/blog/videos/how-to-set-cell-background-patterns-and-color-in-excel-ironxl-tutorial/): Discover how to enhance your Excel sheets by setting background patterns and colors using IronXL and Iron Software Drawing Library. This tutorial provides a detailed walk-through of manipulating cell styles and saving your customized workbook. - [How to Auto Resize Rows and Columns in Excel](https://ironsoftware.com/excel/csharp/blog/videos/how-to-auto-resize-rows-and-columns-in-excel-ironxl/): Discover how to auto resize rows and columns in Excel using IronXL in C#. This tutorial covers importing the IronXL namespace, resizing methods, and saving changes to an Excel file. Enhance your spreadsheet's readability and organization with this efficient method, eliminating unnecessary white space and clipped text. - [How to Add Rows and Columns in Excel as a C# Developer](https://ironsoftware.com/excel/csharp/blog/videos/how-to-add-rows-and-columns-in-excel-as-a-csharp-developer/): Discover how to add rows and columns in Excel using C# and IronXL. This tutorial provides a comprehensive guide on utilizing Visual Studio 2022 for seamless Excel file manipulation, ensuring effective data management. - [How to Add Freeze Panes to Spreadsheets in Excel](https://ironsoftware.com/excel/csharp/blog/videos/how-to-add-freeze-panes-to-spreadsheets-in-excel-ironxl/): This tutorial demonstrates how to use the IronXL library in C# to add freeze panes to Excel spreadsheets. By following the detailed instructions, users can enhance data visibility and navigation in Excel workbooks. - [How to Add, Extract, and Remove Images from Worksheets](https://ironsoftware.com/excel/csharp/blog/videos/how-to-add-extract-and-remove-images-from-worksheets-ironxl/): This tutorial explores how to manipulate images in Excel spreadsheets using the IronXL library in C#. Learn to add, extract, and remove images, and save your work efficiently. Perfect for developers looking to enhance their spreadsheet functionalities. - [C# Excel Tutorial: Learn to use IronXL Library (No Interop)](https://ironsoftware.com/excel/csharp/blog/videos/csharp-excel-tutorial-learn-to-use-ironxl-library-no-interop/): Learn how to use the IronXL library for Excel file manipulation in this step-by-step guide. From installation to file modification and exporting in different formats, this video tutorial provides a comprehensive introduction to using IronXL in Visual Studio 2022. - [A Comparison Between IronXL and ClosedXML](https://ironsoftware.com/excel/csharp/blog/videos/a-comparison-between-ironxl-and-closedxml-1/): This video compares Iron XL and Close XML, two popular .NET libraries for reading Excel files. It demonstrates the differences in complexity and versatility, highlighting Iron XL's broader file compatibility and straightforward approach compared to Close XML's Excel-specific capabilities. - [How to Read CSV files in C# using IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-read-csv-files-in-csharp-using-ironxl/): This tutorial explains how to read CSV files in C# using the IronXL library. It covers installation steps, reading data from a CSV file, and performing aggregation functions like sum and min. IronXL simplifies the process, making it accessible for developers. Support is available for further assistance. - [How to Read Excel Data and Insert to Database Table in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-read-excel-data-and-insert-to-database-table-in-csharp-ironxl/): This tutorial guides you through importing Excel data into a database using C#. By leveraging IronXL, you'll learn to load Excel files, convert them to datasets, and insert data into SQL tables seamlessly. The tutorial covers setting up the environment, creating and verifying tables, and executing parameterized SQL commands. - [How to Convert a Data Table to an Excel File](https://ironsoftware.com/excel/csharp/blog/videos/how-to-convert-a-data-table-to-an-excel-file/): This tutorial demonstrates converting a data table to an Excel file in C# using the Iron Excel library. Learn how to set up a console application in Visual Studio, import necessary libraries, create a workbook, and save data efficiently. - [How to Import CSV To Datatable in C#](https://ironsoftware.com/excel/csharp/blog/videos/how-to-import-csv-to-datatable-in-csharp-ironxl/): This tutorial demonstrates how to import CSV files into a data table using the IronXL library in C#. The process involves setting up the environment, writing a method for CSV import, and handling exceptions. The video provides a clear walkthrough, ensuring successful CSV conversion and output display. - [How to Export Data to Excel in Blazor using IronXL](https://ironsoftware.com/excel/csharp/blog/videos/how-to-export-data-to-excel-in-blazor-using-ironxl/): Discover how to export data in Excel using IronXL in Blazor with Visual Studio 2022. This tutorial covers setting up the environment, creating necessary files, and executing JavaScript for seamless Excel file downloads. - [A Comparison of IronXL vs Spire.XLS](https://ironsoftware.com/excel/csharp/blog/videos/a-comparison-of-ironxl-vs-spire.xls/): This tutorial provides a comprehensive comparison between IronXL and Spire.XLS libraries for handling Excel files. It covers project setup, package installation, and code examples for creating and converting Excel files. IronXL offers automated processes with minimal code, while Spire.XLS provides more manual control. Learn which library suits your project needs. - [A Comparison of NPOI vs IronXL](https://ironsoftware.com/excel/csharp/blog/videos/a-comparison-of-npoi-vs-ironxl/): This video tutorial provides a comprehensive comparison of IronXL and NPOI libraries for Windows Forms applications. It covers installation, performance, and functionality, highlighting the advantages of IronXL in terms of simplicity and speed for Excel file handling, including exporting to CSV and JSON. - [A Comparison of IronXL vs Microsoft Office Interop Excel](https://ironsoftware.com/excel/csharp/blog/videos/a-comparison-of-ironxl-vs-microsoft-office-interop-excel/): This video explores the differences between Iron Excel and Microsoft Interop Excel. It highlights the ease of use, speed, and compatibility of Iron Excel compared to the limitations of Microsoft Interop Excel. The video also emphasizes Iron Excel's support for multiple formats and compatibility across platforms, making it a superior choice.