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 GetAllSheetDataTest()
{
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 = xlsxfile.GetAllSheetData();
xlsxfile.Close();
}
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();
}
public void SavingProjects()
{
ExcelStream excelStream = new ExcelStream(@"C:\Users\maxgr\OneDrive\Documents\Fiverr\C#\Drag n chart\Sample data\Data Template 2b.xlsx");
excelStream.Select(4);
Project testProj = new Project()
{
ExcelStream = excelStream, ReadingsData = excelStream.GetAllSheetData()
};
testProj.Save(@"C:\Users\maxgr\Desktop\test file.xml");
}
