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"); }