public void TestExcelImportStream()
{
string filename = PathToTestData + "testReading.xlsx";
// display error messages in english
Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-GB");
using (MemoryStream ms = new MemoryStream())
{
using (FileStream fs = File.OpenRead(filename))
{
fs.CopyTo(ms);
}
DataTable table = TCsv2Xml.ParseExcelStream2DataTable(ms, true);
Assert.AreEqual("test1", table.Columns[0].ColumnName, "name of first column");
Assert.AreEqual("1", table.Rows[0][0].ToString(), "value of first row, first column");
Assert.AreEqual("2", table.Rows[0]["test2"].ToString(), "value of first row, second column");
Assert.AreEqual("vier", table.Rows[0][3].ToString(), "value of first row, forth column");
}
}