/// <summary>
/// Sets the CsvRow value based on the supplied column name
/// </summary>
/// <param name="row"></param>
/// <param name="columnName"></param>
/// <param name="value"></param>
/// <returns></returns>
public static void SetValue(this CsvRow row, string columnName, string value)
{
var index = row.ColumnNameToIndex[columnName];
row.Values[index] = value;
}
/// <summary>
/// Gets the CsvRow values based on the supplied column names
/// </summary>
/// <param name="row"></param>
/// <param name="columnNames"></param>
/// <returns></returns>
public static string[] GetValues(this CsvRow row, string[] columnNames)
{
var indices = columnNames.Select(n => row.ColumnNameToIndex[n]).ToArray();
return(row.Values.GetIndices(indices));
}
/// <summary>
/// Gets the CsvRow value based on the supplied column name
/// </summary>
/// <param name="row"></param>
/// <param name="columnName"></param>
/// <returns></returns>
public static string GetValue(this CsvRow row, string columnName)
{
return(row.Values[(row.ColumnNameToIndex[columnName])]);
}