docs/index.rst
ClosedXML
ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.
Install the library through .NET CLI
.. code-block:: batch
C:\source> dotnet add package ClosedXML
ClosedXML allows you to create Excel files without the Excel application. The typical example is creating Excel reports on a web server.
.. code-block:: csharp
using var workbook = new XLWorkbook(); var worksheet = workbook.AddWorksheet("Sample Sheet"); worksheet.Cell("A1").Value = "Hello World!"; worksheet.Cell("A2").FormulaA1 = "MID(A1, 7, 5)"; workbook.SaveAs("HelloWorld.xlsx");
.. note:: These docs are very much a work in progress. If you'd like to contribute, click on the Edit on GitHub link in the right top corner.
.. toctree:: :maxdepth: 1 :caption: Quick Start
installation
.. toctree:: :maxdepth: 2 :caption: Concepts
concepts/types concepts/formula-calculation concepts/function-evaluation
.. toctree:: :maxdepth: 4 :caption: Features
features/worksheets features/bulk-insert-data features/tables features/cell-format features/sort features/autofilter features/pivot-tables features/protect features/formulas features/functions features/graphic-engine features/themes
.. toctree:: :maxdepth: 3 :caption: Tips & tricks
tips/missing-font
.. toctree:: :maxdepth: 3 :caption: Migrations
migrations/migrate-to-0.100 migrations/migrate-to-0.101 migrations/migrate-to-0.102 migrations/migrate-to-0.103 migrations/migrate-to-0.104 migrations/migrate-to-0.105 migrations/migrate-to-0.106
.. toctree:: :maxdepth: 2 :caption: API Reference
api/index api/autofilter api/workbook api/worksheet api/cell