public void SimpleCommaWrite() { MemoryStream stream = new MemoryStream(); CsvFileWriter writer = new CsvFileWriter(stream); writer.WriteRow(new [] {"one", "two", "three"}); StreamReader reader = new StreamReader(stream); stream.Position = 0; Assert.AreEqual("one,two,three", reader.ReadLine()); }
public void SpecialCharInValue() { MemoryStream stream = new MemoryStream(); CsvFileWriter writer = new CsvFileWriter(stream); writer.WriteRow(new[] { "one,two", "t\"h\"\"ree" }); StreamReader reader = new StreamReader(stream); stream.Position = 0; Assert.AreEqual("\"one,two\",\"t\"\"h\"\"\"\"ree\"", reader.ReadLine()); }
public void Export(string filePath, DataSet dataSet) { if(string.IsNullOrEmpty(filePath)) throw new ArgumentException("Empty filename for export"); using(FileStream stream = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.Write)) { CsvFileWriter writer = new CsvFileWriter(stream); DataTable table = dataSet.Tables[0]; foreach (DataRow row in table.Rows) { object[] rowItems = row.ItemArray; string[] items = rowItems.Select(i => i.ToString()) .ToArray(); writer.WriteRow(items); } } }