C# Worksheet.AddNamespaceDeclaration方法代码示例

        public static WorksheetPart AddWorksheet(this WorkbookPart workbookPart, string name, Worksheet sheet)
        {
            sheet.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            
            var result = workbookPart.AddNewPart<WorksheetPart>();
            result.Worksheet = sheet;
            sheet.Save();

            workbookPart.Workbook.Sheets.Append(
                new Sheet
                {
                    Name = name,
                    SheetId = (uint)workbookPart.Workbook.Sheets.Count() + 1,
                    Id = workbookPart.GetIdOfPart(result)
                });

            return result;
        }

        /// <summary>
        /// Generates the content of the WorkSheet part.
        /// </summary>
        /// <param name="part">The part.</param>
        private static void GeneratePartContent(WorksheetPart part, string[] partIds)
        {
            char sheetDimensionColumn = 'A';
            if (!string.IsNullOrEmpty(partIds[0]))
            {
                // If file level metadata is present, sheet dimension will be from column A to column B.
                sheetDimensionColumn = (char)(sheetDimensionColumn + 1);
            }

            if (!string.IsNullOrEmpty(partIds[1]))
            {
                // If column level metadata is present, sheet dimension will be from column D to column I if there is file level metadata. Otherwise from column A to column F.
                sheetDimensionColumn = !string.IsNullOrEmpty(partIds[0]) ? (char)(sheetDimensionColumn + 7) : (char)(sheetDimensionColumn + 5);
            }

            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:" + sheetDimensionColumn + "30" };

            SheetViews sheetViews1 = new SheetViews();

            SheetView sheetView1 = new SheetView() { TabSelected = true, WorkbookViewId = (UInt32Value)0U };
            // Add 2 extra columns for selection.
            char activeColumn = (char)(sheetDimensionColumn + 2);
            Selection selection1 = new Selection() { ActiveCell = activeColumn + "9", SequenceOfReferences = new ListValue<StringValue>() { InnerText = activeColumn + "9" } };

            sheetView1.Append(selection1);

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

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

            columns1.Append(column1);

            SheetData sheetData1 = new SheetData();

            Row row1 = new Row() { RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = (string.IsNullOrEmpty(partIds[1])) ? "1:2" : "1:9" }, DyDescent = 0.25D };
            char column = 'A';

            if (!string.IsNullOrEmpty(partIds[0]))
            {
                // Add file level metadata name to column A.
                Cell cell1 = new Cell() { CellReference = "A1", DataType = CellValues.String };
                CellValue cellValue1 = new CellValue() { Text = "Name" };
                cell1.Append(cellValue1);
                row1.Append(cell1);

                // Add file level metadata value to column B.
                Cell cell2 = new Cell() { CellReference = "B1", DataType = CellValues.String };
                CellValue cellValue2 = new CellValue() { Text = "Value" };
                cell2.Append(cellValue2);
                row1.Append(cell2);

                // Add column level metadata from column D if file level metadata is present.
                column = 'D';
            }

            if (!string.IsNullOrEmpty(partIds[1]))
            {
                Cell cell3 = new Cell() { CellReference = (column++) + "1", DataType = CellValues.String };
                CellValue cellValue3 = new CellValue() { Text = Statics.TableName };

                cell3.Append(cellValue3);
                row1.Append(cell3);

                Cell cell4 = new Cell() { CellReference = (column++) + "1", DataType = CellValues.String };
                CellValue cellValue4 = new CellValue() { Text = Statics.TableDescription };
                cell4.Append(cellValue4);
                row1.Append(cell4);

                Cell cell5 = new Cell() { CellReference = (column++) + "1", DataType = CellValues.String };
                CellValue cellValue5 = new CellValue() { Text = Statics.FieldName };
                cell5.Append(cellValue5);
                row1.Append(cell5);

                Cell cell6 = new Cell() { CellReference = (column++) + "1", DataType = CellValues.String };
                CellValue cellValue6 = new CellValue() { Text = Statics.FieldDescription };
                cell6.Append(cellValue6);
                row1.Append(cell6);

                Cell cell7 = new Cell() { CellReference = (column++) + "1", DataType = CellValues.String };
                CellValue cellValue7 = new CellValue() { Text = Statics.DataType };
                cell7.Append(cellValue7);
                row1.Append(cell7);

                Cell cell8 = new Cell() { CellReference = (column++) + "1", DataType = CellValues.String };
                CellValue cellValue8 = new CellValue() { Text = Statics.Units };
                cell8.Append(cellValue8);
                row1.Append(cell8);
            }

            sheetData1.Append(row1);
//.........这里部分代码省略.........

        // 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;
        }

        // 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.
        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:H31" };

            SheetViews sheetViews1 = new SheetViews();

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

            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 = 35.42578125D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column2 = new Column() { Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 5.7109375D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column3 = new Column() { Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 5.28515625D, Style = (UInt32Value)1U, BestFit = true, CustomWidth = true };
            Column column4 = new Column() { Min = (UInt32Value)4U, Max = (UInt32Value)4U, Width = 6.140625D, Style = (UInt32Value)1U, BestFit = true, CustomWidth = true };
            Column column5 = new Column() { Min = (UInt32Value)5U, Max = (UInt32Value)5U, Width = 10.42578125D, Style = (UInt32Value)1U, BestFit = true, CustomWidth = true };
            Column column6 = new Column() { Min = (UInt32Value)6U, Max = (UInt32Value)6U, Width = 4.85546875D, Style = (UInt32Value)1U, BestFit = true, CustomWidth = true };
            Column column7 = new Column() { Min = (UInt32Value)7U, Max = (UInt32Value)7U, Width = 6.140625D, Style = (UInt32Value)1U, BestFit = true, CustomWidth = true };
            Column column8 = new Column() { Min = (UInt32Value)8U, Max = (UInt32Value)8U, Width = 11.85546875D, Style = (UInt32Value)1U, CustomWidth = true };
            Column column9 = new Column() { Min = (UInt32Value)9U, 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);

            SheetData sheetData1 = new SheetData();

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

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

            cell1.Append(cellValue1);

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

            cell2.Append(cellValue2);
            Cell cell3 = new Cell() { CellReference = "C1", StyleIndex = (UInt32Value)8U };
            Cell cell4 = new Cell() { CellReference = "D1", StyleIndex = (UInt32Value)8U };
            Cell cell5 = new Cell() { CellReference = "E1", StyleIndex = (UInt32Value)8U };
            Cell cell6 = new Cell() { CellReference = "F1", StyleIndex = (UInt32Value)9U };

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

            cell7.Append(cellValue3);
            Cell cell8 = new Cell() { CellReference = "H1", StyleIndex = (UInt32Value)6U };

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

            Row row2 = new Row() { RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:8" }, DyDescent = 0.2D };
            Cell cell9 = new Cell() { CellReference = "A2", StyleIndex = (UInt32Value)6U };
            Cell cell10 = new Cell() { CellReference = "B2", StyleIndex = (UInt32Value)10U };
            Cell cell11 = new Cell() { CellReference = "C2", StyleIndex = (UInt32Value)11U };
            Cell cell12 = new Cell() { CellReference = "D2", StyleIndex = (UInt32Value)11U };
            Cell cell13 = new Cell() { CellReference = "E2", StyleIndex = (UInt32Value)11U };
            Cell cell14 = new Cell() { CellReference = "F2", StyleIndex = (UInt32Value)12U };

            Cell cell15 = new Cell() { CellReference = "G2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString };
            CellValue cellValue4 = new CellValue();
            cellValue4.Text = "3";

            cell15.Append(cellValue4);
            Cell cell16 = new Cell() { CellReference = "H2", StyleIndex = (UInt32Value)6U };

            row2.Append(cell9);
            row2.Append(cell10);
            row2.Append(cell11);
            row2.Append(cell12);
            row2.Append(cell13);
            row2.Append(cell14);
            row2.Append(cell15);
            row2.Append(cell16);

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

        // 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" };

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

            sheetViews1.Append(sheetView1);
            SheetFormatProperties sheetFormatProperties1 = new SheetFormatProperties(){ BaseColumnWidth = (UInt32Value)10U, 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", DataType = CellValues.SharedString };
            CellValue cellValue1 = new CellValue();
            cellValue1.Text = "0";

            cell1.Append(cellValue1);

            row1.Append(cell1);

            sheetData1.Append(row1);
            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(pageMargins1);

            worksheetPart1.Worksheet = worksheet1;
        }

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

        /// <summary>
        /// Initialize the worksheet with required details
        /// </summary>
        /// <returns></returns>
        private Worksheet SetWorksheetData()
        {
            Worksheet worksheet = new Worksheet() { MCAttributes = new MarkupCompatibilityAttributes() { Ignorable = "x14ac" } };
            worksheet.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            worksheet.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            worksheet.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");

            Columns columns = new Columns();
            Column column1 = new Column() { Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 15U, CustomWidth = true };
            Column column2 = new Column() { Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = (Double)ConversionSettings.ColumnWidth, CustomWidth = true };
            Column column3 = new Column() { Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = (Double)ConversionSettings.ColumnWidth, CustomWidth = true };
            Column column4 = new Column() { Min = (UInt32Value)4U, Max = (UInt32Value)4U, Width = (Double)ConversionSettings.ColumnWidth, CustomWidth = true };

            columns.Append(column1);
            columns.Append(column2);
            columns.Append(column3);
            columns.Append(column4);

            SheetData sheetData = new SheetData();

            SheetProtection sheetProtection = new SheetProtection() { Sheet = true, Objects = true, Scenarios = true };

            worksheet.Append(columns);
            worksheet.Append(sheetData);
            worksheet.Append(sheetProtection);
            return worksheet;
        }

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

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

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

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

        // 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 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");
            SheetProperties sheetProperties1 = new SheetProperties(){ CodeName = "Sheet1" };
            SheetDimension sheetDimension1 = new SheetDimension(){ Reference = "B2:I41" };

            SheetViews sheetViews1 = new SheetViews();

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

            sheetView1.Append(selection1);

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

            Columns columns1 = new Columns();
            Column column1 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 12.85546875D, BestFit = true, CustomWidth = true };
            Column column2 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 17.140625D, BestFit = true, CustomWidth = true };
            Column column3 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)4U, Width = 24D, BestFit = true, CustomWidth = true };
            Column column4 = new Column(){ Min = (UInt32Value)5U, Max = (UInt32Value)5U, Width = 15.140625D, BestFit = true, CustomWidth = true };
            Column column5 = new Column(){ Min = (UInt32Value)6U, Max = (UInt32Value)6U, Width = 16.5703125D, BestFit = true, CustomWidth = true };
            Column column6 = new Column(){ Min = (UInt32Value)7U, Max = (UInt32Value)7U, Width = 81.140625D, BestFit = true, CustomWidth = true };
            Column column7 = new Column(){ Min = (UInt32Value)8U, Max = (UInt32Value)8U, Width = 18.7109375D, BestFit = true, CustomWidth = true };
            Column column8 = new Column(){ Min = (UInt32Value)9U, Max = (UInt32Value)9U, Width = 14.5703125D, 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);
            columns1.Append(column8);

            SheetData sheetData1 = new SheetData();

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

            Cell cell1 = new Cell(){ CellReference = "B2", DataType = CellValues.SharedString };
            CellValue cellValue1 = new CellValue();
            cellValue1.Text = "0";

            cell1.Append(cellValue1);

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

            cell2.Append(cellValue2);

            Cell cell3 = new Cell(){ CellReference = "D2", DataType = CellValues.SharedString };
            CellValue cellValue3 = new CellValue();
            cellValue3.Text = "2";

            cell3.Append(cellValue3);

            Cell cell4 = new Cell(){ CellReference = "E2", DataType = CellValues.SharedString };
            CellValue cellValue4 = new CellValue();
            cellValue4.Text = "3";

            cell4.Append(cellValue4);

            Cell cell5 = new Cell(){ CellReference = "F2", DataType = CellValues.SharedString };
            CellValue cellValue5 = new CellValue();
            cellValue5.Text = "4";

            cell5.Append(cellValue5);

            Cell cell6 = new Cell(){ CellReference = "G2", DataType = CellValues.SharedString };
            CellValue cellValue6 = new CellValue();
            cellValue6.Text = "5";

            cell6.Append(cellValue6);

            Cell cell7 = new Cell(){ CellReference = "H2", DataType = CellValues.SharedString };
            CellValue cellValue7 = new CellValue();
            cellValue7.Text = "6";

            cell7.Append(cellValue7);

            Cell cell8 = new Cell(){ CellReference = "I2", DataType = CellValues.SharedString };
            CellValue cellValue8 = new CellValue();
            cellValue8.Text = "7";

            cell8.Append(cellValue8);

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

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

        /// <summary>
        /// 创建Excel文件
        /// </summary>
        private void CreatExcelData()
        {
            // Create a spreadsheet document by supplying the filepath.
            // By default, AutoSave = true, Editable = true, and Type = xlsx.
            SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(ExportPath, SpreadsheetDocumentType.Workbook);

            // Add a WorkbookPart to the document.
            WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();
            workbookpart.Workbook = new Workbook();

            //Add a WorkbookStylesPart to the document.
            WorkbookStylesPart stylesPart = workbookpart.AddNewPart<WorkbookStylesPart>();
            stylesPart.Stylesheet = GenerateStyleSheet();
            stylesPart.Stylesheet.Save();

            // Add a WorksheetPart to the WorkbookPart.
            WorksheetPart worksheetPart = workbookpart.AddNewPart<WorksheetPart>();
            worksheetPart.Worksheet = new Worksheet(new SheetData());

            // Add Sheets to the Workbook.
            Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.AppendChild<Sheets>(new Sheets());

            // Append a new worksheet and associate it with the workbook.
            Sheet sheet = new Sheet() { Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "SimpleEntry" };
            sheets.Append(sheet);


            Worksheet worksheet = new Worksheet() { MCAttributes = new MarkupCompatibilityAttributes() { Ignorable = "x14ac" } };
            worksheet.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            worksheet.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            worksheet.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
            SheetDimension sheetDimension = new SheetDimension() { Reference = "A1:D1" };

            SheetViews sheetViews = new SheetViews();

            SheetView sheetView = new SheetView() { TabSelected = true, WorkbookViewId = (UInt32Value)0U };
            Pane pane1 = new Pane() { VerticalSplit = 1D, TopLeftCell = "A2", ActivePane = PaneValues.BottomLeft, State = PaneStateValues.Frozen };
            //Selection selection1 = new Selection() { Pane = PaneValues.BottomLeft, ActiveCell = "B1", SequenceOfReferences = new ListValue<StringValue>() { InnerText = "B1" } };

            sheetView.Append(pane1);
            //sheetView.Append(selection1);

            sheetViews.Append(sheetView);
            SheetFormatProperties sheetFormatProperties = new SheetFormatProperties() { DefaultRowHeight = 13.5D, DyDescent = 0.15D };

            SheetData sheetData = new SheetData();

            string dataBase = string.Format("data source={0}", SourcePath);

            //建立题号与题型、字段对应的字典
            Dictionary<string, int> dicQType = new Dictionary<string, int>();
            Dictionary<string, int> dicDataType = new Dictionary<string, int>();
            Dictionary<string, int> dicOther = new Dictionary<string, int>();
            //Dictionary<string,string> dicQField = new Dictionary<string,string>() ;
            using (SQLiteConnection conn = new SQLiteConnection(dataBase))
            {
                Visibility = "Visible";
                using (SQLiteCommand cmd = new SQLiteCommand())
                {
                    cmd.Connection = conn;
                    conn.Open();
                    SQLiteHelper sh = new SQLiteHelper(cmd);
                    DataTable dtField = sh.Select("select Q_Num,TypeID,Q_Field,Q_OptionsCount,Q_OtherOption,DataTypeID from QuestionInfo");
                    Row headRow = new Row() { Height = 20D, CustomHeight = true };
                    foreach (DataRow dr in dtField.Rows)
                    {
                        string QNum = dr["Q_Num"].ToString();
                        string QField = dr["Q_Field"].ToString();
                        dicQType[QNum] = Convert.ToInt32(dr["TypeID"]);
                        dicDataType[QNum] = Convert.ToInt32(dr["DataTypeID"]);
                        dicOther[QNum] = Convert.ToInt32(dr["Q_OtherOption"]);
                        //dicQField[dr["Q_Num"].ToString()] = dr["Q_Field"].ToString();
                        if (dr["TypeID"].ToString() != "1")
                        {
                            Cell headRowcell = new Cell();
                            headRowcell.StyleIndex = 1;
                            headRowcell.DataType = CellValues.String;
                            headRowcell.CellValue = new CellValue(QField);
                            headRow.AppendChild(headRowcell);
                        }
                        else
                        {
                            for (int i = 1; i <= Convert.ToInt32(dr["Q_OptionsCount"]); i++)
                            {
                                Cell headRowcell = new Cell();
                                headRowcell.StyleIndex = 1;
                                headRowcell.DataType = CellValues.String;
                                headRowcell.CellValue = new CellValue(string.Format("{0}_{1}", QField, i));
                                headRow.AppendChild(headRowcell);
                            }
                        }
                        if (dr["Q_OtherOption"].ToString() == "1")
                        {
                            Cell cell = new Cell();
                            cell.StyleIndex = 1;
                            cell.DataType = CellValues.String;
                            cell.CellValue = new CellValue(QField + "_Other");
//.........这里部分代码省略.........