# ExcelLibrary

**Repository Path**: MHC/ExcelLibrary

## Basic Information

- **Project Name**: ExcelLibrary
- **Description**: No description available
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2017-07-15
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# ExcelLibrary

This is a small C# library made to simplify reading from and writing to Excel workbooks in the Open XML file format (.xlsx). Here's an example to get you started:

```C#
Workbook workbook = new Workbook();
workbook.Open("Book1.xlsx");
Sheet sheet = workbook.Sheet("Sheet1");
Row row = sheet.Row(2);
Cell cell = row.Cell(3);
string text = cell.Value;
```

See the wiki for more examples.

## Features

* No dependencies except .NET Framework 4.5. Easy to include in other solutions.
* Built and extendable with LINQ. Most collections in the library (e.g. `Workbook.Sheets` or `Row.Cells`) is of type `IEnumerable<T>`, which  allows you to use LINQ queries to find exactly what you need.
* Respects the visibility of sheets, rows and columns. Set the `IncludeHidden` option to `true`to return hidden objects.
* Well-tested. The library is being developed using principles of Test-driven development (TDD). A large set of unit tests verifies that new bugs are not introduced on code changes.
* Well-documented. A software library is only as useful as its documentation.

## Limitations

The following things have been considered outside the scope of the project:

* All file formats except `.xslx`.
* Formulas
* Formatting properties

The following things are planned but not yet implemented features:

* All write functionality (writing to cells, adding new sheets, adding and deleting rows and columns and so on).

Also, the library will not create new workbooks _per se_, but the same can be achieved by including a template workbook in your project and copy it whenever you need to create a workbook.

For more on project status, see the [Current status](../../wiki/Current-status) page in the wiki.