Skip to footer content

Regan Pun

Software Engineer
Regan graduated from the University of Reading, with a BA in Electronic Engineering. Before joining Iron Software, his previous job roles had him laser-focused on single tasks; and what he most enjoys at Iron Software is the spectrum of work he gets to undertake, whether it’s adding value to sales, technical support, product development or marketing. He enjoys understanding the way developers are using the Iron Software library, and using that knowledge to continually improve documentation and develop the products.

Recent Articles

  • How to Apply Conditional Formatting to Cells

    Learn how to use IronXL to apply conditional formatting to Excel files programmatically in C#. Enhance your data visualization skills with this easy-to-follow tutorial.

    Read More
  • How to Edit Worksheet Formulas in Excel Using C#

    Learn how to programmatically edit Excel formulas using C# and IronXL. This tutorial provides a comprehensive guide to reading, modifying, and saving changes in Excel files.

    Read More
  • How to Manage Excel Named Ranges in C#

    Learn how to efficiently add and manage named ranges in Excel using C# with the IronXL library. Simplify your data handling tasks with step-by-step guidance.

    Read More
  • How to Read an Excel File in Blazor using C#

    Learn how to seamlessly read Excel files in your Blazor applications using IronXL. This tutorial guides you through the process with ease.

    Read More
  • How to Trim Excel Worksheet Cell Ranges in C#

    Learn how to efficiently trim unwanted spaces in Excel using C# with IronXL. This tutorial guides you through streamlining your data cleanup process.

    Read More
  • How to Add Glow Effect To Text in C#

    Learn how to apply a glow effect to text in Word documents programmatically using C# with our step-by-step IronWord tutorial. Enhance your documents effortlessly!

    Read More
  • A Comparison Between IronXL and ClosedXML

    Discover the differences between Iron XL and Close XML for reading Excel files. Learn which .NET library suits your needs best, with a focus on ease of use and file compatibility.

    Read More
  • A Comparison of IronXL vs Microsoft Office Interop Excel

    Discover the advantages of using Iron Excel over Microsoft Interop Excel. Learn about installation, functionality, and performance differences between these two Excel handling libraries.

    Read More
  • A Comparison of IronXL vs Spire.XLS

    Discover the differences between IronXL and Spire XLS in this detailed tutorial. Learn how to convert CSV to Excel and create Excel files using these libraries.

    Read More
  • A Comparison of NPOI vs IronXL

    Explore the differences between IronXL and NPOI libraries for processing Excel files in C#. Learn how to install, use, and export data efficiently.

    Read More
  • C# Excel Tutorial: Learn to use IronXL Library (No Interop)

    Learn how to use the IronXL library in C# to load, edit, and create Excel files without needing Microsoft Office. This step-by-step tutorial shows how to apply formulas, styles, and export to CSV, JSON, XML, and XLSX formats.

    Read More
  • How to Add, Extract, and Remove Images from Worksheets

    Learn to efficiently add, extract, and remove images in Excel using the IronXL library in C#. This tutorial guides you through the entire process, ensuring seamless integration of images into your spreadsheets.

    Read More
  • How to Add Freeze Panes to Spreadsheets in Excel

    Learn how to efficiently add freeze panes to your Excel spreadsheets using C# and the IronXL library. Follow our step-by-step tutorial to enhance your data management skills.

    Read More
  • How to Add Rows and Columns in Excel as a C# Developer

    Learn how to efficiently add rows and columns in Excel using C# and IronXL in this step-by-step tutorial. Utilize Visual Studio 2022 and IronXL for seamless Excel manipulation.

    Read More
  • How to Auto Resize Rows and Columns in Excel

    Discover how to efficiently auto resize rows and columns in Excel using IronXL in C#. Optimize your spreadsheets with our step-by-step tutorial.

    Read More
  • How to Convert a Data Table to an Excel File

    Learn how to convert a data table to an Excel file programmatically in C# with this tutorial. Discover the power of the IronXL library for seamless data manipulation.

    Read More
  • How to Convert Spreadsheet Files to JSON, CSV, XML & More with IronXL in C#

    Learn how to import, export, and transform Excel files using IronXL in C#. Explore intelligent data restructuring and format conversion in this comprehensive tutorial.

    Read More
  • How to Copy Cell Content in Excel in C#

    Learn how to copy cells, rows, columns, and ranges in Excel programmatically using IronXL in C#. Follow our step-by-step tutorial to enhance your Excel manipulation skills.

    Read More
  • How to Create and Edit Excel Charts in C#

    Learn how to create, edit, and customize Excel charts in C using the Iron XL library. This tutorial guides you through the process of installing Iron XL, creating various charts, and editing properties programmatically.

    Read More
  • How to Create and Read Excel Files in VB .NET

    Learn to create and read Excel files in VB.NET using IronXL. Follow our step-by-step guide to enhance your applications with Excel file manipulation.

    Read More
  • How to Create Hyperlinks in Excel Using C#

    Learn how to set up hyperlinks in Excel using the Iron XL library. This tutorial covers linking within worksheets, across sheets, and to external files, enhancing your Excel's interactivity.

    Read More
  • How to Create New Spreadsheets in C#

    Learn how to programmatically create new spreadsheets using Iron XL in C. This tutorial covers installation, setup, and executing your first spreadsheet creation seamlessly.

    Read More
  • How to Edit Excel File in C#

    Learn how to edit Excel files using IronXL in C#. This tutorial covers manipulating cells, rows, columns, and worksheets efficiently. Discover essential techniques for Excel file management with hands-on examples.

    Read More
  • How to Edit Workbook Metadata in C#

    Learn how to use IronXL to edit workbook metadata in C#. Follow this step-by-step guide to enhance your Excel files with additional info like author, title, and more.

    Read More
  • How to Export Data to Excel in Blazor using IronXL

    Learn how to efficiently export data in Excel using Blazor and IronXL. This tutorial guides you through the process with Visual Studio 2022, ensuring a smooth data exporting experience.

    Read More
  • How to Export Excel Data Using C#

    Learn how to export Excel spreadsheet data into CSV, JSON, and XML formats using C# and IronXL in Visual Studio 2022. Follow our comprehensive tutorial for seamless data conversion.

    Read More
  • How to Group and Ungroup Rows and Columns in Excel

    Learn how to efficiently group and ungroup rows and columns in Excel using the IronXL library. Simplify your data management with this step-by-step tutorial.

    Read More
  • How to Import CSV To Datatable in C#

    Learn how to efficiently import CSV files into a data table in C# using the IronXL library. Follow our step-by-step guide to ensure a seamless CSV data conversion process.

    Read More
  • How to Load Existing Spreadsheets in C#

    Learn to efficiently load Excel spreadsheets and CSV files in C applications with Iron XL. Follow our step-by-step tutorial to seamlessly integrate data and enhance your data manipulation capabilities.

    Read More
  • How to Manage Excel Worksheets in C#

    Learn how to manage Excel worksheets using IronXL in C#. This tutorial covers creating, shuffling, and modifying worksheets for efficient Excel file management.

    Read More
  • How to Read and Create Excel Files in .NET MAUI Using C#

    Learn how to create, edit, and read Excel files in .NET MAUI using IronXL. Follow our step-by-step guide to design application front-end, implement Excel functionalities, and handle file operations efficiently.

    Read More
  • How to Read CSV files in C# using IronXL

    Learn how to effortlessly read CSV files in C# using the IronXL library. This tutorial guides you through installation, setup, and data aggregation techniques to enhance your programming skills.

    Read More
  • How to Read Excel Data and Insert to Database Table in C#

    Learn how to seamlessly import Excel data into a SQL database using C# and IronXL. Follow our step-by-step tutorial for a smooth data migration process.

    Read More
  • How to Read Excel File in Blazor NET

    Learn how to set up an Excel file viewer in a Blazer Server application using Iron XL. Follow our step-by-step tutorial using Visual Studio to seamlessly integrate Excel data into your web app.

    Read More
  • How to Read Excel Files in C# using IronXL

    Learn how to efficiently read Excel files in C# using the IronXL library with this step-by-step tutorial. Discover how to install the library, load workbooks, read data, and use aggregate functions like sum and max.

    Read More
  • How to Select a Range in Excel Using C#

    Learn the step-by-step process of selecting cell ranges in Excel using IronXL. This tutorial covers loading workbooks, accessing worksheets, and manipulating ranges efficiently.

    Read More
  • How to Set a Password for a Workbook in C#

    Learn how to secure your Excel workbooks by setting up password protection using IronXL in C#. Follow our step-by-step tutorial to enhance your file security.

    Read More
  • How to Set a Password on an Excel Worksheet in C#

    Learn how to protect and unprotect Excel worksheets using IronXL in C#. This tutorial guides you step-by-step through the process, ensuring your data remains secure.

    Read More
  • How to Set Cell Background Patterns and Color in Excel

    Learn how to enhance your Excel sheets by setting cell background patterns and colors using IronXL and Iron Software Drawing Library. Follow our step-by-step guide to add visual appeal to your spreadsheets effortlessly.

    Read More
  • How to Set Cell Borders and Alignment in Excel

    Learn how to set cell borders and alignment in Excel with C# using IronXL. Explore various border styles and alignments to customize your Excel worksheets. Start coding today!

    Read More
  • How to Sort Cell Ranges in Excel Using IronXL

    Learn how to sort Excel ranges efficiently using the IronXL library in C#. This tutorial covers installation, code breakdown, and practical application of sorting techniques.

    Read More
  • How to Use Excel Interop in C# Alternatively

    Learn how to efficiently read and access Excel files without interop using IronXL. Our tutorial guides you through loading files, accessing worksheets, and retrieving cell values.

    Read More
  • How to Use Math Functions in Excel

    Learn how to enhance Excel's math functions using the Ion XL library in C. This tutorial guides you through calculating sums, averages, and more with ease.

    Read More
  • How to Write an Excel File in C#

    Discover how to efficiently read and write Excel files using IronXL in C# with Visual Studio 2022. Follow this step-by-step tutorial to manipulate Excel data seamlessly.

    Read More
  • How to Write to Excel Files in .NET with C#

    Learn how to programmatically write and modify Excel files using C# and IronXL. This tutorial covers cell updates, range modifications, dynamic value insertion, and text replacements across sheets.

    Read More
  • How to Convert Powerpoint (PPT) to PDF in C#

    Learn how to convert PowerPoint presentations to PDF using C# with Iron PDF in Visual Studio 2022. Follow this tutorial for a seamless process with detailed instructions.

    Read More
  • How to open Word Document in C#

    Learn to open and read Word documents in C# using Iron Word. This tutorial guides you through setting up Iron Word, loading documents, and accessing content.

    Read More
  • How to Work with Document Elements in C#

    Learn how to efficiently manage Word documents using Iron Word in C#. Follow this step-by-step tutorial to style text, add images, and save documents programmatically.

    Read More
  • How to Create an Excel File in C# using IronXL

    Learn how to create and manipulate Excel files in C# using IronXL. This tutorial covers installation, sheet creation, cell formatting, formula application, and file protection.

    Read More
  • ASP .NET Core Import & Export A Word File

    This guide explores how to import existing Word documents, display their content, and create documents from scratch using the IronWord library

    Read More
  • How to Align Text in Word Using C#

    let's dig deep into the IronWord NuGet package and how to align text or paragraphs using this package

    Read More
  • VS 2022 Programmatically Create New Word Documents (Tutorial)

    In today's tutorial, I'll briefly explain how to programmatically create a Microsoft Word Document using IronWord and provide brief examples.

    Read More
  • Can you add a PDF to a Word Document (Beginner Guide)

    Let's understand how to add a PDF to your Word document as an embedded object.

    Read More
  • Convert PDF to Word free no Sign Up (Beginner Tutorial)

    In this tutorial, we'll show you how to use a PDF-to-Word converter to convert PDF files for free without any sign-ups

    Read More
  • How do you convert a PDF to a Word document (Beginner Tutorial)

    PDF file format is great for sharing, but when it comes to making changes, they can be a real headache. That's where converting a PDF document to Word comes in handy

    Read More
  • How to save a PDF file as a Word document

    In this tutorial, we'll explore some approaches to converting your PDF files into editable Word documents

    Read More
  • How to Extract Text from Word in C#

    C# is undoubtedly used to develop extremely scalable and efficient applications that extract text from Word files

    Read More
  • How to Generate a Word Document Using a Word Template in C#

    In this article, we’ll walk through how to use IronWord to fill a Word document template and provide a practical example to illustrate the process.

    Read More
  • How to Add Watermark to A Word File in C#

    This article will only use image and picture watermarks, discuss IronWord as a library, and provide practical examples of adding images to the Word document.

    Read More
  • How to Manage Excel Ranges in C#

    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.

    Read More
  • How to Work with Excel Files in C#

    Working with Microsoft Excel files in programming languages has become a significant requirement in today's modern programming paradigm

    Read More
  • How to Import Excel to SQL Server in C#

    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

    Read More
  • How to create a Word document from a template using C#

    In this comprehensive guide, we'll delve into the intricacies of using IronWord to generate Word documents from templates in C#

    Read More
  • How to Export Document to Word in C#

    In this guide, we'll explore how to create a new C# Console Application and how to export data to MS Word documents in C# using IronWord

    Read More
  • How to Create a new Excel Workbook in C#

    We'll walk through the necessary steps, from setting up your development environment to writing the code that generates a new Excel workbook.

    Read More
  • How to Use C# 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.

    Read More
  • How to Rename Excel WorkSheet in C#

    In this article, we'll explore how to rename Excel files using IronXL library from IronSoftware.

    Read More
  • How to Autofit Cells in Excel Using C#

    In this article, we will learn how to autofit column width and height in Excel using C# and IronXL.

    Read More
  • How to parse an Excel file in Python

    We will examine how to parse an Excel file in Python using IronXL in this in-depth tutorial.

    Read More
  • How to View PowerPoint Files in C#

    In this article, we will create C# PowerPoint Viewer without installing MS PowerPoint Viewer.

    Read More
  • How to Read an Excel File in a C# Console Application

    This article will guide you through the process of reading Excel files in a C# Console Application using the IronXL library

    Read More
  • How to Create DOCX File in C#

    we'll dive into the world of C# document generation and examine the robust libraries and programming methods that can be used in C# to create DOCX files.

    Read More
  • How to Perform C# Word Automation

    In this comprehensive guide, we'll explore the ins and outs of Word automation in C# using IronWord in Visual Studio

    Read More
  • .NET Word API (How It Works For Developers)

    The .NET Word API provides developers with robust tools to convert Word documents, interact with, and manipulate MS Word documents within their applications

    Read More
  • How to Use Create PowerPoint from a Template in C#

    In this post, we'll look at how to use C# to create a PowerPoint from a template

    Read More
  • .NET Word Library Comparison: Find the Best

    Each .NET Word library has its unique features and limitations, and understanding these can help developers choose the right tool for their specific needs.

    Read More
  • How to Use C# to Convert PowerPoint to Image

    There are several methods for turning PowerPoint presentations into photos in C#

    Read More
  • A Comparison Between IronWord & Aspose Words For .NET

    Consider Aspose.Word as a versatile tool in your arsenal, adept at handling a multitude of document formats and offering extensive features for complex document creation and manipulation

    Read More
  • A Comparison Between IronWord & Microsoft.Office.Interop.Word

    Microsoft.Office.Interop.Word is a library that enables .NET applications to interact directly with Microsoft Word documents

    Read More
  • How to Create Word Documents Without Office Interop in C#

    This article will explore the creation of Word documents in C# using the IronWORD library.

    Read More
  • How to Create Word Document Programmatically in VB .NET

    In this article, we'll explore the importance of creating Microsoft Word files in C# applications and introduce the IronWord library as a powerful tool to generate Word Documents programmatically

    Read More
  • How to Read Word Document With Formatting in C#

    If you're working with C# and need to read Word documents while preserving their formatting

    Read More
  • How to Convert CSV File Into List in C#

    In this tutorial for beginners, we are going to see how to read CSV files into a list in C# using the IronXL

    Read More
  • How to Export Datagridview To Excel in C#

    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#

    Read More
  • How to Convert An Excel File to XML in C#

    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#.

    Read More
  • How to Read Data From CSV File And Store It In Database C#

    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

    Read More
  • How to Import an Excel File to SQL Database in VB .NET

    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.

    Read More
  • How to Save An Excel File in VB .NET

    In this article, we're going to look at how you can use VB.NET to save Excel files with the help of IronXL.

    Read More
  • Comparing Three Open Source C# Excel Libraries

    This article will explore three C# Open Source Excel libraries designed to simplify Excel file manipulation in a .NET environment

    Read More
  • C# Excel Automation (Developer Tutorial)

    In this article, we are going to see more about Excel automation in C#

    Read More
  • Work with Excel Files Without Microsoft Office in C#

    This makes it a go-to solution for server environments where installing Microsoft Office is not feasible due to licensing or server performance constraints.

    Read More
  • Test Your Regex Patterns with .NET Regex Tester

    This article delves into the capabilities of .NET Regex Tester, providing insights and examples into its usage and integration with [IronXL

    Read More
  • How to Convert Excel to Datatable in C# Without oledb

    In this article, we are going to convert Excel to datatable in C# without OLEDB connectivity.

    Read More
  • How to Concatenate or Merge Excel Files in C# 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.

    Read More
  • How to Create A Word Document in C#

    Generating Word documents is a common task in many C# applications. This tutorial will guide you through the process of generating and working with Word documents using C#

    Read More
  • How To Read a Word File Using C#

    In this article, we will use C# to read a Word document using Microsoft Interop assemblies and How IronXL can help us read Excel sheets.

    Read More
  • 3 C# Word Libraries (Updated List For Developers)

    This article provides an insightful comparison of four prominent open-source C# Word libraries: Microsoft Office Interop Word and FileFormat.Words, and OfficeIMO.

    Read More
  • How To Manipulate A Word document Using C#

    In this article, we will manipulate Word documents using C# with the help of Microsoft Interop assemblies and explore how IronXL helps us to Edit Excel documents.

    Read More
  • How to Load An Excel File in C#

    This article will demonstrate how to load Excel files using IronXL, a first-class Excel C# library, efficiently and programmatically.

    Read More
  • C# CSV Library (Developer Tutorial)

    In this article, we will explore C# programming using IronXL's features for efficiently working with CSV files.

    Read More
  • How to Write A CSV File in C#

    In this article, we will see how to write CSV files using a C# library named IronXL in a new project.

    Read More
  • How to Export to CSV in .NET Core

    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.

    Read More
  • How to Export File to CSV in C#

    IronXL, a first-class C# library that offers a wide range of features to read and export Excel spreadsheets to CSV files.

    Read More
  • How to Save A CSV File in C#

    In this article, we will use IronXL's market-leading data manipulation library to save spreadsheets as CSV files and modify data in the transformation process.

    Read More
  • How to Edit a Spreadsheet in C#

    This article explores spreadsheet manipulation in C# using IronXL, an advanced data manipulation library, without relying on user interface interactions.

    Read More
  • C# Edit Word (Code Example Developer Tutorial)

    Creating, editing, and managing Word documents is a frequent requirement for many applications. While there are several ways to create and edit a Word document in C#

    Read More
  • How to Work With Excel Files Using IronXL: A .NET Excel Library

    The C# IronXL library, a .NET Excel tool, allows users to read and convert Microsoft Excel documents to CSV files efficiently and programmatically.

    Read More
  • Zip Archive Tutorial for C# Developers Using IronXL

    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.

    Read More
  • C# Print Word Tutorial: Step-by-Step Guide

    Welcome to this tutorial, where we will explore how to print Word documents using the Microsoft Interop in a C# Console Application

    Read More
  • How to Open Excel File in ASP .NET Core

    In this tutorial, we will learn how to open an Excel file in an ASP.NET Core application using the IronXL library.

    Read More
  • How to Merge Cells in Excel Without Losing Data

    IronXL enables merging multiple columns/cells in Excel programmatically, offering an efficient method for developers.

    Read More
  • How to View Excel in ASP.NET

    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.

    Read More
  • How to Convert XLS to XLSX File in C#

    Here in this article, we are going to explore the IronXL library to convert XLS to XLSX format in the C# console application.

    Read More
  • How To Disable Protected View in Excel Using C#

    In this article we will see how you can easily disable the excel protected view message using Advance C# Excel Library IronXL.

    Read More
  • How To Set Background Color in Excel Cell Using C#

    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.

    Read More
  • How To Write Data in CSV File in C#

    Let's explore how IronXL allows you to save or export data from Excel files to various formats such as CSV or DataTable programmatically.

    Read More
  • How to Open Excel File and Write Data in C#

    This article explores using the IronXL library to read and write data to an Excel file in a C# console application with utmost efficiency.

    Read More
  • How to Export Huge Data From Datatable to Excel in C#

    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.

    Read More
  • How to Export to CSV in Blazor

    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.

    Read More
  • How to Convert Excel to Datagridview in C#

    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.

    Read More
  • How to Convert Excel to Datatable in C#

    This Excel to DataTable conversion can be done easily using IronXL, which provides an efficient method to handle Excel files in C#.

    Read More
  • EPPlus Read Excel to Datatable C# (IronXL Tutorial)

    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,

    Read More
  • A Comparison Between IronXL and FastExcel for .NET

    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#.

    Read More
  • How to Export File to Excel in .NET 6

    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.

    Read More
  • How to Export Datatable to Excel in ASP.NET Core

    In this article, we will explore the different ways to export DataTable to Excel file and the benefits of doing so.

    Read More
  • How to Convert Dataset to CSV in C#

    In the following article, we will learn about converting a C# dataset into a CSV file using IronXL at our convenience to enhance productivity.

    Read More
  • How to Read CSV File in C#

    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.

    Read More
  • How to Convert Dataset to Excel in C#

    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

    Read More
  • How to Get Cell Value From Excel File in C#

    Understanding how to retrieve cell values in C# can help you manipulate and analyze data in Excel more efficiently and effectively.

    Read More
  • How to Export Datatable to CSV in C#

    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.

    Read More
  • How to Export to Excel With Formatting in C#

    In this article, we'll discuss methods for exporting data from a CSV file to visually engaging Excel spreadsheets with cell stylings using IronXL.

    Read More
  • How to Import Excel File in C#

    IronXL allows developers to import and read Excel files in C# without needing Excel installed.

    Read More
  • How to Freeze a Row in Excel (Beginner Guide)

    IronXL offer features like freeze panes to view content from different workbook areas simultaneously, enhancing productivity.

    Read More
  • How to Export to Excel in ASP.NET Core

    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.

    Read More
  • C# Fastest way to Export DataTable to Excel

    This article demonstrates how to create a datatable in C# and export it to an Excel document using the IronXL .NET Excel library, while maintaining full Excel feature compatibility.

    Read More
  • How to Export Datatable to Excel in 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.

    Read More
  • 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.

    Read More
  • How to Export CSV and Excel in Razor

    Web development that interacts with Excel and CSV files is simplified by Razor and IronXL for productivity.

    Read More
  • How to Read Excel File in C#

    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.

    Read More
  • How to Open Excel File in C#

    This tutorial examines how IronXL can open, read, and edit Excel documents in C# projects, a vital part of modern business applications.

    Read More
  • How to Convert a Table to a Range in 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.

    Read More
  • How to Fetch Data From Excel Sheet in C#

    This tutorial explores how to fetch data from Excel sheets and put it into DataTables in C# using IronXL.

    Read More
  • 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.

    Read More
  • How to Generate an Excel File on Razor Pages

    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 More
  • C# Open Excel File Programmatically (Code Example Tutorial)

    Creating XLSX files programmatically can quickly become complicated. The IronXL C# library helps to simplify this process.

    Read More
  • Read CSV File Using C# (Code Example Tutorial)

    The IronXL library provides an easy way to read CSV files in C#. Converting and editing Excel files has never been easier.

    Read More
  • How to Highlight Every Other Row in Excel

    We often highlight Excel rows to emphasize important data. IronXL can automate this process, enhancing productivity.

    Read More
  • 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.

    Read More
  • A Comparison between IronXL and GrapeCity Excel Viewer

    GrapeCity's embedded bi platform offers limitless high-speed visual data exploration, allowing the everyday user to become data-driven to easily report solutions.

    Read More
  • A Comparison between IronXL and Syncfusion Excel

    The Syncfusion library provides an API for reading, writing, and manipulating Microsoft Excel (XLS) files.

    Read More
  • A Comparison between IronXL and CsvHelper

    A .NET library for reading and writing CSV files. Extremely fast, flexible, and easy to use. Supports reading and writing of custom class objects.

    Read More
  • A Comparison between IronXL and CsvWriter

    A .NET library for writing CSV files. Extremely fast, flexible, and easy to use. Supports writing of custom class objects.

    Read More
  • How to Add Up a 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.

    Read More
  • 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.

    Read More
  • A Comparison between IronXL and Aspose Cells

    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.

    Read More
  • A Comparison between IronXL and Epplus

    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.

    Read More
  • How to Lock Cells in Excel: a Step by Step Tutorial

    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.

    Read More
  • How to Merge Cells in Excel: Step by Step Tutorial

    Learning how to merge cells in Microsoft Excel and automate those common tasks using IronXL in C# to enhance productivity.

    Read More
  • A Comparison of IronXL and Aspose Cells

    Compare IronXL to Aspose.Cells for Excel file manipulation in C#.

    Read More
  • Create a CSV file using C#

    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#.

    Read More
  • How to Use a CSV Parser in C#

    IronXL C# library enables easy creation of CSV parsers, simplifying the process for users with different expertise levels.

    Read More
  • Generate Excel Files in C#

    Generate Excel File C#, including XLSX, JSON, CSV, XML and other formats for your C# project programmatically.

    Read More
  • Work with Excel in .NET Core

    .NET Core Excel overview and example projects. The code samples demonstrate how to work with Excel programmatically.

    Read More
  • A Comparison between IronXL and GemBox.Spreadsheet

    IronXL and Gembox Spreadsheet both provide the methods to create, edit, and read Excel documents in the .NET framework.

    Read More
  • How to Create CSV File in C# (Step-By-Step) 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.

    Read More
  • C# CSV Parser (Step-By-Step) 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.

    Read More