Esempi in C# (CSharp) per EffectSizeCalc.ExcelImport ExcelImporter

Esempio n. 1

File: MainWindow.xaml.cs Progetto: 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;
 }

Esempio n. 2

File: TrialResultGeneratorTest.cs Progetto: 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;
        }

Esempio n. 3

File: ExcelImporterTests.cs Progetto: 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]);
        }