How to Load Existing Spreadsheets in C#

// Ensure you have installed the IronXL library via NuGet package manager first
using IronXL;

class Program
{
    static void Main(string[] args)
    {
        // Set your IronXL license key
        IronXL.License.LicenseKey = "YOUR_LICENSE_KEY";

        // Load an Excel file with the specified path and extension (e.g., 'sample.xlsx')
        WorkBook workbook = WorkBook.Load("sample.xlsx");

        // Iterate over the sheets and print the values for demonstration
        foreach (var sheet in workbook.WorkSheets)
        {
            System.Console.WriteLine($"Sheet Name: {sheet.Name}");

            // Read data from the first sheet
            for (int row = 0; row < sheet.RowCount; row++)
            {
                for (int col = 0; col < sheet.ColumnCount; col++)
                {
                    // Print each cell's value
                    System.Console.Write($"{sheet[row, col].StringValue} \t");
                }
                System.Console.WriteLine();
            }
        }

        // Load a CSV file into a new workbook
        WorkBook csvWorkbook = WorkBook.LoadCSV("sample.csv", fileFormat: ExcelFileFormat.XLSX);

        // Perform data manipulation or analysis as required
        // For example, print out data from the CSV
        var csvSheet = csvWorkbook.DefaultWorkSheet;
        System.Console.WriteLine("Data from CSV:");
        for (int row = 0; row < csvSheet.RowCount; row++)
        {
            for (int col = 0; col < csvSheet.ColumnCount; col++)
            {
                // Print each cell's value
                System.Console.Write($"{csvSheet[row, col].StringValue} \t");
            }
            System.Console.WriteLine();
        }

        // Create a new workbook from a dataset (example logic, implementation may vary)
        var dataSetWorkbook = WorkBook.Create();

        // Assume dataset available to load worksheets, load them as required
        // dataSetWorkbook.LoadWorkSheetsFromDataSet(yourDataSet);

        System.Console.WriteLine("Integration complete, data loaded successfully.");
    }
}

' Ensure you have installed the IronXL library via NuGet package manager first
Imports Microsoft.VisualBasic
Imports IronXL

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Set your IronXL license key
		IronXL.License.LicenseKey = "YOUR_LICENSE_KEY"

		' Load an Excel file with the specified path and extension (e.g., 'sample.xlsx')
		Dim workbook As WorkBook = WorkBook.Load("sample.xlsx")

		' Iterate over the sheets and print the values for demonstration
		For Each sheet In workbook.WorkSheets
			System.Console.WriteLine($"Sheet Name: {sheet.Name}")

			' Read data from the first sheet
			For row As Integer = 0 To sheet.RowCount - 1
				For col As Integer = 0 To sheet.ColumnCount - 1
					' Print each cell's value
					System.Console.Write($"{sheet(row, col).StringValue} " & vbTab)
				Next col
				System.Console.WriteLine()
			Next row
		Next sheet

		' Load a CSV file into a new workbook
		Dim csvWorkbook As WorkBook = WorkBook.LoadCSV("sample.csv", fileFormat:= ExcelFileFormat.XLSX)

		' Perform data manipulation or analysis as required
		' For example, print out data from the CSV
		Dim csvSheet = csvWorkbook.DefaultWorkSheet
		System.Console.WriteLine("Data from CSV:")
		For row As Integer = 0 To csvSheet.RowCount - 1
			For col As Integer = 0 To csvSheet.ColumnCount - 1
				' Print each cell's value
				System.Console.Write($"{csvSheet(row, col).StringValue} " & vbTab)
			Next col
			System.Console.WriteLine()
		Next row

		' Create a new workbook from a dataset (example logic, implementation may vary)
		Dim dataSetWorkbook = WorkBook.Create()

		' Assume dataset available to load worksheets, load them as required
		' dataSetWorkbook.LoadWorkSheetsFromDataSet(yourDataSet);

		System.Console.WriteLine("Integration complete, data loaded successfully.")
	End Sub
End Class