Ejemplo n.º 1
0
        // Generates content of worksheetPart1.
        private void GenerateWorksheetPart1Content(WorksheetPart worksheetPart1)
        {
            Worksheet worksheet1 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" }  };
            worksheet1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            worksheet1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            worksheet1.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
            SheetDimension sheetDimension1 = new SheetDimension(){ Reference = "A1:B5" };

            SheetViews sheetViews1 = new SheetViews();
            SheetView sheetView1 = new SheetView(){ WorkbookViewId = (UInt32Value)0U };

            sheetViews1.Append(sheetView1);
            SheetFormatProperties sheetFormatProperties1 = new SheetFormatProperties(){ DefaultRowHeight = 15D };

            Columns columns1 = new Columns();
            Column column1 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true };
            Column column2 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true };
            Column column3 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true };
            Column column4 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column5 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true };
            Column column6 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column7 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true };

            columns1.Append(column1);
            columns1.Append(column2);
            columns1.Append(column3);
            columns1.Append(column4);
            columns1.Append(column5);
            columns1.Append(column6);
            columns1.Append(column7);

            SheetData sheetData1 = new SheetData();

            Row row1 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell1 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString };
            CellValue cellValue1 = new CellValue();
            cellValue1.Text = "29";

            cell1.Append(cellValue1);

            Cell cell2 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString };
            CellValue cellValue2 = new CellValue();
            cellValue2.Text = "28";

            cell2.Append(cellValue2);

            row1.Append(cell1);
            row1.Append(cell2);

            Row row2 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell3 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue3 = new CellValue();
            cellValue3.Text = "6";

            cell3.Append(cellValue3);

            Cell cell4 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U };
            CellValue cellValue4 = new CellValue();
            cellValue4.Text = "19";

            cell4.Append(cellValue4);

            row2.Append(cell3);
            row2.Append(cell4);

            Row row3 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell5 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue5 = new CellValue();
            cellValue5.Text = "8";

            cell5.Append(cellValue5);

            Cell cell6 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U };
            CellValue cellValue6 = new CellValue();
            cellValue6.Text = "13";

            cell6.Append(cellValue6);

            row3.Append(cell5);
            row3.Append(cell6);

            Row row4 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell7 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue7 = new CellValue();
            cellValue7.Text = "11";

            cell7.Append(cellValue7);

            Cell cell8 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U };
            CellValue cellValue8 = new CellValue();
            cellValue8.Text = "33";

            cell8.Append(cellValue8);

            row4.Append(cell7);
            row4.Append(cell8);

            Row row5 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell9 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue9 = new CellValue();
            cellValue9.Text = "30";

            cell9.Append(cellValue9);

            Cell cell10 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U };
            CellValue cellValue10 = new CellValue();
            cellValue10.Text = "65";

            cell10.Append(cellValue10);

            row5.Append(cell9);
            row5.Append(cell10);

            sheetData1.Append(row1);
            sheetData1.Append(row2);
            sheetData1.Append(row3);
            sheetData1.Append(row4);
            sheetData1.Append(row5);
            PhoneticProperties phoneticProperties1 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
            PageMargins pageMargins1 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
            S.Drawing drawing1 = new S.Drawing(){ Id = "rId2" };

            WorksheetExtensionList worksheetExtensionList1 = new WorksheetExtensionList();

            WorksheetExtension worksheetExtension1 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" };
            worksheetExtension1.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");

            X15.TimelineReferences timelineReferences1 = new X15.TimelineReferences();
            X15.TimelineReference timelineReference1 = new X15.TimelineReference(){ Id = "rId3" };

            timelineReferences1.Append(timelineReference1);

            worksheetExtension1.Append(timelineReferences1);

            worksheetExtensionList1.Append(worksheetExtension1);

            worksheet1.Append(sheetDimension1);
            worksheet1.Append(sheetViews1);
            worksheet1.Append(sheetFormatProperties1);
            worksheet1.Append(columns1);
            worksheet1.Append(sheetData1);
            worksheet1.Append(phoneticProperties1);
            worksheet1.Append(pageMargins1);
            worksheet1.Append(drawing1);
            worksheet1.Append(worksheetExtensionList1);

            worksheetPart1.Worksheet = worksheet1;
        }
Ejemplo n.º 2
0
        // Generates content of worksheetPart6.
        private void GenerateWorksheetPart6Content(WorksheetPart worksheetPart6)
        {
            Worksheet worksheet6 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" }  };
            worksheet6.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            worksheet6.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            worksheet6.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
            SheetDimension sheetDimension6 = new SheetDimension(){ Reference = "A1:B5" };

            SheetViews sheetViews6 = new SheetViews();
            SheetView sheetView6 = new SheetView(){ WorkbookViewId = (UInt32Value)0U };

            sheetViews6.Append(sheetView6);
            SheetFormatProperties sheetFormatProperties6 = new SheetFormatProperties(){ DefaultRowHeight = 15D };

            Columns columns6 = new Columns();
            Column column34 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true };
            Column column35 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true };
            Column column36 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true };
            Column column37 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column38 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true };
            Column column39 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column40 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true };

            columns6.Append(column34);
            columns6.Append(column35);
            columns6.Append(column36);
            columns6.Append(column37);
            columns6.Append(column38);
            columns6.Append(column39);
            columns6.Append(column40);

            SheetData sheetData6 = new SheetData();

            Row row38 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell163 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString };
            CellValue cellValue163 = new CellValue();
            cellValue163.Text = "29";

            cell163.Append(cellValue163);

            Cell cell164 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString };
            CellValue cellValue164 = new CellValue();
            cellValue164.Text = "28";

            cell164.Append(cellValue164);

            row38.Append(cell163);
            row38.Append(cell164);

            Row row39 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell165 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue165 = new CellValue();
            cellValue165.Text = "6";

            cell165.Append(cellValue165);

            Cell cell166 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U };
            CellValue cellValue166 = new CellValue();
            cellValue166.Text = "19";

            cell166.Append(cellValue166);

            row39.Append(cell165);
            row39.Append(cell166);

            Row row40 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell167 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue167 = new CellValue();
            cellValue167.Text = "8";

            cell167.Append(cellValue167);

            Cell cell168 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U };
            CellValue cellValue168 = new CellValue();
            cellValue168.Text = "13";

            cell168.Append(cellValue168);

            row40.Append(cell167);
            row40.Append(cell168);

            Row row41 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell169 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue169 = new CellValue();
            cellValue169.Text = "11";

            cell169.Append(cellValue169);

            Cell cell170 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U };
            CellValue cellValue170 = new CellValue();
            cellValue170.Text = "33";

            cell170.Append(cellValue170);

            row41.Append(cell169);
            row41.Append(cell170);

            Row row42 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell171 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue171 = new CellValue();
            cellValue171.Text = "30";

            cell171.Append(cellValue171);

            Cell cell172 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U };
            CellValue cellValue172 = new CellValue();
            cellValue172.Text = "65";

            cell172.Append(cellValue172);

            row42.Append(cell171);
            row42.Append(cell172);

            sheetData6.Append(row38);
            sheetData6.Append(row39);
            sheetData6.Append(row40);
            sheetData6.Append(row41);
            sheetData6.Append(row42);
            PhoneticProperties phoneticProperties12 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
            PageMargins pageMargins12 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
            S.Drawing drawing4 = new S.Drawing(){ Id = "rId2" };

            WorksheetExtensionList worksheetExtensionList4 = new WorksheetExtensionList();

            WorksheetExtension worksheetExtension4 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" };
            worksheetExtension4.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");

            X15.TimelineReferences timelineReferences4 = new X15.TimelineReferences();
            X15.TimelineReference timelineReference4 = new X15.TimelineReference(){ Id = "rId3" };

            timelineReferences4.Append(timelineReference4);

            worksheetExtension4.Append(timelineReferences4);

            worksheetExtensionList4.Append(worksheetExtension4);

            worksheet6.Append(sheetDimension6);
            worksheet6.Append(sheetViews6);
            worksheet6.Append(sheetFormatProperties6);
            worksheet6.Append(columns6);
            worksheet6.Append(sheetData6);
            worksheet6.Append(phoneticProperties12);
            worksheet6.Append(pageMargins12);
            worksheet6.Append(drawing4);
            worksheet6.Append(worksheetExtensionList4);

            worksheetPart6.Worksheet = worksheet6;
        }
Ejemplo n.º 3
0
        // Generates content of worksheetPart3.
        private void GenerateWorksheetPart3Content(WorksheetPart worksheetPart3)
        {
            Worksheet worksheet3 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" }  };
            worksheet3.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            worksheet3.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            worksheet3.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
            SheetDimension sheetDimension3 = new SheetDimension(){ Reference = "A1:B5" };

            SheetViews sheetViews3 = new SheetViews();
            SheetView sheetView3 = new SheetView(){ WorkbookViewId = (UInt32Value)0U };

            sheetViews3.Append(sheetView3);
            SheetFormatProperties sheetFormatProperties3 = new SheetFormatProperties(){ DefaultRowHeight = 15D };

            Columns columns3 = new Columns();
            Column column9 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true };
            Column column10 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true };
            Column column11 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true };
            Column column12 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column13 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true };
            Column column14 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column15 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true };

            columns3.Append(column9);
            columns3.Append(column10);
            columns3.Append(column11);
            columns3.Append(column12);
            columns3.Append(column13);
            columns3.Append(column14);
            columns3.Append(column15);

            SheetData sheetData3 = new SheetData();

            Row row11 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell21 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString };
            CellValue cellValue21 = new CellValue();
            cellValue21.Text = "29";

            cell21.Append(cellValue21);

            Cell cell22 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString };
            CellValue cellValue22 = new CellValue();
            cellValue22.Text = "28";

            cell22.Append(cellValue22);

            row11.Append(cell21);
            row11.Append(cell22);

            Row row12 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell23 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue23 = new CellValue();
            cellValue23.Text = "6";

            cell23.Append(cellValue23);

            Cell cell24 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U };
            CellValue cellValue24 = new CellValue();
            cellValue24.Text = "19";

            cell24.Append(cellValue24);

            row12.Append(cell23);
            row12.Append(cell24);

            Row row13 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell25 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue25 = new CellValue();
            cellValue25.Text = "8";

            cell25.Append(cellValue25);

            Cell cell26 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U };
            CellValue cellValue26 = new CellValue();
            cellValue26.Text = "13";

            cell26.Append(cellValue26);

            row13.Append(cell25);
            row13.Append(cell26);

            Row row14 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell27 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue27 = new CellValue();
            cellValue27.Text = "11";

            cell27.Append(cellValue27);

            Cell cell28 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U };
            CellValue cellValue28 = new CellValue();
            cellValue28.Text = "33";

            cell28.Append(cellValue28);

            row14.Append(cell27);
            row14.Append(cell28);

            Row row15 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell29 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue29 = new CellValue();
            cellValue29.Text = "30";

            cell29.Append(cellValue29);

            Cell cell30 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U };
            CellValue cellValue30 = new CellValue();
            cellValue30.Text = "65";

            cell30.Append(cellValue30);

            row15.Append(cell29);
            row15.Append(cell30);

            sheetData3.Append(row11);
            sheetData3.Append(row12);
            sheetData3.Append(row13);
            sheetData3.Append(row14);
            sheetData3.Append(row15);
            PhoneticProperties phoneticProperties3 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
            PageMargins pageMargins7 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
            S.Drawing drawing3 = new S.Drawing(){ Id = "rId2" };

            WorksheetExtensionList worksheetExtensionList3 = new WorksheetExtensionList();

            WorksheetExtension worksheetExtension3 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" };
            worksheetExtension3.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");

            X15.TimelineReferences timelineReferences3 = new X15.TimelineReferences();
            X15.TimelineReference timelineReference3 = new X15.TimelineReference(){ Id = "rId3" };

            timelineReferences3.Append(timelineReference3);

            worksheetExtension3.Append(timelineReferences3);

            worksheetExtensionList3.Append(worksheetExtension3);

            worksheet3.Append(sheetDimension3);
            worksheet3.Append(sheetViews3);
            worksheet3.Append(sheetFormatProperties3);
            worksheet3.Append(columns3);
            worksheet3.Append(sheetData3);
            worksheet3.Append(phoneticProperties3);
            worksheet3.Append(pageMargins7);
            worksheet3.Append(drawing3);
            worksheet3.Append(worksheetExtensionList3);

            worksheetPart3.Worksheet = worksheet3;
        }
Ejemplo n.º 4
0
        // Generates content of worksheetPart2.
        private void GenerateWorksheetPart2Content(WorksheetPart worksheetPart2)
        {
            Worksheet worksheet2 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" }  };
            worksheet2.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            worksheet2.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            worksheet2.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
            SheetDimension sheetDimension2 = new SheetDimension(){ Reference = "A1:B5" };

            SheetViews sheetViews2 = new SheetViews();
            SheetView sheetView2 = new SheetView(){ WorkbookViewId = (UInt32Value)0U };

            sheetViews2.Append(sheetView2);
            SheetFormatProperties sheetFormatProperties2 = new SheetFormatProperties(){ DefaultRowHeight = 15D };

            Columns columns2 = new Columns();
            Column column8 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)2U, Width = 14.140625D, BestFit = true, CustomWidth = true };

            columns2.Append(column8);

            SheetData sheetData2 = new SheetData();

            Row row6 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell11 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString };
            CellValue cellValue11 = new CellValue();
            cellValue11.Text = "29";

            cell11.Append(cellValue11);

            Cell cell12 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString };
            CellValue cellValue12 = new CellValue();
            cellValue12.Text = "31";

            cell12.Append(cellValue12);

            row6.Append(cell11);
            row6.Append(cell12);

            Row row7 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell13 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue13 = new CellValue();
            cellValue13.Text = "16";

            cell13.Append(cellValue13);

            Cell cell14 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U };
            CellValue cellValue14 = new CellValue();
            cellValue14.Text = "2050";

            cell14.Append(cellValue14);

            row7.Append(cell13);
            row7.Append(cell14);

            Row row8 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell15 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue15 = new CellValue();
            cellValue15.Text = "22";

            cell15.Append(cellValue15);

            Cell cell16 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U };
            CellValue cellValue16 = new CellValue();
            cellValue16.Text = "3168";

            cell16.Append(cellValue16);

            row8.Append(cell15);
            row8.Append(cell16);

            Row row9 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell17 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue17 = new CellValue();
            cellValue17.Text = "23";

            cell17.Append(cellValue17);

            Cell cell18 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U };
            CellValue cellValue18 = new CellValue();
            cellValue18.Text = "11529";

            cell18.Append(cellValue18);

            row9.Append(cell17);
            row9.Append(cell18);

            Row row10 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell19 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue19 = new CellValue();
            cellValue19.Text = "30";

            cell19.Append(cellValue19);

            Cell cell20 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U };
            CellValue cellValue20 = new CellValue();
            cellValue20.Text = "16747";

            cell20.Append(cellValue20);

            row10.Append(cell19);
            row10.Append(cell20);

            sheetData2.Append(row6);
            sheetData2.Append(row7);
            sheetData2.Append(row8);
            sheetData2.Append(row9);
            sheetData2.Append(row10);
            PhoneticProperties phoneticProperties2 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
            PageMargins pageMargins4 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
            S.Drawing drawing2 = new S.Drawing(){ Id = "rId2" };

            WorksheetExtensionList worksheetExtensionList2 = new WorksheetExtensionList();

            WorksheetExtension worksheetExtension2 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" };
            worksheetExtension2.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");

            X15.TimelineReferences timelineReferences2 = new X15.TimelineReferences();
            X15.TimelineReference timelineReference2 = new X15.TimelineReference(){ Id = "rId3" };

            timelineReferences2.Append(timelineReference2);

            worksheetExtension2.Append(timelineReferences2);

            worksheetExtensionList2.Append(worksheetExtension2);

            worksheet2.Append(sheetDimension2);
            worksheet2.Append(sheetViews2);
            worksheet2.Append(sheetFormatProperties2);
            worksheet2.Append(columns2);
            worksheet2.Append(sheetData2);
            worksheet2.Append(phoneticProperties2);
            worksheet2.Append(pageMargins4);
            worksheet2.Append(drawing2);
            worksheet2.Append(worksheetExtensionList2);

            worksheetPart2.Worksheet = worksheet2;
        }
Ejemplo n.º 5
0
        // Generates content of worksheetPart9.
        private void GenerateWorksheetPart9Content(WorksheetPart worksheetPart9)
        {
            Worksheet worksheet9 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" }  };
            worksheet9.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            worksheet9.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            worksheet9.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
            SheetDimension sheetDimension9 = new SheetDimension(){ Reference = "A1:B5" };

            SheetViews sheetViews9 = new SheetViews();
            SheetView sheetView9 = new SheetView(){ WorkbookViewId = (UInt32Value)0U };

            sheetViews9.Append(sheetView9);
            SheetFormatProperties sheetFormatProperties9 = new SheetFormatProperties(){ DefaultRowHeight = 15D };

            Columns columns9 = new Columns();
            Column column55 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true };
            Column column56 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true };
            Column column57 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true };
            Column column58 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column59 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true };
            Column column60 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column61 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true };

            columns9.Append(column55);
            columns9.Append(column56);
            columns9.Append(column57);
            columns9.Append(column58);
            columns9.Append(column59);
            columns9.Append(column60);
            columns9.Append(column61);

            SheetData sheetData9 = new SheetData();

            Row row53 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell193 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString };
            CellValue cellValue193 = new CellValue();
            cellValue193.Text = "29";

            cell193.Append(cellValue193);

            Cell cell194 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString };
            CellValue cellValue194 = new CellValue();
            cellValue194.Text = "28";

            cell194.Append(cellValue194);

            row53.Append(cell193);
            row53.Append(cell194);

            Row row54 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell195 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue195 = new CellValue();
            cellValue195.Text = "6";

            cell195.Append(cellValue195);

            Cell cell196 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U };
            CellValue cellValue196 = new CellValue();
            cellValue196.Text = "19";

            cell196.Append(cellValue196);

            row54.Append(cell195);
            row54.Append(cell196);

            Row row55 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell197 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue197 = new CellValue();
            cellValue197.Text = "8";

            cell197.Append(cellValue197);

            Cell cell198 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U };
            CellValue cellValue198 = new CellValue();
            cellValue198.Text = "13";

            cell198.Append(cellValue198);

            row55.Append(cell197);
            row55.Append(cell198);

            Row row56 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell199 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue199 = new CellValue();
            cellValue199.Text = "11";

            cell199.Append(cellValue199);

            Cell cell200 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U };
            CellValue cellValue200 = new CellValue();
            cellValue200.Text = "33";

            cell200.Append(cellValue200);

            row56.Append(cell199);
            row56.Append(cell200);

            Row row57 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell201 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue201 = new CellValue();
            cellValue201.Text = "30";

            cell201.Append(cellValue201);

            Cell cell202 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U };
            CellValue cellValue202 = new CellValue();
            cellValue202.Text = "65";

            cell202.Append(cellValue202);

            row57.Append(cell201);
            row57.Append(cell202);

            sheetData9.Append(row53);
            sheetData9.Append(row54);
            sheetData9.Append(row55);
            sheetData9.Append(row56);
            sheetData9.Append(row57);
            PhoneticProperties phoneticProperties15 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
            PageMargins pageMargins21 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
            S.Drawing drawing7 = new S.Drawing(){ Id = "rId2" };

            WorksheetExtensionList worksheetExtensionList7 = new WorksheetExtensionList();

            WorksheetExtension worksheetExtension7 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" };
            worksheetExtension7.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");

            X15.TimelineReferences timelineReferences7 = new X15.TimelineReferences();
            X15.TimelineReference timelineReference7 = new X15.TimelineReference(){ Id = "rId3" };

            timelineReferences7.Append(timelineReference7);

            worksheetExtension7.Append(timelineReferences7);

            worksheetExtensionList7.Append(worksheetExtension7);

            worksheet9.Append(sheetDimension9);
            worksheet9.Append(sheetViews9);
            worksheet9.Append(sheetFormatProperties9);
            worksheet9.Append(columns9);
            worksheet9.Append(sheetData9);
            worksheet9.Append(phoneticProperties15);
            worksheet9.Append(pageMargins21);
            worksheet9.Append(drawing7);
            worksheet9.Append(worksheetExtensionList7);

            worksheetPart9.Worksheet = worksheet9;
        }
Ejemplo n.º 6
0
        // Generates content of worksheetPart8.
        private void GenerateWorksheetPart8Content(WorksheetPart worksheetPart8)
        {
            Worksheet worksheet8 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" }  };
            worksheet8.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            worksheet8.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            worksheet8.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
            SheetDimension sheetDimension8 = new SheetDimension(){ Reference = "A1:B5" };

            SheetViews sheetViews8 = new SheetViews();
            SheetView sheetView8 = new SheetView(){ WorkbookViewId = (UInt32Value)0U };

            sheetViews8.Append(sheetView8);
            SheetFormatProperties sheetFormatProperties8 = new SheetFormatProperties(){ DefaultRowHeight = 15D };

            Columns columns8 = new Columns();
            Column column48 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true };
            Column column49 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true };
            Column column50 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true };
            Column column51 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column52 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true };
            Column column53 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column54 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true };

            columns8.Append(column48);
            columns8.Append(column49);
            columns8.Append(column50);
            columns8.Append(column51);
            columns8.Append(column52);
            columns8.Append(column53);
            columns8.Append(column54);

            SheetData sheetData8 = new SheetData();

            Row row48 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell183 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString };
            CellValue cellValue183 = new CellValue();
            cellValue183.Text = "29";

            cell183.Append(cellValue183);

            Cell cell184 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString };
            CellValue cellValue184 = new CellValue();
            cellValue184.Text = "28";

            cell184.Append(cellValue184);

            row48.Append(cell183);
            row48.Append(cell184);

            Row row49 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell185 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue185 = new CellValue();
            cellValue185.Text = "6";

            cell185.Append(cellValue185);

            Cell cell186 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U };
            CellValue cellValue186 = new CellValue();
            cellValue186.Text = "19";

            cell186.Append(cellValue186);

            row49.Append(cell185);
            row49.Append(cell186);

            Row row50 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell187 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue187 = new CellValue();
            cellValue187.Text = "8";

            cell187.Append(cellValue187);

            Cell cell188 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U };
            CellValue cellValue188 = new CellValue();
            cellValue188.Text = "13";

            cell188.Append(cellValue188);

            row50.Append(cell187);
            row50.Append(cell188);

            Row row51 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell189 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue189 = new CellValue();
            cellValue189.Text = "11";

            cell189.Append(cellValue189);

            Cell cell190 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U };
            CellValue cellValue190 = new CellValue();
            cellValue190.Text = "33";

            cell190.Append(cellValue190);

            row51.Append(cell189);
            row51.Append(cell190);

            Row row52 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell191 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue191 = new CellValue();
            cellValue191.Text = "30";

            cell191.Append(cellValue191);

            Cell cell192 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U };
            CellValue cellValue192 = new CellValue();
            cellValue192.Text = "65";

            cell192.Append(cellValue192);

            row52.Append(cell191);
            row52.Append(cell192);

            sheetData8.Append(row48);
            sheetData8.Append(row49);
            sheetData8.Append(row50);
            sheetData8.Append(row51);
            sheetData8.Append(row52);
            PhoneticProperties phoneticProperties14 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
            PageMargins pageMargins18 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
            S.Drawing drawing6 = new S.Drawing(){ Id = "rId2" };

            WorksheetExtensionList worksheetExtensionList6 = new WorksheetExtensionList();

            WorksheetExtension worksheetExtension6 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" };
            worksheetExtension6.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");

            X15.TimelineReferences timelineReferences6 = new X15.TimelineReferences();
            X15.TimelineReference timelineReference6 = new X15.TimelineReference(){ Id = "rId3" };

            timelineReferences6.Append(timelineReference6);

            worksheetExtension6.Append(timelineReferences6);

            worksheetExtensionList6.Append(worksheetExtension6);

            worksheet8.Append(sheetDimension8);
            worksheet8.Append(sheetViews8);
            worksheet8.Append(sheetFormatProperties8);
            worksheet8.Append(columns8);
            worksheet8.Append(sheetData8);
            worksheet8.Append(phoneticProperties14);
            worksheet8.Append(pageMargins18);
            worksheet8.Append(drawing6);
            worksheet8.Append(worksheetExtensionList6);

            worksheetPart8.Worksheet = worksheet8;
        }
Ejemplo n.º 7
0
        // Generates content of worksheetPart7.
        private void GenerateWorksheetPart7Content(WorksheetPart worksheetPart7)
        {
            Worksheet worksheet7 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" }  };
            worksheet7.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            worksheet7.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            worksheet7.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
            SheetDimension sheetDimension7 = new SheetDimension(){ Reference = "A1:B5" };

            SheetViews sheetViews7 = new SheetViews();
            SheetView sheetView7 = new SheetView(){ WorkbookViewId = (UInt32Value)0U };

            sheetViews7.Append(sheetView7);
            SheetFormatProperties sheetFormatProperties7 = new SheetFormatProperties(){ DefaultRowHeight = 15D };

            Columns columns7 = new Columns();
            Column column41 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true };
            Column column42 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true };
            Column column43 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true };
            Column column44 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column45 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true };
            Column column46 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column47 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true };

            columns7.Append(column41);
            columns7.Append(column42);
            columns7.Append(column43);
            columns7.Append(column44);
            columns7.Append(column45);
            columns7.Append(column46);
            columns7.Append(column47);

            SheetData sheetData7 = new SheetData();

            Row row43 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell173 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString };
            CellValue cellValue173 = new CellValue();
            cellValue173.Text = "29";

            cell173.Append(cellValue173);

            Cell cell174 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString };
            CellValue cellValue174 = new CellValue();
            cellValue174.Text = "28";

            cell174.Append(cellValue174);

            row43.Append(cell173);
            row43.Append(cell174);

            Row row44 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell175 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue175 = new CellValue();
            cellValue175.Text = "6";

            cell175.Append(cellValue175);

            Cell cell176 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U };
            CellValue cellValue176 = new CellValue();
            cellValue176.Text = "19";

            cell176.Append(cellValue176);

            row44.Append(cell175);
            row44.Append(cell176);

            Row row45 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell177 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue177 = new CellValue();
            cellValue177.Text = "8";

            cell177.Append(cellValue177);

            Cell cell178 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U };
            CellValue cellValue178 = new CellValue();
            cellValue178.Text = "13";

            cell178.Append(cellValue178);

            row45.Append(cell177);
            row45.Append(cell178);

            Row row46 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell179 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue179 = new CellValue();
            cellValue179.Text = "11";

            cell179.Append(cellValue179);

            Cell cell180 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U };
            CellValue cellValue180 = new CellValue();
            cellValue180.Text = "33";

            cell180.Append(cellValue180);

            row46.Append(cell179);
            row46.Append(cell180);

            Row row47 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } };

            Cell cell181 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue181 = new CellValue();
            cellValue181.Text = "30";

            cell181.Append(cellValue181);

            Cell cell182 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U };
            CellValue cellValue182 = new CellValue();
            cellValue182.Text = "65";

            cell182.Append(cellValue182);

            row47.Append(cell181);
            row47.Append(cell182);

            sheetData7.Append(row43);
            sheetData7.Append(row44);
            sheetData7.Append(row45);
            sheetData7.Append(row46);
            sheetData7.Append(row47);
            PhoneticProperties phoneticProperties13 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
            PageMargins pageMargins15 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
            S.Drawing drawing5 = new S.Drawing(){ Id = "rId2" };

            WorksheetExtensionList worksheetExtensionList5 = new WorksheetExtensionList();

            WorksheetExtension worksheetExtension5 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" };
            worksheetExtension5.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");

            X15.TimelineReferences timelineReferences5 = new X15.TimelineReferences();
            X15.TimelineReference timelineReference5 = new X15.TimelineReference(){ Id = "rId3" };

            timelineReferences5.Append(timelineReference5);

            worksheetExtension5.Append(timelineReferences5);

            worksheetExtensionList5.Append(worksheetExtension5);

            worksheet7.Append(sheetDimension7);
            worksheet7.Append(sheetViews7);
            worksheet7.Append(sheetFormatProperties7);
            worksheet7.Append(columns7);
            worksheet7.Append(sheetData7);
            worksheet7.Append(phoneticProperties13);
            worksheet7.Append(pageMargins15);
            worksheet7.Append(drawing5);
            worksheet7.Append(worksheetExtensionList5);

            worksheetPart7.Worksheet = worksheet7;
        }