C# Cell.Append方法代码示例

        public static void InsertValuesInWorksheet(WorksheetPart worksheetPart, uint rowIdx, List<string> values)
        {
            var worksheet = worksheetPart.Worksheet;
            var sheetData = worksheet.GetFirstChild<SheetData>();

            Row row = new Row();
            values.ForEach(v =>
            {
                Cell cell = new Cell() { DataType = CellValues.InlineString };
                InlineString inlineString = new InlineString();
                inlineString.Append(new Text() { Text = v });
                cell.Append(inlineString);
                row.Append(cell);
            });
            sheetData.Append(row);
        }

        private void CreateWorkSheet(WorksheetPart worksheetPart, DataGridView dgv)
        {
            Worksheet worksheet = new Worksheet();
            SheetData sheetData = new SheetData();

            UInt32Value currRowIndex = 1U;
            Row excelRow = new Row();
            foreach(DataGridViewColumn col in dgv.Columns)
            {
                Cell cell = new Cell();
                cell.DataType = CellValues.String;
                CellValue cellValue = new CellValue();
                cellValue.Text = col.HeaderText;
                cell.Append(cellValue);
                excelRow.Append(cell);
            }
            sheetData.Append(excelRow);
            currRowIndex++;
            foreach (DataGridViewRow row in dgv.Rows)
            {
                excelRow = new Row();
                excelRow.RowIndex = currRowIndex++;
                foreach (DataGridViewCell col in row.Cells)
                {
                    Cell cell = new Cell();
                    CellValue cellValue = new CellValue();
                    cell.DataType = CellValues.String;
                    cellValue.Text = col.Value?.ToString();
                    cell.Append(cellValue);
                    excelRow.Append(cell);
                }
                sheetData.Append(excelRow);
            }

            SheetFormatProperties formattingProps = new SheetFormatProperties()
            {
                DefaultRowHeight = 20D,
                DefaultColumnWidth = 20D
            };

            worksheet.Append(formattingProps);
            worksheet.Append(sheetData);
            worksheetPart.Worksheet = worksheet;
        }

        public override void addDataRows(SheetData sheetData, DataTable dt)
        {
            // бежим по строкам
            foreach (DataRow dataRow in dt.Rows)
            {
                var row = new Row();

                for (int i = 0; i < dataRow.ItemArray.Length; i++)
                {
                    var cell = new Cell();
                    var cellValue = new CellValue();

                    ApplyStyle(dataRow[i], RestMetadata.GetType(dt.Columns[i].ColumnName), ref cell, ref cellValue);

                    cell.Append(cellValue);
                    row.AppendChild(cell);
                }
                sheetData.AppendChild(row);
            }
        }

        // 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);
//.........这里部分代码省略.........

        // 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);
//.........这里部分代码省略.........

        // Generates content of worksheetPart3(create Sheet1)
        private void GenerateWorksheetPart3Content(WorksheetPart worksheetPart3)
        {
            Worksheet worksheet3 = new Worksheet();
            SheetDimension sheetDimension3 = new SheetDimension() { Reference = "A1:B5" };

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

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

            Columns columns1 = new Columns();
            Column column1 = new Column() { Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 13D, BestFit = true, CustomWidth = true };
            Column column2 = new Column() { Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 12.28515625D, BestFit = true, CustomWidth = true };

            columns1.Append(column1);
            columns1.Append(column2);

            SheetData sheetData3 = new SheetData();

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

            Cell cell9 = new Cell() { CellReference = "A1", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue9 = new CellValue();
            cellValue9.Text = "3";

            cell9.Append(cellValue9);

            Cell cell10 = new Cell() { CellReference = "B1", DataType = CellValues.SharedString };
            CellValue cellValue10 = new CellValue();
            cellValue10.Text = "2";

            cell10.Append(cellValue10);

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

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

            Cell cell11 = new Cell() { CellReference = "A2", StyleIndex = (UInt32Value)3U };
            CellValue cellValue11 = new CellValue();
            cellValue11.Text = "1";

            cell11.Append(cellValue11);

            Cell cell12 = new Cell() { CellReference = "B2", StyleIndex = (UInt32Value)1U };
            CellValue cellValue12 = new CellValue();
            cellValue12.Text = "100";

            cell12.Append(cellValue12);

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

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

            Cell cell13 = new Cell() { CellReference = "A3", StyleIndex = (UInt32Value)3U };
            CellValue cellValue13 = new CellValue();
            cellValue13.Text = "2";

            cell13.Append(cellValue13);

            Cell cell14 = new Cell() { CellReference = "B3", StyleIndex = (UInt32Value)1U };
            CellValue cellValue14 = new CellValue();
            cellValue14.Text = "120";

            cell14.Append(cellValue14);

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

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

            Cell cell15 = new Cell() { CellReference = "A4", StyleIndex = (UInt32Value)3U };
            CellValue cellValue15 = new CellValue();
            cellValue15.Text = "3";

            cell15.Append(cellValue15);

            Cell cell16 = new Cell() { CellReference = "B4", StyleIndex = (UInt32Value)1U };
            CellValue cellValue16 = new CellValue();
            cellValue16.Text = "132";

            cell16.Append(cellValue16);

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

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

            Cell cell17 = new Cell() { CellReference = "A5", StyleIndex = (UInt32Value)3U, DataType = CellValues.SharedString };
            CellValue cellValue17 = new CellValue();
            cellValue17.Text = "4";

            cell17.Append(cellValue17);

            Cell cell18 = new Cell() { CellReference = "B5", StyleIndex = (UInt32Value)1U };
            CellValue cellValue18 = new CellValue();
            cellValue18.Text = "352";
//.........这里部分代码省略.........

        // Generates content of worksheetPart1.
        private void GenerateWorksheetPart1Content(WorksheetPart worksheetPart1)
        {
            Worksheet worksheet1 = new Worksheet();
            worksheet1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            SheetDimension sheetDimension1 = new SheetDimension() { Reference = "A1:A2" };

            SheetViews sheetViews1 = new SheetViews();

            SheetView sheetView1 = new SheetView() { TabSelected = true, WorkbookViewId = (UInt32Value)0U };
            Selection selection1 = new Selection() { ActiveCell = "A2", SequenceOfReferences = new ListValue<StringValue>() { InnerText = "A2" } };

            sheetView1.Append(selection1);

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

            SheetData sheetData1 = new SheetData();

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

            Cell cell1 = new Cell() { CellReference = "A1" };
            CellValue cellValue1 = new CellValue();
            cellValue1.Text = "1";

            cell1.Append(cellValue1);

            row1.Append(cell1);

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

            Cell cell2 = new Cell() { CellReference = "A2" };
            CellValue cellValue2 = new CellValue();
            cellValue2.Text = "-1";

            cell2.Append(cellValue2);

            row2.Append(cell2);

            sheetData1.Append(row1);
            sheetData1.Append(row2);

            ConditionalFormatting conditionalFormatting1 = new ConditionalFormatting() { SequenceOfReferences = new ListValue<StringValue>() { InnerText = "A1" } };

            ConditionalFormattingRule conditionalFormattingRule1 = new ConditionalFormattingRule() { Type = ConditionalFormatValues.CellIs, FormatId = (UInt32Value)2U, Priority = 2, Operator = ConditionalFormattingOperatorValues.GreaterThan };
            Formula formula1 = new Formula();
            formula1.Text = "0";

            conditionalFormattingRule1.Append(formula1);

            conditionalFormatting1.Append(conditionalFormattingRule1);

            ConditionalFormatting conditionalFormatting2 = new ConditionalFormatting() { SequenceOfReferences = new ListValue<StringValue>() { InnerText = "A2" } };

            ConditionalFormattingRule conditionalFormattingRule2 = new ConditionalFormattingRule() { Type = ConditionalFormatValues.CellIs, FormatId = (UInt32Value)0U, Priority = 1, Operator = ConditionalFormattingOperatorValues.LessThan };
            Formula formula2 = new Formula();
            formula2.Text = "0";

            conditionalFormattingRule2.Append(formula2);

            conditionalFormatting2.Append(conditionalFormattingRule2);
            PageMargins pageMargins1 = new PageMargins() { Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };

            worksheet1.Append(sheetDimension1);
            worksheet1.Append(sheetViews1);
            worksheet1.Append(sheetFormatProperties1);
            worksheet1.Append(sheetData1);
            worksheet1.Append(conditionalFormatting1);
            worksheet1.Append(conditionalFormatting2);
            worksheet1.Append(pageMargins1);

            worksheetPart1.Worksheet = worksheet1;
        }

        private Cell CreateNumberCell(int columnIndex, int rowIndex, object cellValue, Type dataType)
        {
            Cell cell = new Cell();

            cell.DataType = CellValues.Number;

            CellValue cellv = new CellValue();

            if (dataType == typeof(int))
                cellv.Text = ((int)cellValue).ToString(_culture);
            else if (dataType == typeof(float))
                cellv.Text = ((float)cellValue).ToString(_culture);
            else if (dataType == typeof(decimal))
                cellv.Text = ((decimal)cellValue).ToString(_culture);
            else if (dataType == typeof(double))
                cellv.Text = ((double)cellValue).ToString(_culture);
            else if (dataType == typeof(long))
                cellv.Text = ((long)cellValue).ToString(_culture);

            cell.Append(cellv);

            return cell;
        }

        // Generates content of worksheetPart1.
        protected override void GenerateWorksheetPartContent(WorksheetPart worksheetPart)
        {
            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 = "B1:J59" };

            SheetViews sheetViews1 = new SheetViews();

            SheetView sheetView1 = new SheetView() { TabSelected = true, TopLeftCell = "A25", ZoomScaleNormal = (UInt32Value)100U, WorkbookViewId = (UInt32Value)0U };
            Selection selection1 = new Selection() { ActiveCell = "N13", SequenceOfReferences = new ListValue<StringValue>() { InnerText = "N13" } };

            sheetView1.Append(selection1);

            sheetViews1.Append(sheetView1);
            SheetFormatProperties sheetFormatProperties1 = new SheetFormatProperties() { DefaultRowHeight = 12D, DyDescent = 0.2D };

            Columns columns1 = new Columns();
            Column column1 = new Column() { Min = (UInt32Value)1U, Max = (UInt32Value)2U, Width = 0.85546875D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column2 = new Column() { Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 5.140625D, Style = (UInt32Value)1U, BestFit = true, CustomWidth = true };
            Column column3 = new Column() { Min = (UInt32Value)4U, Max = (UInt32Value)4U, Width = 16D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column4 = new Column() { Min = (UInt32Value)5U, Max = (UInt32Value)5U, Width = 9.140625D, Style = (UInt32Value)1U };
            Column column5 = new Column() { Min = (UInt32Value)6U, Max = (UInt32Value)6U, Width = 4.28515625D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column6 = new Column() { Min = (UInt32Value)7U, Max = (UInt32Value)7U, Width = 13.42578125D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column7 = new Column() { Min = (UInt32Value)8U, Max = (UInt32Value)8U, Width = 9.140625D, Style = (UInt32Value)1U };
            Column column8 = new Column() { Min = (UInt32Value)9U, Max = (UInt32Value)9U, Width = 23D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column9 = new Column() { Min = (UInt32Value)10U, Max = (UInt32Value)10U, Width = 0.85546875D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column10 = new Column() { Min = (UInt32Value)11U, Max = (UInt32Value)16384U, Width = 9.140625D, Style = (UInt32Value)1U };

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

            SheetData sheetData1 = new SheetData();

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

            Cell cell1 = new Cell() { CellReference = "G1", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue1 = new CellValue();
            cellValue1.Text = "0";

            cell1.Append(cellValue1);

            row1.Append(cell1);

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

            Cell cell2 = new Cell() { CellReference = "G2", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue2 = new CellValue();
            cellValue2.Text = "1";

            cell2.Append(cellValue2);

            row2.Append(cell2);

            Row row3 = new Row() { RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "2:10" }, DyDescent = 0.2D };

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

            cell3.Append(cellValue3);
            Cell cell4 = new Cell() { CellReference = "E4", StyleIndex = (UInt32Value)3U };

            Cell cell5 = new Cell() { CellReference = "G4", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue4 = new CellValue();
            cellValue4.Text = "3";

            cell5.Append(cellValue4);
            Cell cell6 = new Cell() { CellReference = "H4", StyleIndex = (UInt32Value)3U };

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

            Row row4 = new Row() { RowIndex = (UInt32Value)6U, Spans = new ListValue<StringValue>() { InnerText = "2:10" }, Height = 4.5D, CustomHeight = true, DyDescent = 0.2D };
            Cell cell7 = new Cell() { CellReference = "B6", StyleIndex = (UInt32Value)7U };
            Cell cell8 = new Cell() { CellReference = "C6", StyleIndex = (UInt32Value)7U };
            Cell cell9 = new Cell() { CellReference = "D6", StyleIndex = (UInt32Value)7U };
            Cell cell10 = new Cell() { CellReference = "E6", StyleIndex = (UInt32Value)7U };
            Cell cell11 = new Cell() { CellReference = "F6", StyleIndex = (UInt32Value)7U };
            Cell cell12 = new Cell() { CellReference = "G6", StyleIndex = (UInt32Value)7U };
            Cell cell13 = new Cell() { CellReference = "H6", StyleIndex = (UInt32Value)7U };
            Cell cell14 = new Cell() { CellReference = "I6", StyleIndex = (UInt32Value)7U };
            Cell cell15 = new Cell() { CellReference = "J6", StyleIndex = (UInt32Value)7U };

            row4.Append(cell7);
            row4.Append(cell8);
            row4.Append(cell9);
            row4.Append(cell10);
//.........这里部分代码省略.........

        // Generates content of worksheetPart1.
        private void GenerateWorksheetPart1Content(WorksheetPart worksheetPart1)
        {
            Worksheet worksheet1 = new Worksheet();
            worksheet1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            SheetDimension sheetDimension1 = new SheetDimension() { Reference = "A1:K59" };

            SheetViews sheetViews1 = new SheetViews();

            SheetView sheetView1 = new SheetView() { TabSelected = true, WorkbookViewId = (UInt32Value)0U };
            Selection selection1 = new Selection() { ActiveCell = "B5", SequenceOfReferences = new ListValue<StringValue>() { InnerText = "B5" } };

            sheetView1.Append(selection1);

            sheetViews1.Append(sheetView1);
            SheetFormatProperties sheetFormatProperties1 = new SheetFormatProperties() { BaseColumnWidth = (UInt32Value)10U, DefaultRowHeight = 15D };

            Columns columns1 = new Columns();
            Column column1 = new Column() { Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 27.7109375D, CustomWidth = true };
            Column column2 = new Column() { Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 13.7109375D, CustomWidth = true };
            Column column3 = new Column() { Min = (UInt32Value)3U, Max = (UInt32Value)8U, Width = 27.7109375D, CustomWidth = true };

            columns1.Append(column1);
            columns1.Append(column2);
            columns1.Append(column3);

            SheetData sheetData1 = new SheetData();

            Row row1 = new Row() { RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:11" } };
            Cell cell1 = new Cell() { CellReference = "A1", StyleIndex = (UInt32Value)29U };
            Cell cell2 = new Cell() { CellReference = "B1", StyleIndex = (UInt32Value)19U };
            Cell cell3 = new Cell() { CellReference = "C1", StyleIndex = (UInt32Value)19U };
            Cell cell4 = new Cell() { CellReference = "D1", StyleIndex = (UInt32Value)19U };
            Cell cell5 = new Cell() { CellReference = "E1", StyleIndex = (UInt32Value)19U };
            Cell cell6 = new Cell() { CellReference = "F1", StyleIndex = (UInt32Value)19U };
            Cell cell7 = new Cell() { CellReference = "G1", StyleIndex = (UInt32Value)19U };
            Cell cell8 = new Cell() { CellReference = "H1", StyleIndex = (UInt32Value)19U };
            Cell cell9 = new Cell() { CellReference = "I1", StyleIndex = (UInt32Value)19U };
            Cell cell10 = new Cell() { CellReference = "J1", StyleIndex = (UInt32Value)30U };
            Cell cell11 = new Cell() { CellReference = "K1", StyleIndex = (UInt32Value)1U };

            row1.Append(cell1);
            row1.Append(cell2);
            row1.Append(cell3);
            row1.Append(cell4);
            row1.Append(cell5);
            row1.Append(cell6);
            row1.Append(cell7);
            row1.Append(cell8);
            row1.Append(cell9);
            row1.Append(cell10);
            row1.Append(cell11);

            Row row2 = new Row() { RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:11" } };
            Cell cell12 = new Cell() { CellReference = "A2", StyleIndex = (UInt32Value)29U };
            Cell cell13 = new Cell() { CellReference = "B2", StyleIndex = (UInt32Value)19U };
            Cell cell14 = new Cell() { CellReference = "C2", StyleIndex = (UInt32Value)19U };
            Cell cell15 = new Cell() { CellReference = "D2", StyleIndex = (UInt32Value)19U };
            Cell cell16 = new Cell() { CellReference = "E2", StyleIndex = (UInt32Value)19U };
            Cell cell17 = new Cell() { CellReference = "F2", StyleIndex = (UInt32Value)19U };
            Cell cell18 = new Cell() { CellReference = "G2", StyleIndex = (UInt32Value)19U };
            Cell cell19 = new Cell() { CellReference = "H2", StyleIndex = (UInt32Value)19U };
            Cell cell20 = new Cell() { CellReference = "I2", StyleIndex = (UInt32Value)19U };
            Cell cell21 = new Cell() { CellReference = "J2", StyleIndex = (UInt32Value)30U };
            Cell cell22 = new Cell() { CellReference = "K2", StyleIndex = (UInt32Value)2U };

            row2.Append(cell12);
            row2.Append(cell13);
            row2.Append(cell14);
            row2.Append(cell15);
            row2.Append(cell16);
            row2.Append(cell17);
            row2.Append(cell18);
            row2.Append(cell19);
            row2.Append(cell20);
            row2.Append(cell21);
            row2.Append(cell22);

            Row row3 = new Row() { RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:11" } };
            Cell cell23 = new Cell() { CellReference = "A3", StyleIndex = (UInt32Value)31U };
            Cell cell24 = new Cell() { CellReference = "B3", StyleIndex = (UInt32Value)32U };

            Cell cell25 = new Cell() { CellReference = "C3", StyleIndex = (UInt32Value)33U, DataType = CellValues.SharedString };
            CellValue cellValue1 = new CellValue();
            cellValue1.Text = "0";

            cell25.Append(cellValue1);
            Cell cell26 = new Cell() { CellReference = "D3", StyleIndex = (UInt32Value)32U };
            Cell cell27 = new Cell() { CellReference = "E3", StyleIndex = (UInt32Value)33U };
            Cell cell28 = new Cell() { CellReference = "F3", StyleIndex = (UInt32Value)32U };
            Cell cell29 = new Cell() { CellReference = "G3", StyleIndex = (UInt32Value)19U };
            Cell cell30 = new Cell() { CellReference = "H3", StyleIndex = (UInt32Value)19U };
            Cell cell31 = new Cell() { CellReference = "I3", StyleIndex = (UInt32Value)19U };
            Cell cell32 = new Cell() { CellReference = "J3", StyleIndex = (UInt32Value)30U };
            Cell cell33 = new Cell() { CellReference = "K3", StyleIndex = (UInt32Value)2U };

            row3.Append(cell23);
            row3.Append(cell24);
            row3.Append(cell25);
            row3.Append(cell26);
//.........这里部分代码省略.........

        // Generates content of worksheetPart1.
        protected override void GenerateWorksheetPartContent(WorksheetPart worksheetPart)
        {
            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:E30" };

            SheetViews sheetViews1 = new SheetViews();

            SheetView sheetView1 = new SheetView() { TabSelected = true, WorkbookViewId = (UInt32Value)0U };
            Selection selection1 = new Selection() { ActiveCell = "A2", SequenceOfReferences = new ListValue<StringValue>() { InnerText = "A2:E2" } };

            sheetView1.Append(selection1);

            sheetViews1.Append(sheetView1);
            SheetFormatProperties sheetFormatProperties1 = new SheetFormatProperties() { DefaultRowHeight = 12D, DyDescent = 0.2D };

            Columns columns1 = new Columns();
            Column column1 = new Column() { Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 42.7109375D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column2 = new Column() { Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 11.5703125D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column3 = new Column() { Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 6.85546875D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column4 = new Column() { Min = (UInt32Value)4U, Max = (UInt32Value)4U, Width = 11.7109375D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column5 = new Column() { Min = (UInt32Value)5U, Max = (UInt32Value)5U, Width = 13.5703125D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column6 = new Column() { Min = (UInt32Value)6U, Max = (UInt32Value)16384U, Width = 9.140625D, Style = (UInt32Value)1U };

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

            SheetData sheetData1 = new SheetData();

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

            Cell cell1 = new Cell() { CellReference = "B1", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue1 = new CellValue();
            cellValue1.Text = "0";

            cell1.Append(cellValue1);

            row1.Append(cell1);

            Row row2 = new Row() { RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:5" }, Height = 23.25D, CustomHeight = true, DyDescent = 0.2D };

            Cell cell2 = new Cell() { CellReference = "A2", StyleIndex = (UInt32Value)4U, DataType = CellValues.SharedString };
            CellValue cellValue2 = new CellValue();
            cellValue2.Text = "1";

            cell2.Append(cellValue2);
            Cell cell3 = new Cell() { CellReference = "B2", StyleIndex = (UInt32Value)4U };
            Cell cell4 = new Cell() { CellReference = "C2", StyleIndex = (UInt32Value)4U };
            Cell cell5 = new Cell() { CellReference = "D2", StyleIndex = (UInt32Value)4U };
            Cell cell6 = new Cell() { CellReference = "E2", StyleIndex = (UInt32Value)4U };

            row2.Append(cell2);
            row2.Append(cell3);
            row2.Append(cell4);
            row2.Append(cell5);
            row2.Append(cell6);

            Row row3 = new Row() { RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:5" }, DyDescent = 0.2D };

            Cell cell7 = new Cell() { CellReference = "B4", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue3 = new CellValue();
            cellValue3.Text = "2";

            cell7.Append(cellValue3);

            row3.Append(cell7);

            Row row4 = new Row() { RowIndex = (UInt32Value)6U, Spans = new ListValue<StringValue>() { InnerText = "1:5" }, Height = 60D, DyDescent = 0.2D };

            Cell cell8 = new Cell() { CellReference = "A6", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue4 = new CellValue();
            cellValue4.Text = "3";

            cell8.Append(cellValue4);

            Cell cell9 = new Cell() { CellReference = "B6", StyleIndex = (UInt32Value)3U, DataType = CellValues.SharedString };
            CellValue cellValue5 = new CellValue();
            cellValue5.Text = "4";

            cell9.Append(cellValue5);

            Cell cell10 = new Cell() { CellReference = "C6", StyleIndex = (UInt32Value)3U, DataType = CellValues.SharedString };
            CellValue cellValue6 = new CellValue();
            cellValue6.Text = "5";

            cell10.Append(cellValue6);

            Cell cell11 = new Cell() { CellReference = "D6", StyleIndex = (UInt32Value)3U, DataType = CellValues.SharedString };
            CellValue cellValue7 = new CellValue();
            cellValue7.Text = "6";

            cell11.Append(cellValue7);

//.........这里部分代码省略.........

        // Generates content of worksheetPart4.
        private void GenerateWorksheetPart4Content(WorksheetPart worksheetPart4)
        {
            Worksheet worksheet4 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" }  };
            worksheet4.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            worksheet4.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            worksheet4.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
            SheetDimension sheetDimension4 = new SheetDimension(){ Reference = "A1:K11" };

            SheetViews sheetViews4 = new SheetViews();
            SheetView sheetView4 = new SheetView(){ WorkbookViewId = (UInt32Value)0U };

            sheetViews4.Append(sheetView4);
            SheetFormatProperties sheetFormatProperties4 = new SheetFormatProperties(){ DefaultRowHeight = 15D };

            Columns columns4 = new Columns();
            Column column16 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 10.7109375D, BestFit = true, CustomWidth = true };
            Column column17 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 10.140625D, BestFit = true, CustomWidth = true };
            Column column18 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 8.140625D, BestFit = true, CustomWidth = true };
            Column column19 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)4U, Width = 10.42578125D, BestFit = true, CustomWidth = true };
            Column column20 = new Column(){ Min = (UInt32Value)5U, Max = (UInt32Value)5U, Width = 12.85546875D, BestFit = true, CustomWidth = true };
            Column column21 = new Column(){ Min = (UInt32Value)6U, Max = (UInt32Value)6U, Width = 11.5703125D, BestFit = true, CustomWidth = true };
            Column column22 = new Column(){ Min = (UInt32Value)8U, Max = (UInt32Value)8U, Width = 12.85546875D, BestFit = true, CustomWidth = true };
            Column column23 = new Column(){ Min = (UInt32Value)9U, Max = (UInt32Value)9U, Width = 10.42578125D, BestFit = true, CustomWidth = true };
            Column column24 = new Column(){ Min = (UInt32Value)11U, Max = (UInt32Value)11U, Width = 12.85546875D, BestFit = true, CustomWidth = true };

            columns4.Append(column16);
            columns4.Append(column17);
            columns4.Append(column18);
            columns4.Append(column19);
            columns4.Append(column20);
            columns4.Append(column21);
            columns4.Append(column22);
            columns4.Append(column23);
            columns4.Append(column24);

            SheetData sheetData4 = new SheetData();

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

            Cell cell31 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue31 = new CellValue();
            cellValue31.Text = "0";

            cell31.Append(cellValue31);

            Cell cell32 = new Cell(){ CellReference = "B1", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue32 = new CellValue();
            cellValue32.Text = "1";

            cell32.Append(cellValue32);

            Cell cell33 = new Cell(){ CellReference = "C1", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue33 = new CellValue();
            cellValue33.Text = "2";

            cell33.Append(cellValue33);

            Cell cell34 = new Cell(){ CellReference = "D1", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue34 = new CellValue();
            cellValue34.Text = "3";

            cell34.Append(cellValue34);

            Cell cell35 = new Cell(){ CellReference = "E1", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue35 = new CellValue();
            cellValue35.Text = "4";

            cell35.Append(cellValue35);

            Cell cell36 = new Cell(){ CellReference = "F1", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue36 = new CellValue();
            cellValue36.Text = "5";

            cell36.Append(cellValue36);

            Cell cell37 = new Cell(){ CellReference = "H1", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue37 = new CellValue();
            cellValue37.Text = "26";

            cell37.Append(cellValue37);

            Cell cell38 = new Cell(){ CellReference = "I1", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue38 = new CellValue();
            cellValue38.Text = "3";

            cell38.Append(cellValue38);

            Cell cell39 = new Cell(){ CellReference = "K1", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue39 = new CellValue();
            cellValue39.Text = "27";

            cell39.Append(cellValue39);

            row16.Append(cell31);
            row16.Append(cell32);
            row16.Append(cell33);
            row16.Append(cell34);
            row16.Append(cell35);
            row16.Append(cell36);
//.........这里部分代码省略.........

        // Generates content of worksheetPart5.
        private void GenerateWorksheetPart5Content(WorksheetPart worksheetPart5)
        {
            Worksheet worksheet5 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" }  };
            worksheet5.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            worksheet5.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            worksheet5.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
            SheetDimension sheetDimension5 = new SheetDimension(){ Reference = "A1:K11" };

            SheetViews sheetViews5 = new SheetViews();
            SheetView sheetView5 = new SheetView(){ TabSelected = true, WorkbookViewId = (UInt32Value)0U };

            sheetViews5.Append(sheetView5);
            SheetFormatProperties sheetFormatProperties5 = new SheetFormatProperties(){ DefaultRowHeight = 15D };

            Columns columns5 = new Columns();
            Column column25 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 10.7109375D, BestFit = true, CustomWidth = true };
            Column column26 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 10.140625D, BestFit = true, CustomWidth = true };
            Column column27 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 8.140625D, BestFit = true, CustomWidth = true };
            Column column28 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)4U, Width = 10.42578125D, BestFit = true, CustomWidth = true };
            Column column29 = new Column(){ Min = (UInt32Value)5U, Max = (UInt32Value)5U, Width = 12.85546875D, BestFit = true, CustomWidth = true };
            Column column30 = new Column(){ Min = (UInt32Value)6U, Max = (UInt32Value)6U, Width = 11.5703125D, BestFit = true, CustomWidth = true };
            Column column31 = new Column(){ Min = (UInt32Value)8U, Max = (UInt32Value)8U, Width = 12.85546875D, BestFit = true, CustomWidth = true };
            Column column32 = new Column(){ Min = (UInt32Value)9U, Max = (UInt32Value)9U, Width = 10.42578125D, BestFit = true, CustomWidth = true };
            Column column33 = new Column(){ Min = (UInt32Value)11U, Max = (UInt32Value)11U, Width = 12.85546875D, BestFit = true, CustomWidth = true };

            columns5.Append(column25);
            columns5.Append(column26);
            columns5.Append(column27);
            columns5.Append(column28);
            columns5.Append(column29);
            columns5.Append(column30);
            columns5.Append(column31);
            columns5.Append(column32);
            columns5.Append(column33);

            SheetData sheetData5 = new SheetData();

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

            Cell cell100 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue100 = new CellValue();
            cellValue100.Text = "0";

            cell100.Append(cellValue100);

            Cell cell101 = new Cell(){ CellReference = "B1", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue101 = new CellValue();
            cellValue101.Text = "1";

            cell101.Append(cellValue101);

            Cell cell102 = new Cell(){ CellReference = "C1", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue102 = new CellValue();
            cellValue102.Text = "2";

            cell102.Append(cellValue102);

            Cell cell103 = new Cell(){ CellReference = "D1", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue103 = new CellValue();
            cellValue103.Text = "3";

            cell103.Append(cellValue103);

            Cell cell104 = new Cell(){ CellReference = "E1", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue104 = new CellValue();
            cellValue104.Text = "4";

            cell104.Append(cellValue104);

            Cell cell105 = new Cell(){ CellReference = "F1", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
            CellValue cellValue105 = new CellValue();
            cellValue105.Text = "5";

            cell105.Append(cellValue105);

            Cell cell106 = new Cell(){ CellReference = "H1", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue106 = new CellValue();
            cellValue106.Text = "26";

            cell106.Append(cellValue106);

            Cell cell107 = new Cell(){ CellReference = "I1", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue107 = new CellValue();
            cellValue107.Text = "3";

            cell107.Append(cellValue107);

            Cell cell108 = new Cell(){ CellReference = "K1", StyleIndex = (UInt32Value)2U, DataType = CellValues.SharedString };
            CellValue cellValue108 = new CellValue();
            cellValue108.Text = "27";

            cell108.Append(cellValue108);

            row27.Append(cell100);
            row27.Append(cell101);
            row27.Append(cell102);
            row27.Append(cell103);
            row27.Append(cell104);
            row27.Append(cell105);
//.........这里部分代码省略.........

        // 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);
//.........这里部分代码省略.........

        // 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);
//.........这里部分代码省略.........