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}");
}

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.

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.