CsvEditSharp is a CSV editor that describes read / write settings with C # script.

In the script, write read / write settings using API of “CsvHelper” which is a open source .Net class library.

[Script example]

/* Get the API object that can be used in this script */
ICsvEditSharpApi api = GetCsvEditSharpApi();

/* Encoding of CSV file */
api.Encoding = Encoding.GetEncoding(“utf-8”);

/* Configuration settings for CSV Helper */
api.CsvConfiguration = new CsvConfiguration( CultureInfo.GetCultureInfo(“en-US”))
{
HasHeaderRecord = true
};

/*****************************
Definition of record class
*****************************/
class FieldData
{
public string Name { get; set; }
[Format(“d”)]
public DateTime Birthday { get; set; }
public Gender Gender { get; set; }
public bool Married { get; set; }
[NumberStyles(NumberStyles.Currency)]
[Format(“C”)]
public decimal PocketMoney { get; set; }
}

/****************************************
Define the enum type of selection item
****************************************/
enum Gender
{
Male,
Female,
Other
}

/**********************************************
Register auto class maps in CSV reader/writer
**********************************************/
api.RegisterClassMap();

/************************
Add custom validations
************************/
api.AddValidation<FieldData,DateTime>(
m => m.Birthday,
dt => dt.Date < DateTime.Now.Date,
“Cannot enter a future date.”);

api.AddValidation<FieldData, decimal>(
m => m.PocketMoney,
n => n > 0 && n < 10000,
“PocketMoney must be in the range $0 to $10000.”);

For details of APIs that can be used in scripts, see below.
[GitHub]
https://github.com/pierre3/CsvEditSharp

[CsvHelper]
https://joshclose.github.io/CsvHelper/