using var workbook = Workbook.Open("data.xlsx");
var value = workbook.Sheet("Sheet1")?.Cell("B2")?.Value;

using var workbook = Workbook.Open("Book1.xlsx");
var sheet = workbook.Sheet("Sheet1");

// Access by cell address
var cell = sheet?.Cell("A1");
Console.WriteLine(cell?.Value);

// Or by row and column index (1-based)
var value = sheet?.Cell(2, 3)?.Value;

// Get a specific row or column
var row = sheet?.Row(5);
var column = sheet?.Column(2);

// Access cells from a row or column
var cellsInRow = row?.Cells;
var cellsInColumn = column?.Cells;

// Navigate up the hierarchy
var parentSheet = row?.Sheet;
var parentWorkbook = cell?.Row.Sheet.Workbook;

using var workbook = Workbook.Open("report.xlsx");

foreach (var sheet in workbook.Sheets)
{
    Console.WriteLine($"Sheet: {sheet.Name}");

    foreach (var row in sheet.Rows)
    {
        foreach (var cell in row.Cells)
        {
            Console.Write($"{cell.Value}\t");
        }
        Console.WriteLine();
    }
}

// Find non-empty cells
var nonEmpty = sheet.Rows
    .SelectMany(r => r.Cells)
    .Where(c => !string.IsNullOrEmpty(c.Value));

// Get unique values from a column
var uniqueValues = sheet.Column(1)?.Cells
    .Select(c => c.Value)
    .Distinct();

try
{
    using var workbook = Workbook.Open("data.xlsx");
    // Work with the workbook
}
catch (FileNotFoundException ex)
{
    Console.WriteLine($"File not found: {ex.FileName}");
}
catch (IOException ex)
{
    Console.WriteLine($"Error reading file: {ex.Message}");
}

using var workbook = Workbook.Open("data.xlsx", new WorkbookOptions { IncludeHidden = true });

// Now hidden sheets, rows, and columns are accessible
var hiddenSheet = workbook.Sheet("HiddenSheet");

using var workbook = Workbook.Open("large-file.xlsx", new WorkbookOptions { LoadSheets = false });

// Sheet metadata is available, but rows/cells are not yet loaded
var sheet = workbook.Sheet("Sheet1");

// Load the sheet data when needed
sheet?.Open();

using var workbook = Workbook.Open("many-sheets.xlsx", new WorkbookOptions { ParallelLoadSheets = true });

// All sheets are loaded concurrently
foreach (var sheet in workbook.Sheets)
{
    Console.WriteLine($"{sheet.Name}: {sheet.Rows.Count()} rows");
}

// From a file stream
using var stream = File.OpenRead("data.xlsx");
using var workbook = Workbook.Open(stream);

// From a memory stream (e.g., downloaded content)
var bytes = await httpClient.GetByteArrayAsync(url);
using var memoryStream = new MemoryStream(bytes);
using var workbook = Workbook.Open(memoryStream);

var cell = sheet?.Cell("A1");
Console.WriteLine(cell?.Value);  // Output: 2025-12-31

var cell = sheet?.Cell("B2");

var value = cell?.Format switch
{
    NumberFormat.Percentage => double.Parse(cell.Value.TrimEnd('%')) / 100,
    NumberFormat.Currency => decimal.Parse(cell.Value, NumberStyles.Currency),
    NumberFormat.Number => double.Parse(cell.Value),
    _ => null as double?
};