使用CSVHelper读取CSV时，如何记录全空记录的行号？

Got it, let's work through this! You've set SkipEmptyRecords = true to skip empty rows, but you also need to track the line numbers of those fully empty records—here's a straightforward way to make that happen.

The Catch With SkipEmptyRecords = true #

When you enable this setting, CSVHelper automatically skips over rows where all fields are empty. That means those rows never make it into your read loop, so you can't capture their line numbers. To fix this, we'll handle the empty row check manually instead of relying on the built-in setting.

Step-by-Step Solution #

1. Turn off automatic empty record skipping so we can process every row.
2. Check each row manually to see if all fields are empty/whitespace.
3. Log the line number for any empty rows we find.
4. Only keep non-empty records in your final list (matching the behavior of SkipEmptyRecords = true).

Here's the code example:

using CsvHelper;
using System.Globalization;
using System.Linq;
using System.Collections.Generic;
using System.IO;

// Initialize a list to store line numbers of empty rows
var emptyLineNumbers = new List<int>();
var validRecords = new List<OrderDetails>();

using (var reader = new CsvReader(new StreamReader("your-order-file.csv"), CultureInfo.InvariantCulture))
{
    // Disable automatic skipping—we'll handle empty rows ourselves
    reader.Configuration.SkipEmptyRecords = false;
    
    // Optional: Register your class map if you're using one
    // reader.Configuration.RegisterClassMap<OrderDetailsMap>();

    // Read the header row first
    reader.Read();
    reader.ReadHeader();

    // Loop through every data row in the CSV
    while (reader.Read())
    {
        // Check if all fields in the current row are empty or whitespace
        var isEmptyRow = reader.Context.Record.All(string.IsNullOrWhiteSpace);

        if (isEmptyRow)
        {
            // Capture the actual line number (CSVHelper counts lines starting at 1)
            emptyLineNumbers.Add(reader.Context.LineNumber);
            continue; // Skip adding this row to valid records
        }

        // Read and store the valid non-empty record
        var orderDetail = reader.GetRecord<OrderDetails>();
        validRecords.Add(orderDetail);
    }
}

// Now you have:
// - validRecords: All non-empty OrderDetails (same result as using SkipEmptyRecords=true)
// - emptyLineNumbers: A list of line numbers for every fully empty row in the CSV

Key Details #

• Line Number Accuracy: reader.Context.LineNumber gives you the real line number from the original file, including the header row. This works even if empty rows are scattered throughout your data.
• Custom Empty Row Logic: If you need to define "empty" as something other than all fields (e.g., only required fields are empty), adjust the isEmptyRow check. For example:

  // Check only specific critical fields for emptiness
  var isEmptyRow = string.IsNullOrWhiteSpace(reader["OrderId"]) && 
                   string.IsNullOrWhiteSpace(reader["ProductName"]);
  

• Dependencies: Make sure you have the necessary using directives, especially System.Linq for the All() method.

内容的提问来源于stack exchange，提问作者Vijayakumar Natarajan