C# (CSharp) NPOIProvider.GetSource Examples

Example #1

File: TestNPOI Provider.cs Project: iEmiya/pyExcel

        public void TestGetSource_SheetNotFoundException()
        {
            const string fileName = "./Internal Resources/sample.xls";
            var filter = new ProviderFilter();
            filter.FileName = fileName;
            filter.SheetName = "Sheet1";

            IProvider provider = new NPOIProvider(filter);
            var dataTable = provider.GetSource();
        }

Example #2

File: TestNPOI Provider.cs Project: VsPun/pyExcel

        public void TestGetSource_SheetNotFoundException()
        {
            const string fileName = "./Internal Resources/sample.xls";
            var          filter   = new ProviderFilter();

            filter.FileName  = fileName;
            filter.SheetName = "Sheet1";

            IProvider provider  = new NPOIProvider(filter);
            var       dataTable = provider.GetSource();
        }

Example #3

File: TestNPOI Provider.cs Project: iEmiya/pyExcel

        public void TestGetSource()
        {
            const string fileName = "./Internal Resources/sample.xls";

            var filter = new ProviderFilter();
            filter.FileName = fileName;
            filter.SheetName = "Лист1";

            IProvider provider = new NPOIProvider(filter);
            var dataTable = provider.GetSource();

            Assert.That(dataTable.Columns.Count, Is.EqualTo(2));
            Assert.That(dataTable.Columns[0].ColumnName, Is.EqualTo("A"));
            Assert.That(dataTable.Columns[1].ColumnName, Is.EqualTo("B"));

            Assert.That(dataTable.Rows.Count, Is.EqualTo(6));
        }

Example #4

File: TestNPOI Provider.cs Project: VsPun/pyExcel

        public void TestGetSource()
        {
            const string fileName = "./Internal Resources/sample.xls";

            var filter = new ProviderFilter();

            filter.FileName  = fileName;
            filter.SheetName = "Лист1";

            IProvider provider  = new NPOIProvider(filter);
            var       dataTable = provider.GetSource();

            Assert.That(dataTable.Columns.Count, Is.EqualTo(2));
            Assert.That(dataTable.Columns[0].ColumnName, Is.EqualTo("A"));
            Assert.That(dataTable.Columns[1].ColumnName, Is.EqualTo("B"));

            Assert.That(dataTable.Rows.Count, Is.EqualTo(6));
        }