Universal.Common.Data 3.2.0

Universal.Common.Data

File and spreadsheet reading utilities that provide consistent APIs for accessing data.

Quickstart

DelimitedFileReader

A reader for CSV and other delimited files with support for typed value extraction and column mapping.

// Read a CSV file with headers
using (var reader = new DelimitedFileReader("data.csv", DelimitedFileFormat.CommaSeparatedValues))
{
    while (reader.Read())
    {
        // Access by column name
        string name = reader["Name"];
        int age = reader.Get<int>("Age");
        
        // Access by index
        string firstColumn = reader[0];
        double value = reader.Get<double>(1);
        
        // Custom mapping function
        DateTime date = reader.Get("Date", s => DateTime.Parse(s));
    }
}

SpreadsheetReader

A reader for Excel spreadsheets (.xlsx) with support for header rows and optimized cell access.

// Configure reader options
var options = new SpreadsheetReader.Options
{
    HasHeaderRow = true,
    LoadRowsEagerly = true,
    SheetName = "Sheet1"  // Optional, reads first sheet if not specified
};

// Read an Excel file
using (var reader = new SpreadsheetReader("data.xlsx", options))
{
    while (reader.Read())
    {
        // Access by column name (if header row enabled)
        string name = reader.GetText("Name");
        
        // Access by column index
        string value = reader.GetText(0);
        
        // Access raw cell for additional properties
        Cell cell = reader.GetCell("Status");
    }
}