示例#1
0
        public void Should_Render_Matrix_With_Cells_Lookup_On_A_Concataned_Matrix()
        {
            // GIVEN
            var finalTotalStyle = _workbook.CreateCellStyle();

            finalTotalStyle.FillPattern         = FillPattern.SolidForeground;
            finalTotalStyle.FillForegroundColor = IndexedColors.LightOrange.Index;
            var format = new NPOIFormat {
                CellStyle = finalTotalStyle
            };
            Matrix m1 = MatrixDatasets.Given_MatrixWithCellLookup(1, format);
            Matrix m2 = MatrixDatasets.Given_MatrixWithCellLookup(2, format);
            Matrix m3 = m1.ConcatX(m2);

            // WHEN
            var filename = WriteDebugFile(_defaultFormatApplier, m3, FILE_TEST_LOOKUP_2, _workbook);

            // THEN
            var readWb    = new XSSFWorkbook(File.OpenRead(filename));
            var readSheet = readWb.GetSheetAt(0);

            var row1 = readSheet.GetRow(1);

            Check.That(row1.Cells[0].StringCellValue).IsEqualTo("Mario");
            Check.That(row1.Cells.Skip(1).Take(5).Extracting("NumericCellValue")).ContainsExactly(10, 20, 30, 60, 0);
            Check.That(row1.Cells[5].CellFormula).IsEqualTo("AVERAGE(10,20,30)");
            Check.That(row1.Cells[6].StringCellValue).IsEqualTo("Mario");
            Check.That(row1.Cells.Skip(7).Take(5).Extracting("NumericCellValue")).ContainsExactly(10, 20, 30, 60, 0);
            Check.That(row1.Cells.Last().CellFormula).IsEqualTo("AVERAGE(10,20,30)");

            var row2 = readSheet.GetRow(2);

            Check.That(row2.Cells[0].StringCellValue).IsEqualTo("Luigi");
            Check.That(row2.Cells.Skip(1).Take(5).Extracting("NumericCellValue")).ContainsExactly(12, 23, 34, 69, 0);
            Check.That(row2.Cells[5].CellFormula).IsEqualTo("AVERAGE(12,23,34)");
            Check.That(row2.Cells[6].StringCellValue).IsEqualTo("Luigi");
            Check.That(row2.Cells.Skip(7).Take(5).Extracting("NumericCellValue")).ContainsExactly(12, 23, 34, 69, 0);
            Check.That(row2.Cells.Last().CellFormula).IsEqualTo("AVERAGE(12,23,34)");

            var row3 = readSheet.GetRow(3);

            Check.That(row3.Cells[0].StringCellValue).IsEqualTo("TOTAL");
            Check.That(row3.Cells.Skip(1).Take(5).Extracting("NumericCellValue")).ContainsExactly(22, 0, 0, 0, 0);
            Check.That(row3.Cells[2].CellFormula).IsEqualTo("SUM(C2:C3)");
            Check.That(row3.Cells[3].CellFormula).IsEqualTo("D2+D3");
            Check.That(row3.Cells[4].CellFormula).IsEqualTo("SUM(E2:E3)");
            Check.That(row3.Cells[5].CellFormula).IsEqualTo("AVERAGE(F2:F3)");
            Check.That(row3.Cells[6].StringCellValue).IsEqualTo("TOTAL");
            Check.That(row3.Cells.Skip(7).Take(5).Extracting("NumericCellValue")).ContainsExactly(22, 0, 0, 0, 0);
            Check.That(row3.Cells[8].CellFormula).IsEqualTo("SUM(I2:I3)");
            Check.That(row3.Cells[9].CellFormula).IsEqualTo("J2+J3");
            Check.That(row3.Cells[10].CellFormula).IsEqualTo("SUM(K2:K3)");
            Check.That(row3.Cells[11].CellFormula).IsEqualTo("AVERAGE(L2:L3)");
        }
示例#2
0
        public void Should_Render_Matrix_With_Cells_Lookup_On_A_Single_Matrix()
        {
            // GIVEN
            var mat = MatrixDatasets.Given_MatrixWithCellLookup(1, null);

            // WHEN
            var filename = TestUtils.WriteDebugFile(mat, "closedxml_lookup1", streamsToClose: _fileStreamToClose);

            _fileStreamToClose.First().Close();
            // THEN
            SharedAssertions.Assert_Matrix_Cells_Lookup_On_A_Single_Matrix(filename);
        }
示例#3
0
        public void Should_Renderer_Matrix_Basic_Example()
        {
            // GIVEN
            var dataset = MatrixDatasets.Given_BasicExample();
            var mat     = dataset.Matrix;

            var ms = new MemoryStream();

            // WHEN
            _renderer.GenerateExcelFile(mat, ms);
            ms.Close();

            WriteDebugFile(mat, FILE_TEST_1);

            // THEN
            SharedAssertions.Assert_Basic_Example(ms, dataset);
        }
示例#4
0
        public void Should_Renderer_Matrix_Basic_Example()
        {
            // GIVEN
            var dataset = MatrixDatasets.Given_BasicExample();
            var mat     = dataset.Matrix;

            var ms = new MemoryStream();

            // WHEN
            _renderer.GenerateExcelFile(mat, ms);
            ms.Close();

            TestUtils.WriteDebugFile(mat, "closedxml_basic_example", streamsToClose: _fileStreamToClose);

            // THEN
            SharedAssertions.Assert_Basic_Example(ms, dataset);
        }
示例#5
0
        public void Should_Render_Matrix_With_Cells_Lookup_On_A_Single_Matrix()
        {
            // GIVEN
            var finalTotalStyle = _workbook.CreateCellStyle();

            finalTotalStyle.FillPattern         = FillPattern.SolidForeground;
            finalTotalStyle.FillForegroundColor = IndexedColors.LightOrange.Index;
            var format = new NPOIFormat {
                CellStyle = finalTotalStyle
            };
            Matrix m1 = MatrixDatasets.Given_MatrixWithCellLookup(1, format);

            // WHEN
            var filename = WriteDebugFile(_defaultFormatApplier, m1, FILE_TEST_LOOKUP_1, _workbook);

            // THEN
            SharedAssertions.Assert_Matrix_Cells_Lookup_On_A_Single_Matrix(filename);
        }