public static void WriteToStream(this DataTable dt, StreamWriter sw, bool save_column_names, char delim = DEFAULT_DELIMITER, char qual = DEFAULT_QUALIFIER) #endif { using (CSVWriter cw = new CSVWriter(sw, delim, qual)) { cw.Write(dt, save_column_names); } }
/// <summary> /// Write the data table to a stream in CSV format /// </summary> /// <param name="dt">The data table to write</param> /// <param name="sw">The stream where the CSV text will be written</param> /// <param name="settings">The CSV settings to use when exporting this DataTable (Default: CSV)</param> public static void WriteToStream(this DataTable dt, StreamWriter sw, CSVSettings settings = null) { using (CSVWriter cw = new CSVWriter(sw, settings)) { cw.Write(dt); } }
public static string WriteToString(this DataTable dt, bool save_column_names, char delim = DEFAULT_DELIMITER, char qual = DEFAULT_QUALIFIER) #endif { using (var ms = new MemoryStream()) { var sw = new StreamWriter(ms); var cw = new CSVWriter(sw, delim, qual); cw.Write(dt, save_column_names); sw.Flush(); ms.Position = 0; using (var sr = new StreamReader(ms)) { return(sr.ReadToEnd()); } } }
/// <summary> /// Write a DataTable to a string in CSV format /// </summary> /// <param name="dt">The datatable to write</param> /// <param name="settings">The CSV settings to use when exporting this DataTable (Default: CSV)</param> /// <returns>The CSV string representing the object array.</returns> public static string WriteToString(this DataTable dt, CSVSettings settings = null) { using (var ms = new MemoryStream()) { var sw = new StreamWriter(ms); var cw = new CSVWriter(sw, settings); cw.Write(dt); sw.Flush(); ms.Position = 0; using (var sr = new StreamReader(ms)) { return(sr.ReadToEnd()); } } }
public static string WriteToString(this DataTable dt, CSVSettings settings = null) #endif { if (settings == null) { settings = CSVSettings.CSV; } using (var ms = new MemoryStream()) { var cw = new CSVWriter(ms, settings); cw.Write(dt); var rawString = settings.Encoding.GetString(ms.ToArray()); return(CSV.RemoveByteOrderMarker(rawString)); } }