QuickCsv.Net 1.1.1

CSV_Helper_Project

A csv library for loading/saving csv files relatively quickly and easily. This repository serves as a quick csv parser and editor, supporting the CSV standard, including multi-line cell values. As with all my projects, this library is focused on simplicity and speed. Test it for your own purposes.

Features

• CSV Standard Compliance: Supports standard CSV format, including multiline cell values.
• Ease of Use: Simplified methods for common CSV operations.
• Column Operations: Adding, removing, and renaming columns.
• Header Management: Handling headers and accessing cells by column name.
• Custom Delimiters: Support for custom delimiters in CSV files.
• Encoding Flexibility: Support for various non-standard encodings.
• Record Manipulation: Adding, removing, and inserting records.
• Streaming Records: Stream CSV records from a file, yielding one record at a time with StreamCsvRecords.
• Writing Records: Write a single CSV record to an open StreamWriter with WriteCsvRecord.

Not Supported Yet

• Automatic cell-to-type (e.g., cell → double) parsing.
• Automatic recognition of headers, encoding, and delimiter types.
• Automatic data type proofing (this is a string library for IO purposes).

Sample Usage

Creating and Writing to a Table

// create Table
Table allRunResults = new CSVHelper.Net.Table();
allRunResults.SetColumnNames(new[] { "ChestName", "Start Invest", ... });

// add data records
foreach (RunResult result in results)
{
    int index = allRunResults.AppendEmptyRecord();
    allRunResults.SetCell("ChestName", index, result.ChestName);
    allRunResults.SetCell("Start Invest", index, startCash.ToString());
    allRunResults.SetCell("Average Wagered Coins", index, result.WageredCoins.ToString());
    allRunResults.SetCell("Average Survived Rounds", index, result.BettingRounds.ToString());
    allRunResults.SetCell("Max Balance", index, result.MaxBalance.ToString());
}
// save the Table
allRunResults.WriteTableToFile("sample.csv");

reading from a table

Table allRunResults = new CSVHelper.Net.Table();
allRunResults.LoadFromFile("path/to/file.csv", hasHeaders: true);

RunResult[] results = new RunResult[allRunResults.Length];
for (int i = 0; i < allRunResults.Length; i++)
{
    results[i] = new RunResult() 
    { 
        ChestName = runs.GetCell(i, "ChestName"),
        BettingRounds = double.Parse(runs.GetCell(i, "Average Survived Rounds")),
        WageredCoins = double.Parse(runs.GetCell(i, "Average Wagered Coins")),
        MaxBalance = double.Parse(runs.GetCell(i, "Max Balance"))
    };
}

modify a table

Table table = new Table();

// Set the column names of the table
string[] columnNames = new string[] { "ID", "Name", "Email" };
table.SetColumnNames(columnNames);

// Add a new record to the table
string[] record1 = new string[] { "1", "John Smith", "john@example.com" };
table.AppendRecord(record1);

// Add another record to the table
string[] record2 = new string[] { "2", "Jane Doe", "jane@example.com" };
table.AppendRecord(record2);

// Insert an empty record at the beginning of the table
table.InsertEmptyRecord(0);

// Remove the second record from the table
table.RemoveRecord(1);

// Overwrite the first record with new values
string[] updatedRecord = new string[] { "1", "John Doe", "john.doe@example.com" };
table.OverwriteOrInsertRecord(updatedRecord, "ID");

// Search for a record with the email "jane@example.com" and remove it if it exists
LookupValue lookup = new LookupValue("jane@example.com", "Email");
table.RemoveRecordIfExists(lookup);

streaming and writing directly to a csv file

var parser = new CSV_Helper_Project.Parser();
foreach (var record in parser.StreamCsvRecords("path/to/your/file.csv"))
{
    // Process each record here
}

using (var writer = new StreamWriter("path/to/your/output.csv"))
{
    var record = new string[] { "Field1", "Field2", "Field3" };
    parser.WriteCsvRecord(writer, record);
}