public void ExportCSVTest()
{
//Write data to CSV
var data =
Enumerable.Range(0, 10)
.Select(row => Enumerable.Range(0, 10).Select(col => row + col).Cast <object>().ToArray())
.ToArray();
var fn = GetNewFileNameOnTempPath(".csv");
ImportExport.ExportCSV(fn, data);
//Confirm it's correct
Assert.AreEqual(data, ImportExport.ImportCSV(fn));
}
public static void ImportCSVWithTransposeTest()
{
string filePath = Path.Combine(TestDirectory, @"core\importExport\test2.csv");
var CSVList = ImportExport.ImportCSV(filePath, true);
Assert.AreEqual(CSVList, new List <object> {
new List <object> {
1.2, 5.6, 7, 155
},
new List <object> {
2, 0.009, 10, 3.3
},
new List <object> {
null, 3, 3, null
}
});
}
public static void ImportCSVTest()
{
string filePath = Path.Combine(TestDirectory, @"core\importExport\test1.csv");
var CSVList = ImportExport.ImportCSV(filePath);
Assert.AreEqual(CSVList, new List <object> {
new List <object> {
2, 3, 4
},
new List <object> {
4, 6, 8
},
new List <object> {
6, 9, 12
},
new List <object> {
8, 12, 16
}
});
}
public static void ImportCSV_PathTest()
{
string filePath = Path.Combine(TestDirectory, @"core\importExport\not a valid file.csv");
Assert.Throws <FileNotFoundException>(() => ImportExport.ImportCSV(filePath));
}
