/// <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); }