llms.txt

# PicoXLSX

> A small, dependency-free .NET library to create Microsoft Excel (XLSX) files. Modular plugin architecture: a Core package plus optional Writer, and Formatting plugins. A Reader can be added separately. Targets .NET Standard 2.0 and .NET Framework 4.5+.

PicoXLSX is a meta-package bundling NanoXLSX.Core, NanoXLSX.Writer, and NanoXLSX.Formatting. For read-only applications, use NanoXLSX.Core together with NanoXLSX.Reader separately.

## Installation

- Install via NuGet (Package Manager): `Install-Package PicoXLSX`
- Install via .NET CLI: `dotnet add package PicoXLSX`

## Packages

- [PicoXLSX](https://www.nuget.org/packages/PicoXLSX): PicoXLSX is a library to generate Microsoft Excel files (XLSX) in an easy and native way. This package is the meta package of PicoXLSX and should be used in most cases as dependency in your project. It uses the dependencies of NanoXLSX
- [NanoXLSX.Core](https://www.nuget.org/packages/NanoXLSX.Core): Core library: workbooks, worksheets, cells, styles, colors. Has no external dependencies. (bundled)
- [NanoXLSX.Writer](https://www.nuget.org/packages/NanoXLSX.Writer): Writer plugin: extension methods to save XLSX files. Depends on Core. (bundled)
- [NanoXLSX.Formatting](https://www.nuget.org/packages/NanoXLSX.Formatting): Formatting plugin: in-line cell formatting (rich text). Depends on Core. Maintained in an external repository. (bundled)
- [NanoXLSX.Reader](https://www.nuget.org/packages/NanoXLSX.Reader): Reader plugin: extension methods to load XLSX files. Depends on Core.

## Usage

```csharp
Workbook workbook = new Workbook("myWorkbook.xlsx", "Sheet1");
workbook.CurrentWorksheet.AddNextCell("Some Data");
workbook.CurrentWorksheet.AddNextCell(42);
workbook.CurrentWorksheet.GoToNextRow();
workbook.CurrentWorksheet.AddNextCell(DateTime.Now);
workbook.Save();
```

## API Documentation

- [Combined documentation portal](https://rabanti-github.github.io/PicoXLSX/): All PicoXLSX packages
- [NanoXLSX.Core](https://rabanti-github.github.io/NanoXLSX/NanoXLSX.Core/): Core library: workbooks, worksheets, cells, styles, colors. Has no external dependencies.
- [NanoXLSX.Writer](https://rabanti-github.github.io/NanoXLSX/NanoXLSX.Writer/): Writer plugin: extension methods to save XLSX files. Depends on Core.
- [NanoXLSX.Formatting](https://rabanti-github.github.io/NanoXLSX.Formatting/): Formatting plugin: in-line cell formatting (rich text). Depends on Core. Maintained in an external repository.
- [NanoXLSX.Reader](https://rabanti-github.github.io/NanoXLSX/NanoXLSX.Reader/): Reader plugin: extension methods to load XLSX files. Depends on Core.

## Source

- [PicoXLSX](https://github.com/rabanti-github/PicoXLSX): Primary repository (meta-package, docs)
- [NanoXLSX](https://github.com/rabanti-github/NanoXLSX): Source code (external)
- [NanoXLSX.Formatting](https://github.com/rabanti-github/NanoXLSX.Formatting): Source code (external)

## Optional

- [Demo repository](https://github.com/rabanti-github/NanoXLSX.Demo): Running demo use cases
- [PicoXLSX demo use cases](https://github.com/rabanti-github/NanoXLSX.Demo/tree/main/PicoXLSX/Demo/UseCases): Direct folder with PicoXLSX examples
- [Getting started](https://github.com/rabanti-github/PicoXLSX/wiki/Getting-started): Wiki / getting started guide