C# (CSharp) ExcelImporter.GetCellValues示例

示例#1

        private ExcelDataSet CreateDataSet()
        {
            var cellCoordinateParser = new CellCoordinateParser();
            var cellValueParser      = new CellValueParser();
            var cellParser           = new CellParser(cellCoordinateParser, cellValueParser);
            var importer             = new ExcelImporter(cellParser);

            var dataSet = importer.GetCellValues(@"data.xlsx");

            return(dataSet);
        }

示例#2

        public void TestMethod1()
        {
            var cellCoordinateParser = new CellCoordinateParser();
            var cellValueParser      = new CellValueParser();
            var cellParser           = new CellParser(cellCoordinateParser, cellValueParser);
            var importer             = new ExcelImporter(cellParser);

            var result = importer.GetCellValues(@"data.xlsx");

            Assert.AreEqual(15, result.TrialDataRows.Count);
            Assert.AreEqual("Vpn", result.TrialDataRows[0].Values[0]);
        }