/// <summary>
/// Converts an IEnumerable to a delimited file
/// </summary>
/// <param name="Data">The DataTable to convert</param>
/// <param name="Delimiter">Delimiter to use</param>
/// <returns>The delimited file containing the list</returns>
public static GenericDelimited.GenericDelimited ToDelimitedFile(this DataTable Data, string Delimiter = "\t")
{
GenericDelimited.GenericDelimited ReturnValue = new GenericDelimited.GenericDelimited(Delimiter);
if (Data == null)
{
return(ReturnValue);
}
Delimited.Row TempRow = new Delimited.Row(Delimiter);
foreach (DataColumn Column in Data.Columns)
{
TempRow.Add(new Delimited.Cell(Column.ColumnName));
}
ReturnValue.Add(TempRow);
foreach (DataRow Row in Data.Rows)
{
TempRow = new Delimited.Row(Delimiter);
for (int x = 0; x < Data.Columns.Count; ++x)
{
TempRow.Add(new Delimited.Cell(Row.ItemArray[x].ToString()));
}
ReturnValue.Add(TempRow);
}
return(ReturnValue);
}
/// <summary>
/// Converts an IEnumerable to a CSV file
/// </summary>
/// <param name="Data">The DataTable to convert</param>
/// <returns>The CSV file containing the list</returns>
public static CSV.CSV ToCSV(this DataTable Data)
{
CSV.CSV ReturnValue = new CSV.CSV();
if (Data.IsNull())
{
return(ReturnValue);
}
Delimited.Row TempRow = new Delimited.Row(",");
foreach (DataColumn Column in Data.Columns)
{
TempRow.Cells.Add(new Delimited.Cell(Column.ColumnName));
}
ReturnValue.Rows.Add(TempRow);
foreach (DataRow Row in Data.Rows)
{
TempRow = new Delimited.Row(",");
for (int x = 0; x < Data.Columns.Count; ++x)
{
TempRow.Cells.Add(new Delimited.Cell(Row.ItemArray[x].ToString()));
}
ReturnValue.Rows.Add(TempRow);
}
return(ReturnValue);
}
