private static void testXls() { var xlsParser = TabularDataParser.CreateForExcelFile(@"..\..\..\TestFiles\TewlTestBook.xlsx"); var validationErrors = new List <ValidationError>(); xlsParser.ParseAndProcessAllLines(importThing, validationErrors); Console.WriteLine($"Excel test: {xlsParser.RowsWithoutValidationErrors} rows imported without error."); }
private static void testCsv() { var csvParser = TabularDataParser.CreateForCsvFile(@"..\..\..\TestFiles\TewlTestBook.csv", true); var validationErrors = new List <ValidationError>(); csvParser.ParseAndProcessAllLines(importThing, validationErrors); Console.WriteLine($"CSV test: {csvParser.RowsWithoutValidationErrors} rows imported without error."); }
public void TestReadCsvEmptyLines() { string input = "r1c1,,\r\n" + ",,\r\n" + "r3c1,,"; var output = new TabularDataParser(TabularDataFormat.CreateCsv()).Read(input); Assert.AreEqual("r1c1", output[0][0], "Row 1 column 1"); Assert.AreEqual(String.Empty, output[0][2], "Row 1 column 3"); Assert.AreEqual("r3c1", output[2][0], "Row 3 column 1"); }
public void TestWriteCsv() { string output; string expectedOutput = "foo,bar,baz\r\n" + "wibble,wobble,spong"; IList <IList <string> > input = new string[][] { new string[] { "foo", "bar", "baz" }, new string[] { "wibble", "wobble", "spong" } }; ITabularDataParser parser = new TabularDataParser(TabularDataFormat.CreateCsv()); output = parser.Write(input); Assert.AreEqual(expectedOutput, output, "Correct string rendering"); }
public void TestReadCsv() { string input = "foo,bar,baz\r\n" + "wibble,wobble,spong"; ITabularDataParser parser = new TabularDataParser(TabularDataFormat.CreateCsv()); var output = parser.Read(input); Assert.AreEqual(2, output.GetRowCount(), "Correct row count"); Assert.AreEqual("wibble", output[1][0], "Correct data in second row, first column"); Assert.AreEqual("wobble", output[1][1], "Correct data in second row, second column"); }
public void TestWriteTsvWithQuotes() { string output; string expectedOutput = "foo\tbar\tbaz\n" + "wibble\t wobble \tspong\n" + " foo\t\"bar\"\tbaz,bork"; IList <IList <string> > input = new string[][] { new string[] { "foo", "bar", "baz" }, new string[] { "wibble", " wobble ", "spong" }, new string[] { " foo", "\"bar\"", "baz,bork" } }; ITabularDataParser parser = new TabularDataParser(TabularDataFormat.CreateTsv()); output = parser.Write(input); Assert.AreEqual(expectedOutput, output, "Correct string rendering"); }
public void TestReadCsvWithQuotedUnicode() { string input = "foo,bar,baz\r\n" + "wibble, wobble ,spong\r\n" + "\" foo\",\"\"\"bar\"\"\",\"A big, \"\"big, ¥en test!\""; ITabularDataParser parser = new TabularDataParser(TabularDataFormat.CreateCsv()); var output = parser.Read(input); Assert.AreEqual(3, output.GetRowCount(), "Correct row count"); Assert.AreEqual("wobble", output[1][1], "Correct data in second row, second column"); Assert.AreEqual(" foo", output[2][0], "Correct data in third row, first column"); Assert.AreEqual("\"bar\"", output[2][1], "Correct data in third row, second column"); Assert.AreEqual("A big, \"big, ¥en test!", output[2][2], "Correct data in third row, third column"); }
public void TestWriteTsvFrom2DArray() { string output; string expectedOutput = "foo\tbar\tbaz\n" + "wibble\twobble\tspong"; string[,] input = new string[, ] { { "foo", "bar", "baz" }, { "wibble", "wobble", "spong" } }; ITabularDataParser parser = new TabularDataParser(TabularDataFormat.CreateTsv()); output = parser.Write(input); Assert.AreEqual(expectedOutput, output, "Correct string rendering"); }
public void TestReadCsvTolerateTrailingLines() { // Arrange string input = "r1c1,,\r\n" + "r3c1,,\r\n" + "\r\n"; // Act var format = TabularDataFormat.CreateCsv(tolerateEmptyRows: true); var output = new TabularDataParser(format).Read(input); // Assert Assert.AreEqual(2, output.GetRowCount(), "Row count"); Assert.AreEqual(3, output.GetColumnCount(), "Column count"); Assert.AreEqual("r1c1", output[0][0], "Row 1 column 1"); Assert.AreEqual("r3c1", output[1][0], "Row 2 column 1"); }