ExcelDataReader/ExcelDataReader
ExcelDataReader
ExcelDataReader is a C# library used to extract data and metadata from Microsoft Excel spreadsheets and CSV files. It functions as a workbook parser that converts spreadsheet content into structured data sets for programmatic access and iteration.
The project includes a specialized metadata extractor for retrieving cell-level details, such as number formats, styles, row heights, column widths, and merged cell ranges. It also provides a stream processor for parsing plain text CSV files with customizable encoding and separator detection.
The library supports the OpenXML standard for modern spreadsheet files and utilizes stream-based parsing and cursor-based row iteration to traverse workbooks. These capabilities allow for the conversion of multi-sheet workbooks into relational data tables.
Features
- Excel Parsers - Extracts data from various Microsoft Excel formats and versions to retrieve spreadsheet content.
- Workbook Readers - Opens and reads Excel files in both older .xls and newer .xlsx formats without requiring Microsoft Office.
- CSV File Processing - Processes plain text streams using comma separated values with customizable encoding and separator detection.
- Excel Data Import - Reads .xls and .xlsx files into structured tables for importing data into other applications.
- Excel File Parsers - A library for extracting data and metadata from Microsoft Excel spreadsheets and CSV files using C#.
- OpenXML Implementations - Interprets the compressed XML structure of modern spreadsheet files to extract cell values and metadata.
- Streaming CSV Loaders - Parses plain text streams using comma separated values with customizable encoding and separator detection.
- Stream-Based Parsing - Processes large binary files sequentially using stream-based parsing to reduce memory overhead.
- DataSet Conversions - Populates a structured data set from an Excel workbook to ensure fast and efficient data access.
- Excel Layout Metadata - Retrieves cell-level details including number formats, styles, row heights, and merged cell ranges.
- Structural Metadata Extraction - Captures formatting and structural properties alongside raw cell values during the parsing process.
- Cursor-Based Iteration - Provides a cursor-based mechanism to traverse rows and sheets without loading the entire workbook into memory.
- Workbook Navigation - Iterates through sheets and rows using a cursor to retrieve field counts, row counts, and sheet names.
- Automatic Delimiter Detection - Identifies field separators in plain text CSV files by analyzing character frequency within the input stream.
- Relational Table Mappings - Transforms hierarchical spreadsheet structures into relational data tables for easier querying and manipulation.
- Spreadsheet Metadata Extraction - Extracts cell styles, number formats, and layout details like merged ranges and column widths from Excel files.
- Spreadsheet Layout Metadata - Provides access to cell-level details including number formats, styles, row heights, column widths, and merged cell ranges.
- Application Frameworks - Fast library for reading Microsoft Excel files.
- Office Automation - Lightweight and fast library for reading legacy Excel files.
Star history
How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.
