How to Load Existing Spreadsheets

using IronXL; // Import the IronXL library for working with Excel files.

// Instead of loading the workbook without error handling, wrap it in a try-catch block for safety.
try
{
    // Load an Excel workbook from a file. The IronXL library supports various file formats including XLSX, XLS, XLSM, XLTX, CSV, and TSV.
    WorkBook workBook = WorkBook.Load("sample.xlsx");

    // At this point, 'workBook' is an instance of the loaded workbook.
    // You can now proceed to manipulate the workbook, such as accessing worksheets, reading data, etc.
    
    // Example: Accessing the first worksheet
    WorkSheet sheet = workBook.WorkSheets.First();

    // You might want to perform operations like iterating over rows, reading cell values, etc.
    
    // Example: Reading a value from a specific cell
    string cellValue = sheet["A1"].Text;

    // Optionally, output the value from the specified cell to confirm reading was successful
    Console.WriteLine($"The value in cell A1 is: {cellValue}");
}
catch (Exception ex)
{
    // It's a good practice to handle exceptions in case the workbook file doesn't exist or there's an issue with reading it.
    Console.WriteLine($"An error occurred while loading or processing the workbook: {ex.Message}");
}

Imports IronXL ' Import the IronXL library for working with Excel files.



' Instead of loading the workbook without error handling, wrap it in a try-catch block for safety.

Try

	' Load an Excel workbook from a file. The IronXL library supports various file formats including XLSX, XLS, XLSM, XLTX, CSV, and TSV.

	Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")



	' At this point, 'workBook' is an instance of the loaded workbook.

	' You can now proceed to manipulate the workbook, such as accessing worksheets, reading data, etc.



	' Example: Accessing the first worksheet

	Dim sheet As WorkSheet = workBook.WorkSheets.First()



	' You might want to perform operations like iterating over rows, reading cell values, etc.



	' Example: Reading a value from a specific cell

	Dim cellValue As String = sheet("A1").Text



	' Optionally, output the value from the specified cell to confirm reading was successful

	Console.WriteLine($"The value in cell A1 is: {cellValue}")

Catch ex As Exception

	' It's a good practice to handle exceptions in case the workbook file doesn't exist or there's an issue with reading it.

	Console.WriteLine($"An error occurred while loading or processing the workbook: {ex.Message}")

End Try

using IronXL;

// This code demonstrates how to load a CSV file using the IronXL library.
// IronXL must be installed via NuGet package manager in your project to work with WorkBook class.

// Load a CSV file into a WorkBook object. The path to the CSV file is specified as "sample.csv".
// Ensure "sample.csv" is present in the project directory or provide the correct path to the file.
WorkBook workBook = WorkBook.LoadCSV("sample.csv");

// At this point, the CSV file is loaded into the `workBook` object.
// You can now perform various operations on the loaded data, such as reading or modifying cell values.

Imports IronXL



' This code demonstrates how to load a CSV file using the IronXL library.

' IronXL must be installed via NuGet package manager in your project to work with WorkBook class.



' Load a CSV file into a WorkBook object. The path to the CSV file is specified as "sample.csv".

' Ensure "sample.csv" is present in the project directory or provide the correct path to the file.

Private workBook As WorkBook = WorkBook.LoadCSV("sample.csv")



' At this point, the CSV file is loaded into the `workBook` object.

' You can now perform various operations on the loaded data, such as reading or modifying cell values.

using IronXL;
using System.Data;

// This code demonstrates how to create an Excel workbook from a DataSet using IronXL,
// a .NET library for working with Excel files.

// Create a new DataSet to hold data tables, which provides in-memory data storage.
DataSet dataSet = new DataSet();

// Example of adding a DataTable to the DataSet for demonstration.
// In an actual implementation, populate the DataSet with real data tables.
DataTable table = new DataTable("SampleTable");
dataSet.Tables.Add(table);

// Create a new WorkBook using IronXL. This will represent an Excel workbook.
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);

// Load worksheets into the WorkBook from the DataSet.
// Each DataTable in the DataSet will result in a new worksheet in the WorkBook.
workBook.LoadWorkSheetsFromDataSet(dataSet);

// Add comments to clarify:
// - If the DataSet is empty, the WorkBook will be created without any worksheets.
// - Ensure that the DataSet is populated with one or more tables to have data reflected in the workbook.

Imports IronXL

Imports System.Data



' This code demonstrates how to create an Excel workbook from a DataSet using IronXL,

' a .NET library for working with Excel files.



' Create a new DataSet to hold data tables, which provides in-memory data storage.

Private dataSet As New DataSet()



' Example of adding a DataTable to the DataSet for demonstration.

' In an actual implementation, populate the DataSet with real data tables.

Private table As New DataTable("SampleTable")

dataSet.Tables.Add(table)



' Create a new WorkBook using IronXL. This will represent an Excel workbook.

Dim workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)



' Load worksheets into the WorkBook from the DataSet.

' Each DataTable in the DataSet will result in a new worksheet in the WorkBook.

workBook.LoadWorkSheetsFromDataSet(dataSet)



' Add comments to clarify:

' - If the DataSet is empty, the WorkBook will be created without any worksheets.

' - Ensure that the DataSet is populated with one or more tables to have data reflected in the workbook.