C# (CSharp) EffectSizeCalc.ExcelImport CellParser示例

示例#1

文件： MainWindow.xaml.cs 项目： MadCowDevelopment/EffectSizeCalc

 private static IExcelImporter CreateExcelImporter()
 {
     var cellCoordinateParser = new CellCoordinateParser();
     var cellValueParser = new CellValueParser();
     var cellParser = new CellParser(cellCoordinateParser, cellValueParser);
     var excelImporter = new ExcelImporter(cellParser);
     return excelImporter;
 }

示例#2

文件： TrialResultGeneratorTest.cs 项目： MadCowDevelopment/EffectSizeCalc

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

示例#3

文件： ExcelImporterTests.cs 项目： MadCowDevelopment/EffectSizeCalc

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