public void GetDateTest()
{
ExcelStream xlsxfile = new ExcelStream(@"C:\Users\maxgr\OneDrive\Documents\Fiverr\C#\Drag n chart\Sample data\Data Template 2b.xlsx");
xlsxfile.Select(4);
var test = (string)xlsxfile.GetCellData(3, 2, true);
}
public void OpeningAndShowing()
{
ExcelStream xlsxfile = new ExcelStream(@"C:\Users\maxgr\OneDrive\Documents\Fiverr\C#\Drag n chart\Sample data\Data Template 2b.xlsx");
xlsxfile.Select(4);
string actual = xlsxfile.GetCellData(5, 4).ToString().Trim();
string expected = "2.26";
Assert.AreEqual(expected, actual);
xlsxfile.Close();
}