IronXL provides an API allowing us to take system.data.data tables and convert them into Excel workbooks. You will find code examples for doing this within ironxl.com inside the code example section, for code example, is named, "XL to SQL and data grid via data table".

We convert a worksheet into a data table An excel worksheet is a single page or spreadsheet within a workbook. It is a concept within Excel. You see them generally as the tabs at the bottom of an Excel workbook. In IronXL, we can select any worksheet and export it to a data set or data table. There you will find within IronXL,there are worksheet.twodatatable, and workbook.twodataset methods that allow the automatic conversion of Excel into these native system.data objects. This allows us to populate Excel spreadsheets from SQL and also update SQL databases from Excel. It's an incredibly useful, convenient feature of IronXL that allows SQL to be updated and synced with Excel workbooks programmatically in .net applications. We have C# and VB .Net code examples on our website.

IronXL can be used to query an Excel file and take the data across to a data table. Open any Excel workbook in IronXL and then use the to data table function to create a data table. You may then edit that data table before synching with any system data object conventionally in SQL database.

IronXL support worksheets from XLS or XLSX Excel files. IronXL is one of the few .Net Excel libraries, which fully supports XLS and XLSX file formats. It also supports XLSM files, which are XLSX files containing macros without disabling the macros.
The most common type of business situation where we would convert a data table to an Excel file would be where we want to take an existing query on a database and turn it into an Excel file. This could look like a quarterly sales report, an invoice, a customer updater report.

• .NET PGP Library 1.11
  If you need PGP encryption C#, this is a FIPS Compliant Library to Encrypt/Decrypt files or streams with PGP using a single line of code. It also has the ability to generate public and private key pairs. It supports...

• ASPX to PDF 2022.4.557
  The Iron PDF C# & VB .Net software component for ASPX developers provides advanced ASPX to PDF conversion functionality for microsoft.net web, desktop & console applications. Convert HTML and ASPX files to PDF documents with tutorial & code example.

• POWER-KI Developer Edition 11.0.32
  POWER-KI the programming language for Intelligent Applications (IA) 2010-2020 - XPLAB - Research in Automation - Brescia - ITALY POWER-KI establishes a New and Original paradigm for programming languages. Among the most significant features: - separation between Data, Flow, Code; - Plastic Architecture...

• C# Print PDF 2023.1.114
  It also allows us to print PDFs using physical printers. Then within the PDF document class reference, you'll notice a set of print functionality that allow us to print directly to a physical printer, with or without user interface dialog.

• BsPrinter Print Preview for VB6 1.0
  ActiveX component that adds Print Preview capability to Visual Basic 6 programs by replacing the Printer object. Also in Windows 10 it can save PDF files. It is easy to use and can be implemented in existing programs as well as in new developments....

• VB.Net Excel Library 2021.9
  Iron Excel XL plugs into VB.NET applications as a class library, It adds full features for read, write open, edit, export, and import data from Excel within VB.NET applications, including MVC, web, desktop, console applications and server apps.