C# (CSharp) ExcelStream.GetCellData Examples

Example #1

File: ExcelTests.cs Project: AstroMec/Drag-n-chart

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

Example #2

File: ExcelTests.cs Project: AstroMec/Drag-n-chart

        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();

        }