TsadriuUtilities.Csv 1.1.1

TsadriuUtilities.Csv

A small package that parses an CSV.

TsadriuUtilities.Csv is a library that helps on dealing with CSV files, to make it easier and save a little bit of time.

> Features <

CsvTable:

→ To create a new instance, use ICsvTable table = new CsvTable(string[] csvLines, string delimiter = ";") + 5 overload;

• CultureInfo CultureInfo { get; set; }
  • Gets or sets the culture of this table. Setting this property will apply the culture on all elements of the ColumnList.
• string Delimiter { get; set; }
  • Gets or sets the delimiter used on the csv file.
• List<ICsvColumn> ColumnList { get; set; }
  • Gets or sets the list of ICsvColumn of the current ICsvTable.
• AddColumn(string columnName, int index = -1):
  • Adds a new column to the ColumnList.
• ICsvColumn GetColumn(string columnName, StringComparison comparison):
  • Checks if the columnName exists in the ColumnList, returning the first instance found. If it doesn't exist, it return a new CsvColumn with the name UNDEFINED.
• MoveColumn(int oldIndex, int newIndex) + 1 overload:
  • Moves the position of this column with another column.
• RemoveColumn(int[] columnIndex) + 1 overload:
  • Removes a column from the ColumnList.
• List<string> ToList():
  • Converts the ICsvTable into a List<string>.

CsvColumn:

→ To create a new instance, use ICsvColumn column = new CsvColumn();

• string Name { get; set; }
  • Gets or sets the column name.
• CultureInfo CultureInfo { get; set; }
  • Gets or sets the culture info.
• bool IsVisible { get; set; }
  • Gets or sets the visibility of a Sheet.
• List<string> RowList { get; set; }
  • Gets or sets the row list.
• NormalizeNumbers(CultureInfo? culture):
  • Normalizes the numbers of the RowList by using the CultureInfo.
• ChangeDateFormat(string oldDateFormat, string newDateFormat):
  • Parses the RowList with the oldDateFormat to a DateTime and converts it back to a string using the newDateFormat.

CsvHelper:

• ReadMultipleHeaderCsv(istring[] csvLines, string delimiter, int[] headerPosition) + 1 overload:
  • Helps on reading a csv that has multiple headers.
• ToList(List<ICsvTable> tableList):
  • Converts a List of ICsvTable into a csv.