nissl-lab/npoi

Features

• Excel Spreadsheet Management - Creates, modifies, and reads Excel spreadsheets in .xls and .xlsx formats without requiring Microsoft Office or COM interop.
• Office Document Libraries - Provides a pure .NET library for reading and writing Microsoft Office binary and OpenXML formats.
• Managed Code Office Parsers - Reads and writes Office binary and XML formats using only managed .NET code with no COM or native interop.
• OpenXML Spreadsheet Writers - Reads and writes the Office Open XML format used by Excel 2007 and later (.xlsx) to create, edit, and save spreadsheets.
• OpenXML Manipulation - Navigates Office Open XML .xlsx/.docx files as ZIP packages, parsing XML parts into in-memory object models.
• Binary Record Stream Parsers - Provides a BIFF record stream model for parsing legacy .xls binary files.
• OpenXML Document Writers - Reads and writes the Office Open XML format used by Word 2007 and later (.docx) to create, edit, and save documents.
• Office - Reads and writes Microsoft Office formats without requiring Office or COM interop.
• Office and Documents - Reads and writes Microsoft Office binary and OpenXML formats without requiring Office or COM interop.
• Office Automation - Runs Office file operations on Windows and Linux under .NET Standard and .NET Framework runtimes.
• Workbook Readers - Opens and reads Excel files in both .xls and .xlsx formats without requiring Microsoft Office.
• Spreadsheet Data Writing - Creates and saves Excel spreadsheets in .xls or .xlsx format, supporting large row and column limits.
• Word Processing Libraries - Creates, modifies, and reads Word .docx files programmatically without requiring Microsoft Office.
• Word Document Management - Creates, modifies, and reads Word documents in .docx format without requiring Microsoft Office or COM interop.
• OLE2 Compound Document Readers - Opens legacy .xls files by reading OLE2 compound storage structures.
• Legacy Spreadsheet Parsers - Reads and writes the binary BIFF format used by Excel 97-2003 (.xls) to create, edit, and save spreadsheets.
• File Read and Write Operations - Provides programmatic reading and writing of Word .docx files without requiring Microsoft Office.
• Spreadsheet Formula Engines - Evaluates Excel formulas programmatically to compute cell values without opening the spreadsheet application.
• Formula Dependency Resolution - Computes cell formulas by building a directed graph of cell dependencies and evaluating them in topological order.
• Spreadsheet Cell Formatting - Applies formatting, data types, and formulas to spreadsheet cells for rich document generation.
• Spreadsheet Row Streaming - Reads large .xlsx files by iterating rows from the XML sheet part without loading the entire workbook into memory.
• .NET Frameworks - Runs on Windows and Linux under .NET Standard and .NET Framework runtimes.
• Cross-Platform Runtimes - Operates on Windows and Linux under .NET Standard and .NET Framework runtimes.
• Template Population - Populates Word document tables from object collections using a template-based mapper.
• Spreadsheet-to-Object Mappers - Maps class properties to Excel columns for reading and writing rows as strongly-typed objects.
• Word Table Object Mappers - Populates Word document tables from object collections using a template-based mapper library.
• Document Template Object Mappers - Populates Word tables or Excel rows by matching class property names to placeholder markers in a document template.

Star history