IronSoftware
  • Products
    for .NET Java
    Create, read, and edit PDFs
    for .NET
    Image to text in 127 languages
    for .NET
    Read and write QR & Barcodes
    for .NET
    Edit Excel & CSV Files.
    No Office Interop required
    for .NET
    Extract structured data from websites
    5 for the Price of 2 All 5 .NET product licenses from $1498 Save 60% with Iron Suite Iron Suites - Donate $50
  • Open Source
    for .NET
    System.Drawing.Common Replacement
  • About Us
  • Contact Us

205 N. Michigan Ave. Chicago, IL 60611, USA +1 (312) 500-3060

Join Iron Slack

  • Home
  • Licensing
  • EULA
  • Support & Update Extensions
  • License Upgrades
  • Start 30-Day Trial
  • Features
  • Get Started
  • Code Examples
  • Tutorials
  • How-Tos
  • Troubleshooting
  • Product Updates
  • API Reference
  • Search
  • Free NuGet Download
IronXL - Excel Library for C# .NET IronXL - Excel Library for C# .NET
  • Home
  • Licensing
    • Licensing
    • EULA
    • Support & Update Extensions
    • License Upgrades
    • Start 30-Day Trial
  • Features
  • Docs
    • Search
    • Get Started
    • Code Examples
    • Tutorials
    • How-Tos
    • Troubleshooting
    • Product Updates
    • API Reference
    • Search
  • Search
  • Free NuGet Download Total downloads: 350,261
Message's icon
IronXL
Code Examples
  1. IronXL
  2. Code Examples
  3. Load Excel From SQL Database
IronXL
Free for development from NuGet

Install with NuGet nuget.org/packages/IronXL.Excel

PM > Install-Package IronXL.Excel

Explore the Docs

  • Get Started
  • Features
  • Code Examples
    • How to Read an Excel File in C#
    • Using C# to Create Excel Files in .NET
    • Use C# to Open & Write an Excel File
    • Compatibility
      • License Keys
      • Setup on macOS
      • Setup on AWS
      • Setup on Azure
      • Setup on Docker
      • Setup on Linux
      • Work with Excel in C# without Interop
      • Work with VB.NET Excel Files
      • Work with Excel on .NET MAUI
      • Read Excel Files in Blazor
    • Workbooks
      • Create Excel Documents in C#
      • Create an XLSX File
      • Parse Excel Files in C#
      • Read Excel File Example
      • Export to Excel in C#
      • Read XLSX File C#
      • Read a CSV in C#
      • Encrypt Workbook with Password
      • Read Excel Files in ASP.NET Web Apps
      • Write CSV in .NET
      • Open Excel Worksheets in C#
      • Convert a Data Table to CSV
      • Convert XLSX to CSV, JSON, XML
    • Worksheets
      • Freeze Panes
      • Encrypt Worksheet with Password
      • Add Rows & Columns in Excel C# Docs
      • Create Excel Charts in C#
    • Cell Ranges
      • Write Excel Values in .NET
      • Import Excel Data in C#
      • Merge and Unmerge Cells
      • Edit Excel Files in C#
    • Troubleshooting Guides
      • Apply a license key in IronXL
      • File Size Limits
    • Common Questions
      • IronXL - Security CVE
    • Product Release Notes
      • IronXL v2022.11.10251
      • IronXL v2022.9.9454
      • IronXL v2022.9.8711
      • IronXL v2022.8.8357
      • IronXL v2022.7.7362
      • IronXL v2022.6.6825
      • IronXL v2022.3.0
      • IronXL v2021.12.0
      • IronXL v2021.11.0
    • Changelog
  • API Reference
Create a new Excel File Load Excel Files without Interop Convert Spreadsheet File Types Convert Excel to HTML Edit Excel Metadata in C# Protect Excel Files Excel Print Setup Excel to SQL via System.Data.DataSet Excel to SQL and DataGrid via DataTable Update Excel Database Records Load Excel From SQL Database
Select Excel Range Sort Excel Ranges in C# Excel Formulas in C# Create Excel Chart Auto Adjust Rows & Columns Size Insert New Rows & Columns Repeat Excel Rows & Columns Freeze Panes in Excel Copy Excel Worksheets Group & Ungroup Rows & Columns
Aggregate Excel Functions Combine Excel Ranges Excel Conditional Formatting Excel Number Format Style Excel Cell Borders & Fonts

Load Excel From SQL Database

using IronXL;
using System.Data;
using System.Data.SqlClient;

// Your sql query
string sql = "SELECT * FROM Users";

// Your connection string
string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=usersdb;Integrated Security=True";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    // Open connections to the database
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter(sql, connection);
    DataSet ds = new DataSet();
    // Fill DataSet with data
    adapter.Fill(ds);

    // Create an Excel workbook from the SQL DataSet
    WorkBook workBook = WorkBook.Load(ds);
}
Imports IronXL
Imports System.Data
Imports System.Data.SqlClient

' Your sql query
Private sql As String = "SELECT * FROM Users"

' Your connection string
Private connectionString As String = "Data Source=.\SQLEXPRESS;Initial Catalog=usersdb;Integrated Security=True"

Using connection As New SqlConnection(connectionString)
	' Open connections to the database
	connection.Open()
	Dim adapter As New SqlDataAdapter(sql, connection)
	Dim ds As New DataSet()
	' Fill DataSet with data
	adapter.Fill(ds)

	' Create an Excel workbook from the SQL DataSet
	Dim workBook As WorkBook = WorkBook.Load(ds)
End Using
Install-Package IronXL.Excel

Load Excel From SQL Database

IronXL allows us create an Excel workbook from the SQL DataSet using System.Data.

Related Docs Links

Ready to get started? Version: 2023.2 just released

Start for Free Total downloads: 350,261
View Licenses >
Try IronXL for Free
Get Set Up in 5 Minutes
C# NuGet Library for PDF
Install with NuGet
Version: 2023.2
Install-Package IronXL.Excel
nuget.org/packages/IronXL.Excel/
  1. In Solution Explorer, right-click References, Manage NuGet Packages
  2. Select Browse and search "IronXL"
  3. Select the package and install
C# PDF DLL
Download DLL
Version: 2023.2
Download Now
Manually install into your project
  1. Download and unzip IronXL to a location such as ~/Libs within your Solution directory
  2. In Visual Studio Solution Explorer, right click References. Select Browse, "IronXL.dll"
Licenses from $749

Have a question? Get in touch with our development team.

Now that you’ve downloaded IronXL
Want to deploy IronXL to a live project for FREE?
Not ready to buy?

Want to deploy IronXL to a live project for FREE?

What’s included?
30 days of fully-functional product
Test and share in a live environment
No restrictions in production
Get your free 30-day Trial Key instantly.
Thank you.
If you'd like to speak to our licensing team:
Schedule a call
Have a question? Get in touch with our development team.
No credit card or account creation required
Your Trial License Key has been emailed to you.
Not ready to buy?
Thank you.
View your license options:
Thank you.
If you'd like to speak to our licensing team:
View Licensing
Schedule a call
Have a question? Get in touch with our development team.
Have a question? Get in touch with our development team.
Want to deploy IronXL to a live project for FREE?
Not ready to buy?

Want to deploy IronXL to a live project for FREE?

What’s included?
30 days of fully-functional product
Test and share in a live environment
No restrictions in production
Get your free 30-day Trial Key instantly.
Thank you.
If you'd like to speak to our licensing team:
Schedule a call
Have a question? Get in touch with our development team.
No credit card or account creation required
Your Trial License Key has been emailed to you.
Not ready to buy?
Download IronXL free to apply
your Trial Licenses Key
Thank you.
If you'd like to speak to our licensing team:
Install with NuGet View Licensing
Schedule a call
Licenses from $749. Have a question? Get in touch.
Have a question? Get in touch with our development team.
Free 30-Day Trial Key

Fully-functional product, get the key instantly

IronXL for .NET

The Excel API you need, without the Office Interop hassle.

Search

Documentation

  • Code Examples
  • API Reference
  • How-Tos
  • Features
  • Blog
  • Credits
  • Product Brochure

Tutorials

  • Get Started
  • Read an Excel File in C#
  • Create Excel Files in .NET

Licensing

  • Buy a License
  • Support Extensions
  • Resellers
  • License Keys
  • EULA

Try IronXL Free

  • Download on NuGet
  • Download DLL

  • 30-Day Trial License

When you need your PDF to look like HTML, fast.

Tesseract 5 OCR in the languages you need, We support 127+.

When you need to read, write, and style, QR & Barcodes, fast.

The Excel API you need, without the Office Interop hassle.

The power you need to scrape & output clean, structured data.

The complete .NET Suite for your office.

  • IRONSUITE
  • |
  • IRONPDF
  • IRONOCR
  • IRONBARCODE
  • IRONXL
  • IRONWEBSCRAPER
IronSoftware
205 N. Michigan Ave. Chicago, IL 60611 USA +1 (312) 500-3060
  • About Us
  • News
  • Careers
  • Contact Us
  • Join Iron Slack

Supporting Teamseas

Copyright © Iron Software LLC 2013-2023

  • Terms
  • Privacy

Thank you!

Your license key has been delivered to the email provided. Contact us

24-Hour Upgrade Offer:

Save 50% on a
Professional Upgrade

Go Professional to cover 10 developers
and unlimited projects.

hours

:

minutes

:

seconds

Upgrade to Professional

Upgrade

Professional

$600 USD

$299 USD


  • 10 developers
  • 10 locations
  • 10 projects
TODAY ONLY
Iron Suite

5 .NET Products for the Price of 2

IronPDF IronOCR IronXL IronBarcode IronWebscraper

Total Suite Value:

$7,192 USD

Upgrade price

TODAY
ONLY

$499 USD

After 24 Hrs

$1,098 USD