Oakrey.Excel

1. Overview

The Excel project provides a framework for reading and interacting with Excel spreadsheets. It simplifies the process of extracting data from Excel files by offering classes to represent cells and sheets, leveraging the OpenXML SDK.

2. Features

Excel Cell Representation:

ExcelCell:

• Represents a single cell in an Excel sheet with properties for row index, column index, and value.
• Provides a ToString method for easy debugging and display.

Excel Sheet Management:

ExcelSheet:

• Represents an entire Excel sheet and provides methods to:
  • Retrieve rows and columns.
  • Access cell values with or without default values.
  • Parse and load data from an Excel file.
  • Handles shared strings, boolean values, and cell references using OpenXML.

Integration with OpenXML:

Utilizes the OpenXML SDK to read Excel files, parse cell data, and manage shared string tables.

Error Handling and Validation:

Includes error handling for null references and invalid operations, ensuring reliable data extraction.

3. Installation

You can install the package via NuGet Package Manager, Package Manager Console or the .NET CLI.

NuGet Package Manager

1. Open your project in Visual Studio.
2. Navigate to Tools > NuGet Package Manager > Manage NuGet Packages for Solution....
3. Search for Oakrey.Excel and click Install.

.NET CLI

Run the following command in your terminal:

dotnet add package Oakrey.Excel

Package Manager Console

Run the following command in your Package Manager Console:

Install-Package Oakrey.Excel

4. Requirements

• .NET 8 or higher

5. Project Information

• Author: Oakrey
• Company: Oakrey (Website Link)
• License: MIT
• Repository: Git Repository
• Project URL: Project Website

6. Contributing

Contributions are welcome! Feel free to open issues or submit pull requests to improve the package.

7. License

This project is licensed under the MIT License. See the LICENSE file for details.