// Adds child parts and generates content of the specified part. private void CreateParts(WordprocessingDocument document) { ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId3"); GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1); MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart(); GenerateMainDocumentPart1Content(mainDocumentPart1); FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart<FontTablePart>("rId8"); GenerateFontTablePart1Content(fontTablePart1); WebSettingsPart webSettingsPart1 = mainDocumentPart1.AddNewPart<WebSettingsPart>("rId3"); GenerateWebSettingsPart1Content(webSettingsPart1); DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart<DocumentSettingsPart>("rId2"); GenerateDocumentSettingsPart1Content(documentSettingsPart1); StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart<StyleDefinitionsPart>("rId1"); GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1); ThemePart themePart1 = mainDocumentPart1.AddNewPart<ThemePart>("rId9"); GenerateThemePart1Content(themePart1); mainDocumentPart1.AddHyperlinkRelationship(new System.Uri("mailto:[email protected]", System.UriKind.Absolute), true, "rId7"); mainDocumentPart1.AddHyperlinkRelationship(new System.Uri("http://www.shivam.com", System.UriKind.Absolute), true, "rId6"); mainDocumentPart1.AddHyperlinkRelationship(new System.Uri("mailto:[email protected]", System.UriKind.Absolute), true, "rId5"); mainDocumentPart1.AddHyperlinkRelationship(new System.Uri("http://www.google.com", System.UriKind.Absolute), true, "rId4"); SetPackageProperties(document); }
// Adds child parts and generates content of the specified part. private void CreateParts(WordprocessingDocument document) { ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId3"); GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1); MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart(); GenerateMainDocumentPart1Content(mainDocumentPart1); DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart<DocumentSettingsPart>("rId3"); GenerateDocumentSettingsPart1Content(documentSettingsPart1); StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart<StyleDefinitionsPart>("rId2"); GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1); CustomXmlPart customXmlPart1 = mainDocumentPart1.AddNewPart<CustomXmlPart>("application/xml", "rId1"); GenerateCustomXmlPart1Content(customXmlPart1); CustomXmlPropertiesPart customXmlPropertiesPart1 = customXmlPart1.AddNewPart<CustomXmlPropertiesPart>("rId1"); GenerateCustomXmlPropertiesPart1Content(customXmlPropertiesPart1); ThemePart themePart1 = mainDocumentPart1.AddNewPart<ThemePart>("rId6"); GenerateThemePart1Content(themePart1); FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart<FontTablePart>("rId5"); GenerateFontTablePart1Content(fontTablePart1); WebSettingsPart webSettingsPart1 = mainDocumentPart1.AddNewPart<WebSettingsPart>("rId4"); GenerateWebSettingsPart1Content(webSettingsPart1); SetPackageProperties(document); }
// Adds child parts and generates content of the specified part. private void CreateParts(WordprocessingDocument document) { ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId3"); GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1); MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart(); GenerateMainDocumentPart1Content(mainDocumentPart1); DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart<DocumentSettingsPart>("rId3"); GenerateDocumentSettingsPart1Content(documentSettingsPart1); StylesWithEffectsPart stylesWithEffectsPart1 = mainDocumentPart1.AddNewPart<StylesWithEffectsPart>("rId2"); GenerateStylesWithEffectsPart1Content(stylesWithEffectsPart1); StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart<StyleDefinitionsPart>("rId1"); GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1); ThemePart themePart1 = mainDocumentPart1.AddNewPart<ThemePart>("rId6"); GenerateThemePart1Content(themePart1); FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart<FontTablePart>("rId5"); GenerateFontTablePart1Content(fontTablePart1); WebSettingsPart webSettingsPart1 = mainDocumentPart1.AddNewPart<WebSettingsPart>("rId4"); GenerateWebSettingsPart1Content(webSettingsPart1); }
// Adds child parts and generates content of the specified part. private void CreateParts(WordprocessingDocument document) { ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId3"); GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1); MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart(); GenerateMainDocumentPart1Content(mainDocumentPart1); StylesWithEffectsPart stylesWithEffectsPart1 = mainDocumentPart1.AddNewPart<StylesWithEffectsPart>("rId3"); GenerateStylesWithEffectsPart1Content(stylesWithEffectsPart1); ThemePart themePart1 = mainDocumentPart1.AddNewPart<ThemePart>("rId7"); GenerateThemePart1Content(themePart1); StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart<StyleDefinitionsPart>("rId2"); GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1); CustomXmlPart customXmlPart1 = mainDocumentPart1.AddNewPart<CustomXmlPart>("application/xml", "rId1"); GenerateCustomXmlPart1Content(customXmlPart1); CustomXmlPropertiesPart customXmlPropertiesPart1 = customXmlPart1.AddNewPart<CustomXmlPropertiesPart>("rId1"); GenerateCustomXmlPropertiesPart1Content(customXmlPropertiesPart1); FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart<FontTablePart>("rId6"); GenerateFontTablePart1Content(fontTablePart1); WebSettingsPart webSettingsPart1 = mainDocumentPart1.AddNewPart<WebSettingsPart>("rId5"); GenerateWebSettingsPart1Content(webSettingsPart1); DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart<DocumentSettingsPart>("rId4"); GenerateDocumentSettingsPart1Content(documentSettingsPart1); documentSettingsPart1.AddExternalRelationship("http://schemas.openxmlformats.org/officeDocument/2006/relationships/attachedTemplate", new System.Uri("file:///D:\\Downloads\\FamilyMergeDoc%20(2).dotx", System.UriKind.Absolute), "rId1"); }
// Adds child parts and generates content of the specified part. private void CreateParts(WordprocessingDocument document, objPatientContract obj) { ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId3"); GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1); MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart(); GenerateMainDocumentPart1Content(mainDocumentPart1, obj); FooterPart footerPart1 = mainDocumentPart1.AddNewPart<FooterPart>("rId8"); GenerateFooterPart1Content(footerPart1); DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart<DocumentSettingsPart>("rId3"); GenerateDocumentSettingsPart1Content(documentSettingsPart1); HeaderPart headerPart1 = mainDocumentPart1.AddNewPart<HeaderPart>("rId7"); GenerateHeaderPart1Content(headerPart1); StylesWithEffectsPart stylesWithEffectsPart1 = mainDocumentPart1.AddNewPart<StylesWithEffectsPart>("rId2"); GenerateStylesWithEffectsPart1Content(stylesWithEffectsPart1); StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart<StyleDefinitionsPart>("rId1"); GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1); EndnotesPart endnotesPart1 = mainDocumentPart1.AddNewPart<EndnotesPart>("rId6"); GenerateEndnotesPart1Content(endnotesPart1); FootnotesPart footnotesPart1 = mainDocumentPart1.AddNewPart<FootnotesPart>("rId5"); GenerateFootnotesPart1Content(footnotesPart1); ThemePart themePart1 = mainDocumentPart1.AddNewPart<ThemePart>("rId10"); GenerateThemePart1Content(themePart1); WebSettingsPart webSettingsPart1 = mainDocumentPart1.AddNewPart<WebSettingsPart>("rId4"); GenerateWebSettingsPart1Content(webSettingsPart1); FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart<FontTablePart>("rId9"); GenerateFontTablePart1Content(fontTablePart1); SetPackageProperties(document); }
// Adds child parts and generates content of the specified part. private void CreateParts(WordprocessingDocument document) { ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId3"); GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1); MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart(); GenerateMainDocumentPart1Content(mainDocumentPart1); WebSettingsPart webSettingsPart1 = mainDocumentPart1.AddNewPart<WebSettingsPart>("rId8"); GenerateWebSettingsPart1Content(webSettingsPart1); FooterPart footerPart1 = mainDocumentPart1.AddNewPart<FooterPart>("rId13"); GenerateFooterPart1Content(footerPart1); footerPart1.AddHyperlinkRelationship(new System.Uri("http://bjcis/sites/techservices/Informational%20Documents/Forms/AllItems.aspx", System.UriKind.Absolute), true, "rId2"); footerPart1.AddHyperlinkRelationship(new System.Uri("http://bjcis/sites/techservices/Informational%20Documents/BJC%20IS%20Tech%20Management%20Standards.pdf", System.UriKind.Absolute), true, "rId1"); CustomXmlPart customXmlPart1 = mainDocumentPart1.AddNewPart<CustomXmlPart>("application/xml", "rId3"); GenerateCustomXmlPart1Content(customXmlPart1); CustomXmlPropertiesPart customXmlPropertiesPart1 = customXmlPart1.AddNewPart<CustomXmlPropertiesPart>("rId1"); GenerateCustomXmlPropertiesPart1Content(customXmlPropertiesPart1); DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart<DocumentSettingsPart>("rId7"); GenerateDocumentSettingsPart1Content(documentSettingsPart1); HeaderPart headerPart1 = mainDocumentPart1.AddNewPart<HeaderPart>("rId12"); GenerateHeaderPart1Content(headerPart1); ImagePart imagePart1 = headerPart1.AddNewPart<ImagePart>("image/png", "rId1"); GenerateImagePart1Content(imagePart1); CustomXmlPart customXmlPart2 = mainDocumentPart1.AddNewPart<CustomXmlPart>("application/xml", "rId2"); GenerateCustomXmlPart2Content(customXmlPart2); CustomXmlPropertiesPart customXmlPropertiesPart2 = customXmlPart2.AddNewPart<CustomXmlPropertiesPart>("rId1"); GenerateCustomXmlPropertiesPart2Content(customXmlPropertiesPart2); CustomXmlPart customXmlPart3 = mainDocumentPart1.AddNewPart<CustomXmlPart>("application/xml", "rId1"); GenerateCustomXmlPart3Content(customXmlPart3); CustomXmlPropertiesPart customXmlPropertiesPart3 = customXmlPart3.AddNewPart<CustomXmlPropertiesPart>("rId1"); GenerateCustomXmlPropertiesPart3Content(customXmlPropertiesPart3); StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart<StyleDefinitionsPart>("rId6"); GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1); ImagePart imagePart2 = mainDocumentPart1.AddNewPart<ImagePart>("image/x-emf", "rId11"); GenerateImagePart2Content(imagePart2); NumberingDefinitionsPart numberingDefinitionsPart1 = mainDocumentPart1.AddNewPart<NumberingDefinitionsPart>("rId5"); GenerateNumberingDefinitionsPart1Content(numberingDefinitionsPart1); ThemePart themePart1 = mainDocumentPart1.AddNewPart<ThemePart>("rId15"); GenerateThemePart1Content(themePart1); EndnotesPart endnotesPart1 = mainDocumentPart1.AddNewPart<EndnotesPart>("rId10"); GenerateEndnotesPart1Content(endnotesPart1); CustomXmlPart customXmlPart4 = mainDocumentPart1.AddNewPart<CustomXmlPart>("application/xml", "rId4"); GenerateCustomXmlPart4Content(customXmlPart4); CustomXmlPropertiesPart customXmlPropertiesPart4 = customXmlPart4.AddNewPart<CustomXmlPropertiesPart>("rId1"); GenerateCustomXmlPropertiesPart4Content(customXmlPropertiesPart4); FootnotesPart footnotesPart1 = mainDocumentPart1.AddNewPart<FootnotesPart>("rId9"); GenerateFootnotesPart1Content(footnotesPart1); FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart<FontTablePart>("rId14"); GenerateFontTablePart1Content(fontTablePart1); CustomFilePropertiesPart customFilePropertiesPart1 = document.AddNewPart<CustomFilePropertiesPart>("rId4"); GenerateCustomFilePropertiesPart1Content(customFilePropertiesPart1); SetPackageProperties(document); }
// Adds child parts and generates content of the specified part. private void CreateParts(WordprocessingDocument document) { ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId3"); GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1); MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart(); NumberingDefinitionsPart numberingDefinitionsPart1 = mainDocumentPart1.AddNewPart<NumberingDefinitionsPart>("rId1"); GenerateMainDocumentPart1Content(mainDocumentPart1); ImagePart imagePart1 = mainDocumentPart1.AddNewPart<ImagePart>("image/gif", "rId8"); GenerateImagePart1Content(imagePart1); FooterPart footerPart1 = mainDocumentPart1.AddNewPart<FooterPart>("rId13"); GenerateFooterPart1Content(footerPart1); ImagePart imagePart2 = footerPart1.AddNewPart<ImagePart>("image/gif", "rId2"); GenerateImagePart2Content(imagePart2); ImagePart imagePart3 = footerPart1.AddNewPart<ImagePart>("image/gif", "rId1"); GenerateImagePart3Content(imagePart3); DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart<DocumentSettingsPart>("rId3"); GenerateDocumentSettingsPart1Content(documentSettingsPart1); documentSettingsPart1.AddExternalRelationship("http://schemas.openxmlformats.org/officeDocument/2006/relationships/attachedTemplate", new System.Uri("file:///C:\\Documents%20and%20Settings\\ppelletier.RUSSELL\\Application%20Data\\Microsoft\\Templates\\RADAR%20Template.dot", System.UriKind.Absolute), "rId1"); ImagePart imagePartOverallEval1 = mainDocumentPart1.AddNewPart<ImagePart>("image/png", "rIdImgPartOverallEval1"); GenerateImagePartOverallEvalContent(imagePartOverallEval1, imagePartOverallEval1Data); ImagePart imagePartOverallEval2 = mainDocumentPart1.AddNewPart<ImagePart>("image/png", "rIdImgPartOverallEval2"); GenerateImagePartOverallEvalContent(imagePartOverallEval2, imagePartOverallEval2Data); ImagePart imagePartOverallEval3 = mainDocumentPart1.AddNewPart<ImagePart>("image/png", "rIdImgPartOverallEval3"); GenerateImagePartOverallEvalContent(imagePartOverallEval3, imagePartOverallEval3Data); ImagePart imagePartOverallEval4 = mainDocumentPart1.AddNewPart<ImagePart>("image/png", "rIdImgPartOverallEval4"); GenerateImagePartOverallEvalContent(imagePartOverallEval4, imagePartOverallEval4Data); HeaderPart headerPart1 = mainDocumentPart1.AddNewPart<HeaderPart>("rId12"); GenerateHeaderPart1Content(headerPart1); ImagePart imagePart5 = headerPart1.AddNewPart<ImagePart>("image/png", "rId1"); GenerateImagePart5Content(imagePart5); StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart<StyleDefinitionsPart>("rId2"); GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1); GenerateNumberingDefinitionsPart1Content(numberingDefinitionsPart1); EndnotesPart endnotesPart1 = mainDocumentPart1.AddNewPart<EndnotesPart>("rId6"); GenerateEndnotesPart1Content(endnotesPart1); FooterPart footerPart2 = mainDocumentPart1.AddNewPart<FooterPart>("rId11"); GenerateFooterPart2Content(footerPart2); footerPart2.AddPart(imagePart2, "rId2"); footerPart2.AddPart(imagePart3, "rId1"); FootnotesPart footnotesPart1 = mainDocumentPart1.AddNewPart<FootnotesPart>("rId5"); GenerateFootnotesPart1Content(footnotesPart1); ThemePart themePart1 = mainDocumentPart1.AddNewPart<ThemePart>("rId15"); GenerateThemePart1Content(themePart1); HeaderPart headerPart2 = mainDocumentPart1.AddNewPart<HeaderPart>("rId10"); GenerateHeaderPart2Content(headerPart2); ImagePart imagePart6 = headerPart2.AddNewPart<ImagePart>("image/jpeg", "rId1"); GenerateImagePart6Content(imagePart6); WebSettingsPart webSettingsPart1 = mainDocumentPart1.AddNewPart<WebSettingsPart>("rId4"); GenerateWebSettingsPart1Content(webSettingsPart1); ImagePart imagePartTopicRank1 = mainDocumentPart1.AddNewPart<ImagePart>("image/png", "rIdImgPartTopicRank1"); GenerateImagePartTopicRankContent(imagePartTopicRank1, imagePartTopicRank1Data); ImagePart imagePartTopicRank2 = mainDocumentPart1.AddNewPart<ImagePart>("image/png", "rIdImgPartTopicRank2"); GenerateImagePartTopicRankContent(imagePartTopicRank2, imagePartTopicRank2Data); ImagePart imagePartTopicRank3 = mainDocumentPart1.AddNewPart<ImagePart>("image/png", "rIdImgPartTopicRank3"); GenerateImagePartTopicRankContent(imagePartTopicRank3, imagePartTopicRank3Data); ImagePart imagePartTopicRank4 = mainDocumentPart1.AddNewPart<ImagePart>("image/png", "rIdImgPartTopicRank4"); GenerateImagePartTopicRankContent(imagePartTopicRank4, imagePartTopicRank4Data); ImagePart imagePartTopicRank5 = mainDocumentPart1.AddNewPart<ImagePart>("image/png", "rIdImgPartTopicRank5"); GenerateImagePartTopicRankContent(imagePartTopicRank5, imagePartTopicRank5Data); FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart<FontTablePart>("rId14"); GenerateFontTablePart1Content(fontTablePart1); SetPackageProperties(document); }
// Adds child parts and generates content of the specified part. private void CreateParts(WordprocessingDocument document, int reportId) { ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId3"); GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1); MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart(); List<customSection> objArray = new DocxReportMaker().GenerateReport(mainDocumentPart1, reportId); int counter = 1; // Add external image link foreach (customSection item in objArray) { if (item.Image != null) { item.Image.Link = "image" + counter.ToString(); counter++; mainDocumentPart1.AddExternalRelationship("http://schemas.openxmlformats.org/officeDocument/2006/relationships/image", new System.Uri(item.Image.Url, System.UriKind.Absolute), item.Image.Link); } } //mainDocumentPart1.AddExternalRelationship("http://schemas.openxmlformats.org/officeDocument/2006/relationships/image", // new System.Uri("http://www.montereybayaquarium.org/storage/promotions/200x125/g_sfw_inthenews.gif", System.UriKind.Absolute), "image1"); // main document area GenerateMainDocumentPart1Content(mainDocumentPart1, objArray); WebSettingsPart webSettingsPart1 = mainDocumentPart1.AddNewPart<WebSettingsPart>("rId3"); GenerateWebSettingsPart1Content(webSettingsPart1); DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart<DocumentSettingsPart>("rId2"); GenerateDocumentSettingsPart1Content(documentSettingsPart1); //StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart<StyleDefinitionsPart>("rId1"); //GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1); ThemePart themePart1 = mainDocumentPart1.AddNewPart<ThemePart>("rId5"); GenerateThemePart1Content(themePart1); FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart<FontTablePart>("rId4"); GenerateFontTablePart1Content(fontTablePart1); SetPackageProperties(document); }
// Adds child parts and generates content of the specified part. private void CreateParts(WordprocessingDocument document) { ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId3"); GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1); object oMissing = System.Reflection.Missing.Value; MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart(); GenerateMainDocumentPart1Content(mainDocumentPart1); ChartPart chartPart1 = mainDocumentPart1.AddNewPart<ChartPart>("rId13"); GenerateChartPart1Content(chartPart1); EmbeddedPackagePart embeddedPackagePart1 = chartPart1.AddNewPart<EmbeddedPackagePart>("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "rId1"); GenerateEmbeddedPackagePart1Content(embeddedPackagePart1); DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart<DocumentSettingsPart>("rId3"); GenerateDocumentSettingsPart1Content(documentSettingsPart1); ChartPart chartPart2 = mainDocumentPart1.AddNewPart<ChartPart>("rId7"); GenerateChartPart2Content(chartPart2); EmbeddedPackagePart embeddedPackagePart2 = chartPart2.AddNewPart<EmbeddedPackagePart>("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "rId1"); GenerateEmbeddedPackagePart2Content(embeddedPackagePart2); using (Stream str = embeddedPackagePart2.GetStream()) using (MemoryStream ms = new MemoryStream()) { CopyStream(str, ms); using (SpreadsheetDocument spreadsheetDoc = SpreadsheetDocument.Open(ms, true)) { // Update data in spreadsheet // Find first worksheet ss.Sheet ws = (ss.Sheet)spreadsheetDoc.WorkbookPart .Workbook.Sheets .FirstOrDefault(); string sheetId = ws.Id; WorksheetPart wsp = (WorksheetPart)spreadsheetDoc .WorkbookPart .Parts .Where(pt => pt.RelationshipId == sheetId) .FirstOrDefault() .OpenXmlPart; ss.SheetData sd = wsp .Worksheet .Elements<ss.SheetData>() .FirstOrDefault(); foreach (ss.Row tsd in sd.Elements<ss.Row>()) { if (tsd.Elements<ss.Cell>().Count()> 1) { ss.Cell cell1 = tsd.Elements<ss.Cell>() .ElementAt(1); if (cell1 != null) { ss.CellValue cell1value = cell1.Elements<ss.CellValue>().FirstOrDefault(); System.Console.WriteLine(cell1value.InnerText+cell1value.Text); if (cell1value != null && !cell1value.InnerText.Equals("0")) { cell1value.Text = "25"; } } } } } // Write the modified memory stream back // into the embedded package part. System.Console.WriteLine(Getbase64String(ms)); if(!embeddedPackagePart2Data.Equals(Getbase64String(ms))) embeddedPackagePart2Data = Getbase64String(ms); ms.Close(); } GenerateEmbeddedPackagePart2Content(embeddedPackagePart2); StylesWithEffectsPart stylesWithEffectsPart1 = mainDocumentPart1.AddNewPart<StylesWithEffectsPart>("rId2"); GenerateStylesWithEffectsPart1Content(stylesWithEffectsPart1); ThemePart themePart1 = mainDocumentPart1.AddNewPart<ThemePart>("rId16"); GenerateThemePart1Content(themePart1); StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart<StyleDefinitionsPart>("rId1"); GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1); EndnotesPart endnotesPart1 = mainDocumentPart1.AddNewPart<EndnotesPart>("rId6"); GenerateEndnotesPart1Content(endnotesPart1); FootnotesPart footnotesPart1 = mainDocumentPart1.AddNewPart<FootnotesPart>("rId5"); GenerateFootnotesPart1Content(footnotesPart1); FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart<FontTablePart>("rId15"); GenerateFontTablePart1Content(fontTablePart1); WebSettingsPart webSettingsPart1 = mainDocumentPart1.AddNewPart<WebSettingsPart>("rId4"); GenerateWebSettingsPart1Content(webSettingsPart1); HeaderPart headerPart1 = mainDocumentPart1.AddNewPart<HeaderPart>("rId14"); GenerateHeaderPart1Content(headerPart1); mainDocumentPart1.AddHyperlinkRelationship(new System.Uri("http://en.wikipedia.org/wiki/Million", System.UriKind.Absolute), true, "rId8"); mainDocumentPart1.AddHyperlinkRelationship(new System.Uri("http://en.wikipedia.org/wiki/Quadrillion", System.UriKind.Absolute), true, "rId12"); mainDocumentPart1.AddHyperlinkRelationship(new System.Uri("http://en.wikipedia.org/wiki/Trillion", System.UriKind.Absolute), true, "rId11"); mainDocumentPart1.AddHyperlinkRelationship(new System.Uri("http://en.wikipedia.org/wiki/Billion", System.UriKind.Absolute), true, "rId10"); mainDocumentPart1.AddHyperlinkRelationship(new System.Uri("http://en.wikipedia.org/wiki/1,000,000,000", System.UriKind.Absolute), true, "rId9"); SetPackageProperties(document); }
// Adds child parts and generates content of the specified part. private void CreateParts(WordprocessingDocument document) { ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId3"); GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1); MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart(); GenerateMainDocumentPart1Content(mainDocumentPart1); FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart<FontTablePart>("rId13"); GenerateFontTablePart1Content(fontTablePart1); StylesWithEffectsPart stylesWithEffectsPart1 = mainDocumentPart1.AddNewPart<StylesWithEffectsPart>("rId3"); GenerateStylesWithEffectsPart1Content(stylesWithEffectsPart1); EndnotesPart endnotesPart1 = mainDocumentPart1.AddNewPart<EndnotesPart>("rId7"); GenerateEndnotesPart1Content(endnotesPart1); FooterPart footerPart1 = mainDocumentPart1.AddNewPart<FooterPart>("rId12"); GenerateFooterPart1Content(footerPart1); StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart<StyleDefinitionsPart>("rId2"); GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1); CustomXmlPart customXmlPart1 = mainDocumentPart1.AddNewPart<CustomXmlPart>("application/xml", "rId1"); GenerateCustomXmlPart1Content(customXmlPart1); CustomXmlPropertiesPart customXmlPropertiesPart1 = customXmlPart1.AddNewPart<CustomXmlPropertiesPart>("rId1"); GenerateCustomXmlPropertiesPart1Content(customXmlPropertiesPart1); FootnotesPart footnotesPart1 = mainDocumentPart1.AddNewPart<FootnotesPart>("rId6"); GenerateFootnotesPart1Content(footnotesPart1); HeaderPart headerPart1 = mainDocumentPart1.AddNewPart<HeaderPart>("rId11"); GenerateHeaderPart1Content(headerPart1); WebSettingsPart webSettingsPart1 = mainDocumentPart1.AddNewPart<WebSettingsPart>("rId5"); GenerateWebSettingsPart1Content(webSettingsPart1); FooterPart footerPart2 = mainDocumentPart1.AddNewPart<FooterPart>("rId10"); GenerateFooterPart2Content(footerPart2); DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart<DocumentSettingsPart>("rId4"); GenerateDocumentSettingsPart1Content(documentSettingsPart1); HeaderPart headerPart2 = mainDocumentPart1.AddNewPart<HeaderPart>("rId9"); GenerateHeaderPart2Content(headerPart2); ThemePart themePart1 = mainDocumentPart1.AddNewPart<ThemePart>("rId14"); GenerateThemePart1Content(themePart1); }
// Adds child parts and generates content of the specified part. private void CreateParts(WordprocessingDocument document) { ExtendedPart extendedPart1 = document.AddExtendedPart("http://schemas.openxmlformats.org/officedocument/2006/relationships/metadata/core-properties", "application/vnd.openxmlformats-package.core-properties+xml", "xml", "rId1"); GenerateExtendedPart1Content(extendedPart1); ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId2"); GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1); MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart(); GenerateMainDocumentPart1Content(mainDocumentPart1); StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart<StyleDefinitionsPart>("rId1"); GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1); FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart<FontTablePart>("rId2"); GenerateFontTablePart1Content(fontTablePart1); DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart<DocumentSettingsPart>("rId3"); GenerateDocumentSettingsPart1Content(documentSettingsPart1); TableRow tet = GenTab(); // mainDocumentPart1.Document.Body.ChildElements.GetItem(1).Append(tet); mainDocumentPart1.Document.Body.ChildElements.GetItem(1).InsertAt(tet, 50); SetPackageProperties(document); }