// Generates content of worksheetPart1. private void GenerateWorksheetPart1Content(WorksheetPart worksheetPart1) { Worksheet worksheet1 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" } }; worksheet1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); worksheet1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); worksheet1.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"); SheetDimension sheetDimension1 = new SheetDimension(){ Reference = "A1:B5" }; SheetViews sheetViews1 = new SheetViews(); SheetView sheetView1 = new SheetView(){ WorkbookViewId = (UInt32Value)0U }; sheetViews1.Append(sheetView1); SheetFormatProperties sheetFormatProperties1 = new SheetFormatProperties(){ DefaultRowHeight = 15D }; Columns columns1 = new Columns(); Column column1 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true }; Column column2 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true }; Column column3 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true }; Column column4 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true }; Column column5 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true }; Column column6 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true }; Column column7 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true }; columns1.Append(column1); columns1.Append(column2); columns1.Append(column3); columns1.Append(column4); columns1.Append(column5); columns1.Append(column6); columns1.Append(column7); SheetData sheetData1 = new SheetData(); Row row1 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell1 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString }; CellValue cellValue1 = new CellValue(); cellValue1.Text = "29"; cell1.Append(cellValue1); Cell cell2 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString }; CellValue cellValue2 = new CellValue(); cellValue2.Text = "28"; cell2.Append(cellValue2); row1.Append(cell1); row1.Append(cell2); Row row2 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell3 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue3 = new CellValue(); cellValue3.Text = "6"; cell3.Append(cellValue3); Cell cell4 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U }; CellValue cellValue4 = new CellValue(); cellValue4.Text = "19"; cell4.Append(cellValue4); row2.Append(cell3); row2.Append(cell4); Row row3 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell5 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue5 = new CellValue(); cellValue5.Text = "8"; cell5.Append(cellValue5); Cell cell6 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U }; CellValue cellValue6 = new CellValue(); cellValue6.Text = "13"; cell6.Append(cellValue6); row3.Append(cell5); row3.Append(cell6); Row row4 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell7 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue7 = new CellValue(); cellValue7.Text = "11"; cell7.Append(cellValue7); Cell cell8 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U }; CellValue cellValue8 = new CellValue(); cellValue8.Text = "33"; cell8.Append(cellValue8); row4.Append(cell7); row4.Append(cell8); Row row5 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell9 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue9 = new CellValue(); cellValue9.Text = "30"; cell9.Append(cellValue9); Cell cell10 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U }; CellValue cellValue10 = new CellValue(); cellValue10.Text = "65"; cell10.Append(cellValue10); row5.Append(cell9); row5.Append(cell10); sheetData1.Append(row1); sheetData1.Append(row2); sheetData1.Append(row3); sheetData1.Append(row4); sheetData1.Append(row5); PhoneticProperties phoneticProperties1 = new PhoneticProperties(){ FontId = (UInt32Value)1U }; PageMargins pageMargins1 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D }; S.Drawing drawing1 = new S.Drawing(){ Id = "rId2" }; WorksheetExtensionList worksheetExtensionList1 = new WorksheetExtensionList(); WorksheetExtension worksheetExtension1 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" }; worksheetExtension1.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"); X15.TimelineReferences timelineReferences1 = new X15.TimelineReferences(); X15.TimelineReference timelineReference1 = new X15.TimelineReference(){ Id = "rId3" }; timelineReferences1.Append(timelineReference1); worksheetExtension1.Append(timelineReferences1); worksheetExtensionList1.Append(worksheetExtension1); worksheet1.Append(sheetDimension1); worksheet1.Append(sheetViews1); worksheet1.Append(sheetFormatProperties1); worksheet1.Append(columns1); worksheet1.Append(sheetData1); worksheet1.Append(phoneticProperties1); worksheet1.Append(pageMargins1); worksheet1.Append(drawing1); worksheet1.Append(worksheetExtensionList1); worksheetPart1.Worksheet = worksheet1; }
// Generates content of worksheetPart6. private void GenerateWorksheetPart6Content(WorksheetPart worksheetPart6) { Worksheet worksheet6 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" } }; worksheet6.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); worksheet6.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); worksheet6.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"); SheetDimension sheetDimension6 = new SheetDimension(){ Reference = "A1:B5" }; SheetViews sheetViews6 = new SheetViews(); SheetView sheetView6 = new SheetView(){ WorkbookViewId = (UInt32Value)0U }; sheetViews6.Append(sheetView6); SheetFormatProperties sheetFormatProperties6 = new SheetFormatProperties(){ DefaultRowHeight = 15D }; Columns columns6 = new Columns(); Column column34 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true }; Column column35 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true }; Column column36 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true }; Column column37 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true }; Column column38 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true }; Column column39 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true }; Column column40 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true }; columns6.Append(column34); columns6.Append(column35); columns6.Append(column36); columns6.Append(column37); columns6.Append(column38); columns6.Append(column39); columns6.Append(column40); SheetData sheetData6 = new SheetData(); Row row38 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell163 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString }; CellValue cellValue163 = new CellValue(); cellValue163.Text = "29"; cell163.Append(cellValue163); Cell cell164 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString }; CellValue cellValue164 = new CellValue(); cellValue164.Text = "28"; cell164.Append(cellValue164); row38.Append(cell163); row38.Append(cell164); Row row39 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell165 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue165 = new CellValue(); cellValue165.Text = "6"; cell165.Append(cellValue165); Cell cell166 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U }; CellValue cellValue166 = new CellValue(); cellValue166.Text = "19"; cell166.Append(cellValue166); row39.Append(cell165); row39.Append(cell166); Row row40 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell167 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue167 = new CellValue(); cellValue167.Text = "8"; cell167.Append(cellValue167); Cell cell168 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U }; CellValue cellValue168 = new CellValue(); cellValue168.Text = "13"; cell168.Append(cellValue168); row40.Append(cell167); row40.Append(cell168); Row row41 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell169 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue169 = new CellValue(); cellValue169.Text = "11"; cell169.Append(cellValue169); Cell cell170 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U }; CellValue cellValue170 = new CellValue(); cellValue170.Text = "33"; cell170.Append(cellValue170); row41.Append(cell169); row41.Append(cell170); Row row42 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell171 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue171 = new CellValue(); cellValue171.Text = "30"; cell171.Append(cellValue171); Cell cell172 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U }; CellValue cellValue172 = new CellValue(); cellValue172.Text = "65"; cell172.Append(cellValue172); row42.Append(cell171); row42.Append(cell172); sheetData6.Append(row38); sheetData6.Append(row39); sheetData6.Append(row40); sheetData6.Append(row41); sheetData6.Append(row42); PhoneticProperties phoneticProperties12 = new PhoneticProperties(){ FontId = (UInt32Value)1U }; PageMargins pageMargins12 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D }; S.Drawing drawing4 = new S.Drawing(){ Id = "rId2" }; WorksheetExtensionList worksheetExtensionList4 = new WorksheetExtensionList(); WorksheetExtension worksheetExtension4 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" }; worksheetExtension4.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"); X15.TimelineReferences timelineReferences4 = new X15.TimelineReferences(); X15.TimelineReference timelineReference4 = new X15.TimelineReference(){ Id = "rId3" }; timelineReferences4.Append(timelineReference4); worksheetExtension4.Append(timelineReferences4); worksheetExtensionList4.Append(worksheetExtension4); worksheet6.Append(sheetDimension6); worksheet6.Append(sheetViews6); worksheet6.Append(sheetFormatProperties6); worksheet6.Append(columns6); worksheet6.Append(sheetData6); worksheet6.Append(phoneticProperties12); worksheet6.Append(pageMargins12); worksheet6.Append(drawing4); worksheet6.Append(worksheetExtensionList4); worksheetPart6.Worksheet = worksheet6; }
// Generates content of worksheetPart3. private void GenerateWorksheetPart3Content(WorksheetPart worksheetPart3) { Worksheet worksheet3 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" } }; worksheet3.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); worksheet3.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); worksheet3.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"); SheetDimension sheetDimension3 = new SheetDimension(){ Reference = "A1:B5" }; SheetViews sheetViews3 = new SheetViews(); SheetView sheetView3 = new SheetView(){ WorkbookViewId = (UInt32Value)0U }; sheetViews3.Append(sheetView3); SheetFormatProperties sheetFormatProperties3 = new SheetFormatProperties(){ DefaultRowHeight = 15D }; Columns columns3 = new Columns(); Column column9 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true }; Column column10 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true }; Column column11 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true }; Column column12 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true }; Column column13 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true }; Column column14 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true }; Column column15 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true }; columns3.Append(column9); columns3.Append(column10); columns3.Append(column11); columns3.Append(column12); columns3.Append(column13); columns3.Append(column14); columns3.Append(column15); SheetData sheetData3 = new SheetData(); Row row11 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell21 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString }; CellValue cellValue21 = new CellValue(); cellValue21.Text = "29"; cell21.Append(cellValue21); Cell cell22 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString }; CellValue cellValue22 = new CellValue(); cellValue22.Text = "28"; cell22.Append(cellValue22); row11.Append(cell21); row11.Append(cell22); Row row12 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell23 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue23 = new CellValue(); cellValue23.Text = "6"; cell23.Append(cellValue23); Cell cell24 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U }; CellValue cellValue24 = new CellValue(); cellValue24.Text = "19"; cell24.Append(cellValue24); row12.Append(cell23); row12.Append(cell24); Row row13 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell25 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue25 = new CellValue(); cellValue25.Text = "8"; cell25.Append(cellValue25); Cell cell26 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U }; CellValue cellValue26 = new CellValue(); cellValue26.Text = "13"; cell26.Append(cellValue26); row13.Append(cell25); row13.Append(cell26); Row row14 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell27 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue27 = new CellValue(); cellValue27.Text = "11"; cell27.Append(cellValue27); Cell cell28 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U }; CellValue cellValue28 = new CellValue(); cellValue28.Text = "33"; cell28.Append(cellValue28); row14.Append(cell27); row14.Append(cell28); Row row15 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell29 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue29 = new CellValue(); cellValue29.Text = "30"; cell29.Append(cellValue29); Cell cell30 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U }; CellValue cellValue30 = new CellValue(); cellValue30.Text = "65"; cell30.Append(cellValue30); row15.Append(cell29); row15.Append(cell30); sheetData3.Append(row11); sheetData3.Append(row12); sheetData3.Append(row13); sheetData3.Append(row14); sheetData3.Append(row15); PhoneticProperties phoneticProperties3 = new PhoneticProperties(){ FontId = (UInt32Value)1U }; PageMargins pageMargins7 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D }; S.Drawing drawing3 = new S.Drawing(){ Id = "rId2" }; WorksheetExtensionList worksheetExtensionList3 = new WorksheetExtensionList(); WorksheetExtension worksheetExtension3 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" }; worksheetExtension3.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"); X15.TimelineReferences timelineReferences3 = new X15.TimelineReferences(); X15.TimelineReference timelineReference3 = new X15.TimelineReference(){ Id = "rId3" }; timelineReferences3.Append(timelineReference3); worksheetExtension3.Append(timelineReferences3); worksheetExtensionList3.Append(worksheetExtension3); worksheet3.Append(sheetDimension3); worksheet3.Append(sheetViews3); worksheet3.Append(sheetFormatProperties3); worksheet3.Append(columns3); worksheet3.Append(sheetData3); worksheet3.Append(phoneticProperties3); worksheet3.Append(pageMargins7); worksheet3.Append(drawing3); worksheet3.Append(worksheetExtensionList3); worksheetPart3.Worksheet = worksheet3; }
// Generates content of worksheetPart2. private void GenerateWorksheetPart2Content(WorksheetPart worksheetPart2) { Worksheet worksheet2 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" } }; worksheet2.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); worksheet2.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); worksheet2.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"); SheetDimension sheetDimension2 = new SheetDimension(){ Reference = "A1:B5" }; SheetViews sheetViews2 = new SheetViews(); SheetView sheetView2 = new SheetView(){ WorkbookViewId = (UInt32Value)0U }; sheetViews2.Append(sheetView2); SheetFormatProperties sheetFormatProperties2 = new SheetFormatProperties(){ DefaultRowHeight = 15D }; Columns columns2 = new Columns(); Column column8 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)2U, Width = 14.140625D, BestFit = true, CustomWidth = true }; columns2.Append(column8); SheetData sheetData2 = new SheetData(); Row row6 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell11 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString }; CellValue cellValue11 = new CellValue(); cellValue11.Text = "29"; cell11.Append(cellValue11); Cell cell12 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString }; CellValue cellValue12 = new CellValue(); cellValue12.Text = "31"; cell12.Append(cellValue12); row6.Append(cell11); row6.Append(cell12); Row row7 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell13 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue13 = new CellValue(); cellValue13.Text = "16"; cell13.Append(cellValue13); Cell cell14 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U }; CellValue cellValue14 = new CellValue(); cellValue14.Text = "2050"; cell14.Append(cellValue14); row7.Append(cell13); row7.Append(cell14); Row row8 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell15 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue15 = new CellValue(); cellValue15.Text = "22"; cell15.Append(cellValue15); Cell cell16 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U }; CellValue cellValue16 = new CellValue(); cellValue16.Text = "3168"; cell16.Append(cellValue16); row8.Append(cell15); row8.Append(cell16); Row row9 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell17 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue17 = new CellValue(); cellValue17.Text = "23"; cell17.Append(cellValue17); Cell cell18 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U }; CellValue cellValue18 = new CellValue(); cellValue18.Text = "11529"; cell18.Append(cellValue18); row9.Append(cell17); row9.Append(cell18); Row row10 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell19 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue19 = new CellValue(); cellValue19.Text = "30"; cell19.Append(cellValue19); Cell cell20 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U }; CellValue cellValue20 = new CellValue(); cellValue20.Text = "16747"; cell20.Append(cellValue20); row10.Append(cell19); row10.Append(cell20); sheetData2.Append(row6); sheetData2.Append(row7); sheetData2.Append(row8); sheetData2.Append(row9); sheetData2.Append(row10); PhoneticProperties phoneticProperties2 = new PhoneticProperties(){ FontId = (UInt32Value)1U }; PageMargins pageMargins4 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D }; S.Drawing drawing2 = new S.Drawing(){ Id = "rId2" }; WorksheetExtensionList worksheetExtensionList2 = new WorksheetExtensionList(); WorksheetExtension worksheetExtension2 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" }; worksheetExtension2.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"); X15.TimelineReferences timelineReferences2 = new X15.TimelineReferences(); X15.TimelineReference timelineReference2 = new X15.TimelineReference(){ Id = "rId3" }; timelineReferences2.Append(timelineReference2); worksheetExtension2.Append(timelineReferences2); worksheetExtensionList2.Append(worksheetExtension2); worksheet2.Append(sheetDimension2); worksheet2.Append(sheetViews2); worksheet2.Append(sheetFormatProperties2); worksheet2.Append(columns2); worksheet2.Append(sheetData2); worksheet2.Append(phoneticProperties2); worksheet2.Append(pageMargins4); worksheet2.Append(drawing2); worksheet2.Append(worksheetExtensionList2); worksheetPart2.Worksheet = worksheet2; }
// Generates content of worksheetPart9. private void GenerateWorksheetPart9Content(WorksheetPart worksheetPart9) { Worksheet worksheet9 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" } }; worksheet9.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); worksheet9.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); worksheet9.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"); SheetDimension sheetDimension9 = new SheetDimension(){ Reference = "A1:B5" }; SheetViews sheetViews9 = new SheetViews(); SheetView sheetView9 = new SheetView(){ WorkbookViewId = (UInt32Value)0U }; sheetViews9.Append(sheetView9); SheetFormatProperties sheetFormatProperties9 = new SheetFormatProperties(){ DefaultRowHeight = 15D }; Columns columns9 = new Columns(); Column column55 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true }; Column column56 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true }; Column column57 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true }; Column column58 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true }; Column column59 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true }; Column column60 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true }; Column column61 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true }; columns9.Append(column55); columns9.Append(column56); columns9.Append(column57); columns9.Append(column58); columns9.Append(column59); columns9.Append(column60); columns9.Append(column61); SheetData sheetData9 = new SheetData(); Row row53 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell193 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString }; CellValue cellValue193 = new CellValue(); cellValue193.Text = "29"; cell193.Append(cellValue193); Cell cell194 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString }; CellValue cellValue194 = new CellValue(); cellValue194.Text = "28"; cell194.Append(cellValue194); row53.Append(cell193); row53.Append(cell194); Row row54 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell195 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue195 = new CellValue(); cellValue195.Text = "6"; cell195.Append(cellValue195); Cell cell196 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U }; CellValue cellValue196 = new CellValue(); cellValue196.Text = "19"; cell196.Append(cellValue196); row54.Append(cell195); row54.Append(cell196); Row row55 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell197 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue197 = new CellValue(); cellValue197.Text = "8"; cell197.Append(cellValue197); Cell cell198 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U }; CellValue cellValue198 = new CellValue(); cellValue198.Text = "13"; cell198.Append(cellValue198); row55.Append(cell197); row55.Append(cell198); Row row56 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell199 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue199 = new CellValue(); cellValue199.Text = "11"; cell199.Append(cellValue199); Cell cell200 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U }; CellValue cellValue200 = new CellValue(); cellValue200.Text = "33"; cell200.Append(cellValue200); row56.Append(cell199); row56.Append(cell200); Row row57 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell201 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue201 = new CellValue(); cellValue201.Text = "30"; cell201.Append(cellValue201); Cell cell202 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U }; CellValue cellValue202 = new CellValue(); cellValue202.Text = "65"; cell202.Append(cellValue202); row57.Append(cell201); row57.Append(cell202); sheetData9.Append(row53); sheetData9.Append(row54); sheetData9.Append(row55); sheetData9.Append(row56); sheetData9.Append(row57); PhoneticProperties phoneticProperties15 = new PhoneticProperties(){ FontId = (UInt32Value)1U }; PageMargins pageMargins21 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D }; S.Drawing drawing7 = new S.Drawing(){ Id = "rId2" }; WorksheetExtensionList worksheetExtensionList7 = new WorksheetExtensionList(); WorksheetExtension worksheetExtension7 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" }; worksheetExtension7.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"); X15.TimelineReferences timelineReferences7 = new X15.TimelineReferences(); X15.TimelineReference timelineReference7 = new X15.TimelineReference(){ Id = "rId3" }; timelineReferences7.Append(timelineReference7); worksheetExtension7.Append(timelineReferences7); worksheetExtensionList7.Append(worksheetExtension7); worksheet9.Append(sheetDimension9); worksheet9.Append(sheetViews9); worksheet9.Append(sheetFormatProperties9); worksheet9.Append(columns9); worksheet9.Append(sheetData9); worksheet9.Append(phoneticProperties15); worksheet9.Append(pageMargins21); worksheet9.Append(drawing7); worksheet9.Append(worksheetExtensionList7); worksheetPart9.Worksheet = worksheet9; }
// Generates content of worksheetPart8. private void GenerateWorksheetPart8Content(WorksheetPart worksheetPart8) { Worksheet worksheet8 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" } }; worksheet8.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); worksheet8.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); worksheet8.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"); SheetDimension sheetDimension8 = new SheetDimension(){ Reference = "A1:B5" }; SheetViews sheetViews8 = new SheetViews(); SheetView sheetView8 = new SheetView(){ WorkbookViewId = (UInt32Value)0U }; sheetViews8.Append(sheetView8); SheetFormatProperties sheetFormatProperties8 = new SheetFormatProperties(){ DefaultRowHeight = 15D }; Columns columns8 = new Columns(); Column column48 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true }; Column column49 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true }; Column column50 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true }; Column column51 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true }; Column column52 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true }; Column column53 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true }; Column column54 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true }; columns8.Append(column48); columns8.Append(column49); columns8.Append(column50); columns8.Append(column51); columns8.Append(column52); columns8.Append(column53); columns8.Append(column54); SheetData sheetData8 = new SheetData(); Row row48 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell183 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString }; CellValue cellValue183 = new CellValue(); cellValue183.Text = "29"; cell183.Append(cellValue183); Cell cell184 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString }; CellValue cellValue184 = new CellValue(); cellValue184.Text = "28"; cell184.Append(cellValue184); row48.Append(cell183); row48.Append(cell184); Row row49 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell185 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue185 = new CellValue(); cellValue185.Text = "6"; cell185.Append(cellValue185); Cell cell186 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U }; CellValue cellValue186 = new CellValue(); cellValue186.Text = "19"; cell186.Append(cellValue186); row49.Append(cell185); row49.Append(cell186); Row row50 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell187 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue187 = new CellValue(); cellValue187.Text = "8"; cell187.Append(cellValue187); Cell cell188 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U }; CellValue cellValue188 = new CellValue(); cellValue188.Text = "13"; cell188.Append(cellValue188); row50.Append(cell187); row50.Append(cell188); Row row51 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell189 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue189 = new CellValue(); cellValue189.Text = "11"; cell189.Append(cellValue189); Cell cell190 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U }; CellValue cellValue190 = new CellValue(); cellValue190.Text = "33"; cell190.Append(cellValue190); row51.Append(cell189); row51.Append(cell190); Row row52 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell191 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue191 = new CellValue(); cellValue191.Text = "30"; cell191.Append(cellValue191); Cell cell192 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U }; CellValue cellValue192 = new CellValue(); cellValue192.Text = "65"; cell192.Append(cellValue192); row52.Append(cell191); row52.Append(cell192); sheetData8.Append(row48); sheetData8.Append(row49); sheetData8.Append(row50); sheetData8.Append(row51); sheetData8.Append(row52); PhoneticProperties phoneticProperties14 = new PhoneticProperties(){ FontId = (UInt32Value)1U }; PageMargins pageMargins18 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D }; S.Drawing drawing6 = new S.Drawing(){ Id = "rId2" }; WorksheetExtensionList worksheetExtensionList6 = new WorksheetExtensionList(); WorksheetExtension worksheetExtension6 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" }; worksheetExtension6.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"); X15.TimelineReferences timelineReferences6 = new X15.TimelineReferences(); X15.TimelineReference timelineReference6 = new X15.TimelineReference(){ Id = "rId3" }; timelineReferences6.Append(timelineReference6); worksheetExtension6.Append(timelineReferences6); worksheetExtensionList6.Append(worksheetExtension6); worksheet8.Append(sheetDimension8); worksheet8.Append(sheetViews8); worksheet8.Append(sheetFormatProperties8); worksheet8.Append(columns8); worksheet8.Append(sheetData8); worksheet8.Append(phoneticProperties14); worksheet8.Append(pageMargins18); worksheet8.Append(drawing6); worksheet8.Append(worksheetExtensionList6); worksheetPart8.Worksheet = worksheet8; }
// Generates content of worksheetPart7. private void GenerateWorksheetPart7Content(WorksheetPart worksheetPart7) { Worksheet worksheet7 = new Worksheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" } }; worksheet7.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); worksheet7.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); worksheet7.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"); SheetDimension sheetDimension7 = new SheetDimension(){ Reference = "A1:B5" }; SheetViews sheetViews7 = new SheetViews(); SheetView sheetView7 = new SheetView(){ WorkbookViewId = (UInt32Value)0U }; sheetViews7.Append(sheetView7); SheetFormatProperties sheetFormatProperties7 = new SheetFormatProperties(){ DefaultRowHeight = 15D }; Columns columns7 = new Columns(); Column column41 = new Column(){ Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 14.140625D, BestFit = true, CustomWidth = true }; Column column42 = new Column(){ Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 17.42578125D, CustomWidth = true }; Column column43 = new Column(){ Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 12.42578125D, CustomWidth = true }; Column column44 = new Column(){ Min = (UInt32Value)4U, Max = (UInt32Value)11U, Width = 13D, BestFit = true, CustomWidth = true }; Column column45 = new Column(){ Min = (UInt32Value)12U, Max = (UInt32Value)12U, Width = 13D, CustomWidth = true }; Column column46 = new Column(){ Min = (UInt32Value)13U, Max = (UInt32Value)20U, Width = 13D, BestFit = true, CustomWidth = true }; Column column47 = new Column(){ Min = (UInt32Value)21U, Max = (UInt32Value)23U, Width = 20.42578125D, BestFit = true, CustomWidth = true }; columns7.Append(column41); columns7.Append(column42); columns7.Append(column43); columns7.Append(column44); columns7.Append(column45); columns7.Append(column46); columns7.Append(column47); SheetData sheetData7 = new SheetData(); Row row43 = new Row(){ RowIndex = (UInt32Value)1U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell173 = new Cell(){ CellReference = "A1", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString }; CellValue cellValue173 = new CellValue(); cellValue173.Text = "29"; cell173.Append(cellValue173); Cell cell174 = new Cell(){ CellReference = "B1", DataType = CellValues.SharedString }; CellValue cellValue174 = new CellValue(); cellValue174.Text = "28"; cell174.Append(cellValue174); row43.Append(cell173); row43.Append(cell174); Row row44 = new Row(){ RowIndex = (UInt32Value)2U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell175 = new Cell(){ CellReference = "A2", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue175 = new CellValue(); cellValue175.Text = "6"; cell175.Append(cellValue175); Cell cell176 = new Cell(){ CellReference = "B2", StyleIndex = (UInt32Value)7U }; CellValue cellValue176 = new CellValue(); cellValue176.Text = "19"; cell176.Append(cellValue176); row44.Append(cell175); row44.Append(cell176); Row row45 = new Row(){ RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell177 = new Cell(){ CellReference = "A3", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue177 = new CellValue(); cellValue177.Text = "8"; cell177.Append(cellValue177); Cell cell178 = new Cell(){ CellReference = "B3", StyleIndex = (UInt32Value)7U }; CellValue cellValue178 = new CellValue(); cellValue178.Text = "13"; cell178.Append(cellValue178); row45.Append(cell177); row45.Append(cell178); Row row46 = new Row(){ RowIndex = (UInt32Value)4U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell179 = new Cell(){ CellReference = "A4", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue179 = new CellValue(); cellValue179.Text = "11"; cell179.Append(cellValue179); Cell cell180 = new Cell(){ CellReference = "B4", StyleIndex = (UInt32Value)7U }; CellValue cellValue180 = new CellValue(); cellValue180.Text = "33"; cell180.Append(cellValue180); row46.Append(cell179); row46.Append(cell180); Row row47 = new Row(){ RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "1:2" } }; Cell cell181 = new Cell(){ CellReference = "A5", StyleIndex = (UInt32Value)6U, DataType = CellValues.SharedString }; CellValue cellValue181 = new CellValue(); cellValue181.Text = "30"; cell181.Append(cellValue181); Cell cell182 = new Cell(){ CellReference = "B5", StyleIndex = (UInt32Value)7U }; CellValue cellValue182 = new CellValue(); cellValue182.Text = "65"; cell182.Append(cellValue182); row47.Append(cell181); row47.Append(cell182); sheetData7.Append(row43); sheetData7.Append(row44); sheetData7.Append(row45); sheetData7.Append(row46); sheetData7.Append(row47); PhoneticProperties phoneticProperties13 = new PhoneticProperties(){ FontId = (UInt32Value)1U }; PageMargins pageMargins15 = new PageMargins(){ Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D }; S.Drawing drawing5 = new S.Drawing(){ Id = "rId2" }; WorksheetExtensionList worksheetExtensionList5 = new WorksheetExtensionList(); WorksheetExtension worksheetExtension5 = new WorksheetExtension(){ Uri = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}" }; worksheetExtension5.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"); X15.TimelineReferences timelineReferences5 = new X15.TimelineReferences(); X15.TimelineReference timelineReference5 = new X15.TimelineReference(){ Id = "rId3" }; timelineReferences5.Append(timelineReference5); worksheetExtension5.Append(timelineReferences5); worksheetExtensionList5.Append(worksheetExtension5); worksheet7.Append(sheetDimension7); worksheet7.Append(sheetViews7); worksheet7.Append(sheetFormatProperties7); worksheet7.Append(columns7); worksheet7.Append(sheetData7); worksheet7.Append(phoneticProperties13); worksheet7.Append(pageMargins15); worksheet7.Append(drawing5); worksheet7.Append(worksheetExtensionList5); worksheetPart7.Worksheet = worksheet7; }