// Adds child parts and generates content of the specified part.
private void CreateParts(SpreadsheetDocument document, List <ProjectFile> projectFiles)
{
ExtendedFilePropertiesPart extendedFileProperties = document.AddNewPart <ExtendedFilePropertiesPart>("rId3");
GenerateExtendedFilePropertiesContent(extendedFileProperties);
WorkbookPart workbook = document.AddWorkbookPart();
GenerateWorkbookContent(workbook);
WorkbookStylesPart workbookStyles = workbook.AddNewPart <WorkbookStylesPart>("rId2");
GenerateWorkbookStylesContent(workbookStyles);
//from this point is the content
WorksheetPart worksheet = workbook.AddNewPart <WorksheetPart>("rId1");
GenerateWorksheetContent(worksheet, projectFiles);
SharedStringTablePart sharedStringTablePart = workbook.AddNewPart <SharedStringTablePart>("rId4");
GenerateSharedStringTablePartContent(sharedStringTablePart);
SetPackageProperties(document);
}
// Generates content of extendedFileProperties.
private void GenerateExtendedFilePropertiesContent(ExtendedFilePropertiesPart extendedFileProperties)
{
extendedFileProperties.Properties = new DocumentFormat.OpenXml.ExtendedProperties.Properties();
extendedFileProperties.Properties.AddNamespaceDeclaration("vt", "http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes");
extendedFileProperties.Properties.Append(new DocumentFormat.OpenXml.ExtendedProperties.Application()
{
Text = "Microsoft Excel"
});
}
private void CreatePartsSubsectorPollutionSourceFieldSheet(SpreadsheetDocument document)
{
int SheetOrdinal = 0;
BaseEnumService baseEnumService = new BaseEnumService(_TaskRunnerBaseService._BWObj.appTaskModel.Language);
TVItemService tvItemService = new TVItemService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
List <string> SheetNameList = new List <string>();
SheetNameList.Add("Active - " + baseEnumService.GetEnumText_TVTypeEnum(TVTypeEnum.Subsector));
SheetNameList.Add("Inactive - " + baseEnumService.GetEnumText_TVTypeEnum(TVTypeEnum.Subsector));
XlsxBase.AddSheetNameAndID(SheetNameList[0]);
XlsxBase.AddSheetNameAndID(SheetNameList[1]);
ExtendedFilePropertiesPart extendedFilePropertiesPart = document.AddNewPart <ExtendedFilePropertiesPart>("rId1000");
XlsxBase.GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart);
WorkbookPart workbookPart = document.AddWorkbookPart();
XlsxBase.GenerateWorkbookPart1Content(workbookPart);
SheetOrdinal = 0;
WorksheetPart worksheetA = workbookPart.AddNewPart <WorksheetPart>(XlsxBase.sheetNameAndIDList[SheetOrdinal].SheetID);
GenerateWorksheetAContentSubsectorPollutionSourceFieldSheet(worksheetA, workbookPart.Workbook, SheetNameList[0], SheetOrdinal, true);
foreach (UsedHyperlink usedHyperlink in XlsxBase.UsedHyperlinkList)
{
worksheetA.AddHyperlinkRelationship(new System.Uri(usedHyperlink.URL, System.UriKind.Absolute), true, usedHyperlink.Id);
}
SheetOrdinal = 1;
WorksheetPart worksheetB = workbookPart.AddNewPart <WorksheetPart>(XlsxBase.sheetNameAndIDList[SheetOrdinal].SheetID);
GenerateWorksheetAContentSubsectorPollutionSourceFieldSheet(worksheetB, workbookPart.Workbook, SheetNameList[1], SheetOrdinal, false);
foreach (UsedHyperlink usedHyperlink in XlsxBase.UsedHyperlinkList)
{
worksheetB.AddHyperlinkRelationship(new System.Uri(usedHyperlink.URL, System.UriKind.Absolute), true, usedHyperlink.Id);
}
SharedStringTablePart sharedStringTablePart = workbookPart.AddNewPart <SharedStringTablePart>("rId2000");
XlsxBase.GenerateSharedStringTablePart1Content(sharedStringTablePart);
WorkbookStylesPart workbookStylesPart = workbookPart.AddNewPart <WorkbookStylesPart>("rId3000");
XlsxBase.GenerateWorkbookStylesPart1Content(workbookStylesPart);
ThemePart themePart = workbookPart.AddNewPart <ThemePart>("rId4000");
XlsxBase.GenerateThemePart1Content(themePart);
XlsxBase.SetPackageProperties(document);
}
/************************************************************************/
#region Constructor (internal)
/// <summary>
/// Initializes a new instance of the <see cref="ExtendedProperties"/> class.
/// </summary>
/// <param name="part">The extended file properties part.</param>
internal ExtendedProperties(ExtendedFilePropertiesPart part)
{
if (part != null && part.Properties != null)
{
if (part.Properties.Company != null)
{
Company = part.Properties.Company.Text;
}
}
}
private void CreateParts(SpreadsheetDocument document)
{
int SheetOrdinal = 0;
BaseEnumService baseEnumService = new BaseEnumService(_TaskRunnerBaseService._BWObj.appTaskModel.Language);
TVItemService tvItemService = new TVItemService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
XlsxBase.AddSheetNameAndID(baseEnumService.GetEnumText_TVTypeEnum(TVTypeEnum.Province));
ExtendedFilePropertiesPart extendedFilePropertiesPart = document.AddNewPart <ExtendedFilePropertiesPart>("rId1000");
XlsxBase.GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart);
WorkbookPart workbookPart = document.AddWorkbookPart();
XlsxBase.GenerateWorkbookPart1Content(workbookPart);
// update percentage
_TaskRunnerBaseService.SendPercentToDB(_TaskRunnerBaseService._BWObj.appTaskModel.AppTaskID, 10);
SheetOrdinal = 0;
WorksheetPart worksheetA = workbookPart.AddNewPart <WorksheetPart>(XlsxBase.sheetNameAndIDList[SheetOrdinal].SheetID);
GenerateWorksheetAContent(worksheetA, SheetOrdinal);
// update percentage
_TaskRunnerBaseService.SendPercentToDB(_TaskRunnerBaseService._BWObj.appTaskModel.AppTaskID, 30);
foreach (UsedHyperlink usedHyperlink in XlsxBase.UsedHyperlinkList)
{
worksheetA.AddHyperlinkRelationship(new System.Uri(usedHyperlink.URL, System.UriKind.Absolute), true, usedHyperlink.Id);
}
SharedStringTablePart sharedStringTablePart = workbookPart.AddNewPart <SharedStringTablePart>("rId2000");
XlsxBase.GenerateSharedStringTablePart1Content(sharedStringTablePart);
WorkbookStylesPart workbookStylesPart = workbookPart.AddNewPart <WorkbookStylesPart>("rId3000");
XlsxBase.GenerateWorkbookStylesPart1Content(workbookStylesPart);
ThemePart themePart = workbookPart.AddNewPart <ThemePart>("rId4000");
XlsxBase.GenerateThemePart1Content(themePart);
XlsxBase.SetPackageProperties(document);
}
/// <summary>
/// Создает заготовку для документа Excel
/// </summary>
/// <param name="fileName">Полный путь к файлу</param>
private void CreateSpreadSheetWorkBook(string fileName)
{
_document = SpreadsheetDocument.Create(fileName, SpreadsheetDocumentType.Workbook);
SetPackageProperties();
ExtendedFilePropertiesPart extendedPropertiesPart = _document.AddExtendedFilePropertiesPart();
GenerateExtendedProperties(extendedPropertiesPart);
_workbookPart = _document.AddWorkbookPart();
WorkbookStylesPart workbookStyles = _workbookPart.AddNewPart <WorkbookStylesPart>("rId3");
GenerateStyles(workbookStyles);
_workbookPart.Workbook = new Workbook();
_workbookPart.Workbook.AppendChild(new Sheets());
}
//gavdcodeend 04
//gavdcodebegin 05
public static void WordOpenXmlFindPropertiesDocument()
{
using (WordprocessingDocument myWordDoc =
WordprocessingDocument.Open(@"C:\Temporary\WordDoc01.docx", false))
{
ExtendedFilePropertiesPart docPart = myWordDoc.ExtendedFilePropertiesPart;
DocumentFormat.OpenXml.ExtendedProperties.Properties myProps =
docPart.Properties;
PropertyInfo[] myPropsInfo = myProps.GetType().GetProperties();
foreach (var oneProp in myPropsInfo)
{
string propName = oneProp.Name;
try
{
var propValue = oneProp.GetValue(myProps) ?? "(null)";
Console.WriteLine(propName + " - " + propValue.ToString());
}
catch { }
}
}
}
public static WmlDocument BreakLinkToTemplate(WmlDocument source)
{
using (var ms = new MemoryStream())
{
ms.Write(source.DocumentByteArray, 0, source.DocumentByteArray.Length);
using (WordprocessingDocument wDoc = WordprocessingDocument.Open(ms, true))
{
ExtendedFilePropertiesPart efpp = wDoc.ExtendedFilePropertiesPart;
if (efpp != null)
{
XDocument xd = efpp.GetXDocument();
XElement template = xd.Descendants(EP.Template).FirstOrDefault();
if (template != null)
{
template.Value = "";
}
efpp.PutXDocument();
}
}
var result = new WmlDocument(source.FileName, ms.ToArray());
return(result);
}
}
private void CreateParts(WordprocessingDocument document)
{
DocxBase.CurrentTitle = DocxServiceProvinceRes.Title;
ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart <ExtendedFilePropertiesPart>("rId3");
DocxBase.GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1);
MainDocumentPart mainDocumentPart1 = document.AddMainDocumentPart();
GenerateMainDocumentPart1Content(mainDocumentPart1);
FontTablePart fontTablePart1 = mainDocumentPart1.AddNewPart <FontTablePart>("rId13");
DocxBase.GenerateFontTablePart1Content(fontTablePart1);
StyleDefinitionsPart styleDefinitionsPart1 = mainDocumentPart1.AddNewPart <StyleDefinitionsPart>("rId3");
DocxBase.GenerateStyleDefinitionsPart1Content(styleDefinitionsPart1);
EndnotesPart endnotesPart1 = mainDocumentPart1.AddNewPart <EndnotesPart>("rId7");
DocxBase.GenerateEndnotesPart1Content(endnotesPart1);
FooterPart footerPart1 = mainDocumentPart1.AddNewPart <FooterPart>("rId12");
DocxBase.GenerateFooterPart1Content(footerPart1);
NumberingDefinitionsPart numberingDefinitionsPart1 = mainDocumentPart1.AddNewPart <NumberingDefinitionsPart>("rId2");
DocxBase.GenerateNumberingDefinitionsPart1Content(numberingDefinitionsPart1);
CustomXmlPart customXmlPart1 = mainDocumentPart1.AddNewPart <CustomXmlPart>("application/xml", "rId1");
DocxBase.GenerateCustomXmlPart1Content(customXmlPart1);
CustomXmlPropertiesPart customXmlPropertiesPart1 = customXmlPart1.AddNewPart <CustomXmlPropertiesPart>("rId1");
DocxBase.GenerateCustomXmlPropertiesPart1Content(customXmlPropertiesPart1);
FootnotesPart footnotesPart1 = mainDocumentPart1.AddNewPart <FootnotesPart>("rId6");
DocxBase.GenerateFootnotesPart1Content(footnotesPart1);
HeaderPart headerPart1 = mainDocumentPart1.AddNewPart <HeaderPart>("rId11");
DocxBase.GenerateHeaderPart1Content(headerPart1);
WebSettingsPart webSettingsPart1 = mainDocumentPart1.AddNewPart <WebSettingsPart>("rId5");
DocxBase.GenerateWebSettingsPart1Content(webSettingsPart1);
//ChartPart chartPart1 = mainDocumentPart1.AddNewPart<ChartPart>("rId10");
//DocxBase.GenerateChartPart1Content(chartPart1);
//EmbeddedPackagePart embeddedPackagePart1 = chartPart1.AddNewPart<EmbeddedPackagePart>("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "rId3");
//DocxBase.GenerateEmbeddedPackagePart1Content(embeddedPackagePart1);
//ChartColorStylePart chartColorStylePart1 = chartPart1.AddNewPart<ChartColorStylePart>("rId2");
//DocxBase.GenerateChartColorStylePart1Content(chartColorStylePart1);
//ChartStylePart chartStylePart1 = chartPart1.AddNewPart<ChartStylePart>("rId1");
//DocxBase.GenerateChartStylePart1Content(chartStylePart1);
DocumentSettingsPart documentSettingsPart1 = mainDocumentPart1.AddNewPart <DocumentSettingsPart>("rId4");
DocxBase.GenerateDocumentSettingsPart1Content(documentSettingsPart1);
//ChartPart chartPart2 = mainDocumentPart1.AddNewPart<ChartPart>("rId9");
//DocxBase.GenerateChartPart2Content(chartPart2);
//EmbeddedPackagePart embeddedPackagePart2 = chartPart2.AddNewPart<EmbeddedPackagePart>("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "rId3");
//DocxBase.GenerateEmbeddedPackagePart2Content(embeddedPackagePart2);
//ChartColorStylePart chartColorStylePart2 = chartPart2.AddNewPart<ChartColorStylePart>("rId2");
//DocxBase.GenerateChartColorStylePart2Content(chartColorStylePart2);
//ChartStylePart chartStylePart2 = chartPart2.AddNewPart<ChartStylePart>("rId1");
//DocxBase.GenerateChartStylePart2Content(chartStylePart2);
ThemePart themePart1 = mainDocumentPart1.AddNewPart <ThemePart>("rId14");
DocxBase.GenerateThemePart1Content(themePart1);
foreach (UsedHyperlink usedHyperlink in DocxBase.UsedHyperlinkList)
{
mainDocumentPart1.AddHyperlinkRelationship(new System.Uri(usedHyperlink.URL, System.UriKind.Absolute), true, usedHyperlink.Id.ToString());
}
DocxBase.SetPackageProperties(document);
}
private static ExtendedFilePropertiesPart MakeValidExtendedFilePropertiesPart(ExtendedFilePropertiesPart extendedFilePropertiesPart)
{
byte[] blob = System.Text.Encoding.UTF8.GetBytes("<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><Properties xmlns=\"http://schemas.openxmlformats.org/officeDocument/2006/extended-properties\" xmlns:vt=\"http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes\"></Properties>");
using (MemoryStream stream = new MemoryStream(blob))
{
extendedFilePropertiesPart.FeedData(stream);
}
return(extendedFilePropertiesPart);
}
// Generates content of extendedFilePropertiesPart1.
private static void GenerateExtendedFilePropertiesPart1Content(ExtendedFilePropertiesPart extendedFilePropertiesPart1)
{
var properties1 = new Ap.Properties();
properties1.AddNamespaceDeclaration("vt", "http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes");
var totalTime1 = new Ap.TotalTime {
Text = "0"
};
var application1 = new Ap.Application {
Text = "Microsoft Excel"
};
var documentSecurity1 = new Ap.DocumentSecurity {
Text = "0"
};
var scaleCrop1 = new Ap.ScaleCrop {
Text = "false"
};
var headingPairs1 = new Ap.HeadingPairs();
var vTVector1 = new Vt.VTVector {
BaseType = Vt.VectorBaseValues.Variant, Size = 2U
};
var variant1 = new Vt.Variant();
var vTlpstr1 = new Vt.VTLPSTR {
Text = "Arbeitsblätter"
};
variant1.Append(vTlpstr1);
var variant2 = new Vt.Variant();
var vTInt321 = new Vt.VTInt32 {
Text = "3"
};
variant2.Append(vTInt321);
vTVector1.Append(variant1);
vTVector1.Append(variant2);
headingPairs1.Append(vTVector1);
var titlesOfParts1 = new Ap.TitlesOfParts();
var vTVector2 = new Vt.VTVector {
BaseType = Vt.VectorBaseValues.Lpstr, Size = 3U
};
var vTlpstr2 = new Vt.VTLPSTR {
Text = "Tabelle1"
};
var vTlpstr3 = new Vt.VTLPSTR {
Text = "Tabelle2"
};
var vTlpstr4 = new Vt.VTLPSTR {
Text = "Tabelle3"
};
vTVector2.Append(vTlpstr2);
vTVector2.Append(vTlpstr3);
vTVector2.Append(vTlpstr4);
titlesOfParts1.Append(vTVector2);
var company1 = new Ap.Company {
Text = "Bodoconsult EDV-Dienstleistungen GmbH"
};
var linksUpToDate1 = new Ap.LinksUpToDate {
Text = "false"
};
var sharedDocument1 = new Ap.SharedDocument {
Text = "false"
};
var hyperlinksChanged1 = new Ap.HyperlinksChanged {
Text = "false"
};
var applicationVersion1 = new Ap.ApplicationVersion {
Text = "14.0300"
};
properties1.Append(totalTime1);
properties1.Append(application1);
properties1.Append(documentSecurity1);
properties1.Append(scaleCrop1);
properties1.Append(headingPairs1);
properties1.Append(titlesOfParts1);
properties1.Append(company1);
properties1.Append(linksUpToDate1);
properties1.Append(sharedDocument1);
properties1.Append(hyperlinksChanged1);
properties1.Append(applicationVersion1);
extendedFilePropertiesPart1.Properties = properties1;
}
/// <summary>
/// Создает расширенные свойства документа
/// </summary>
/// <param name="extendedPropertiesPart"></param>
private void GenerateExtendedProperties(ExtendedFilePropertiesPart extendedPropertiesPart)
{
Ap.Properties properties = new Ap.Properties();
properties.AddNamespaceDeclaration("vt",
"http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes");
Ap.Application application = new Ap.Application {
Text = "Microsoft Excel"
};
Ap.DocumentSecurity documentSecurity = new Ap.DocumentSecurity {
Text = "0"
};
Ap.ScaleCrop scaleCrop = new Ap.ScaleCrop()
{
Text = "false"
};
Ap.HeadingPairs headingPairs = new Ap.HeadingPairs();
Vt.VTVector vtVector = new Vt.VTVector()
{
BaseType = Vt.VectorBaseValues.Variant,
Size = 2U
};
Vt.Variant variant1 = new Vt.Variant();
Vt.VTLPSTR vtlpstr = new Vt.VTLPSTR()
{
Text = "Spreadsheets"
};
variant1.Append(vtlpstr);
Vt.Variant variant2 = new Vt.Variant();
Vt.VTInt32 vtInt32 = new Vt.VTInt32()
{
Text = "1"
};
variant2.Append(vtInt32);
vtVector.Append(variant1);
vtVector.Append(variant2);
headingPairs.Append(vtVector);
Ap.TitlesOfParts titlesOfParts = new Ap.TitlesOfParts();
Vt.VTVector vtVector2 = new Vt.VTVector()
{
BaseType = Vt.VectorBaseValues.Lpstr,
Size = 1U
};
Vt.VTLPSTR vtlpstr2 = new Vt.VTLPSTR()
{
Text = "testSheet"
};
vtVector2.Append(vtlpstr2);
titlesOfParts.Append(vtVector2);
Ap.Company company = new Ap.Company()
{
Text = "BIT LLC"
};
Ap.LinksUpToDate linksUpToDate = new Ap.LinksUpToDate()
{
Text = "false"
};
Ap.SharedDocument sharedDocument = new Ap.SharedDocument()
{
Text = "false"
};
Ap.HyperlinksChanged hyperlinksChanged = new Ap.HyperlinksChanged()
{
Text = "false"
};
Ap.ApplicationVersion applicationVersion = new Ap.ApplicationVersion()
{
Text = "15.0300"
};
properties.Append(application);
properties.Append(documentSecurity);
properties.Append(scaleCrop);
properties.Append(headingPairs);
properties.Append(titlesOfParts);
properties.Append(company);
properties.Append(linksUpToDate);
properties.Append(sharedDocument);
properties.Append(hyperlinksChanged);
properties.Append(applicationVersion);
extendedPropertiesPart.Properties = properties;
}
public static void GenerateExtendedFilePropertiesPart1Content(ExtendedFilePropertiesPart extendedFilePropertiesPart1)
{
var properties1 = new DocumentFormat.OpenXml.ExtendedProperties.Properties();
properties1.AddNamespaceDeclaration("vt", "http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes");
var template1 =
new DocumentFormat.OpenXml.ExtendedProperties.Template {
Text = "Normal"
};
var totalTime1 =
new DocumentFormat.OpenXml.ExtendedProperties.TotalTime {
Text = "5"
};
//var pages1 = new DocumentFormat.OpenXml.ExtendedProperties.Pages {Text = "7"};
//var words1 = new DocumentFormat.OpenXml.ExtendedProperties.Words {Text = "1216"};
//var characters1 = new DocumentFormat.OpenXml.ExtendedProperties.Characters {Text = "6936"};
var application1 =
new DocumentFormat.OpenXml.ExtendedProperties.Application {
Text = "Microsoft Office Word"
};
var documentSecurity1 = new DocumentFormat.OpenXml.ExtendedProperties.DocumentSecurity {
Text = "0"
};
//var lines1 = new DocumentFormat.OpenXml.ExtendedProperties.Lines {Text = "57"};
//var paragraphs1 =
new DocumentFormat.OpenXml.ExtendedProperties.Paragraphs {
Text = "16"
};
var scaleCrop1 = new DocumentFormat.OpenXml.ExtendedProperties.ScaleCrop {
Text = "false"
};
var headingPairs1 = new DocumentFormat.OpenXml.ExtendedProperties.HeadingPairs();
var vTVector1 = new DocumentFormat.OpenXml.VariantTypes.VTVector {
BaseType = DocumentFormat.OpenXml.VariantTypes.VectorBaseValues.Variant, Size = 2U
};
var variant1 = new DocumentFormat.OpenXml.VariantTypes.Variant();
var vTLPSTR1 = new DocumentFormat.OpenXml.VariantTypes.VTLPSTR {
Text = "Title"
};
variant1.Append(vTLPSTR1);
var variant2 = new DocumentFormat.OpenXml.VariantTypes.Variant();
var vTInt321 = new DocumentFormat.OpenXml.VariantTypes.VTInt32 {
Text = "1"
};
variant2.Append(vTInt321);
vTVector1.Append(variant1);
vTVector1.Append(variant2);
headingPairs1.Append(vTVector1);
var titlesOfParts1 = new DocumentFormat.OpenXml.ExtendedProperties.TitlesOfParts();
var vTVector2 = new DocumentFormat.OpenXml.VariantTypes.VTVector {
BaseType = DocumentFormat.OpenXml.VariantTypes.VectorBaseValues.Lpstr, Size = 1U
};
var vTLPSTR2 =
new DocumentFormat.OpenXml.VariantTypes.VTLPSTR {
Text = ""
};
vTVector2.Append(vTLPSTR2);
titlesOfParts1.Append(vTVector2);
var manager1 = new DocumentFormat.OpenXml.ExtendedProperties.Manager {
Text = ""
};
var company1 = new DocumentFormat.OpenXml.ExtendedProperties.Company {
Text = ""
};
var linksUpToDate1 = new DocumentFormat.OpenXml.ExtendedProperties.LinksUpToDate {
Text = "false"
};
var charactersWithSpaces1 =
new DocumentFormat.OpenXml.ExtendedProperties.CharactersWithSpaces {
Text = "8136"
};
var sharedDocument1 = new DocumentFormat.OpenXml.ExtendedProperties.SharedDocument {
Text = "false"
};
var hyperlinksChanged1 = new DocumentFormat.OpenXml.ExtendedProperties.HyperlinksChanged {
Text = "false"
};
var applicationVersion1 =
new DocumentFormat.OpenXml.ExtendedProperties.ApplicationVersion {
Text = "16.0000"
};
properties1.Append(template1);
properties1.Append(totalTime1);
//properties1.Append(pages1);
//properties1.Append(words1);
//properties1.Append(characters1);
properties1.Append(application1);
properties1.Append(documentSecurity1);
//properties1.Append(lines1);
//properties1.Append(paragraphs1);
properties1.Append(scaleCrop1);
properties1.Append(headingPairs1);
properties1.Append(titlesOfParts1);
properties1.Append(manager1);
properties1.Append(company1);
properties1.Append(linksUpToDate1);
properties1.Append(charactersWithSpaces1);
properties1.Append(sharedDocument1);
properties1.Append(hyperlinksChanged1);
properties1.Append(applicationVersion1);
extendedFilePropertiesPart1.Properties = properties1;
}
public static void GenerateExtendedFilePropertiesPart1Content(ExtendedFilePropertiesPart extendedFilePropertiesPart1)
{
Ap.Properties properties1 = new Ap.Properties();
properties1.AddNamespaceDeclaration("vt", "http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes");
Ap.Template template1 = new Ap.Template();
template1.Text = "Macintosh HD:Users:katmccord:Desktop:NAS001_FINRA_Presentation_071907.pot";
Ap.TotalTime totalTime1 = new Ap.TotalTime();
totalTime1.Text = "0";
Ap.Words words1 = new Ap.Words();
words1.Text = "157";
Ap.Application application1 = new Ap.Application();
application1.Text = "Microsoft Office PowerPoint";
Ap.PresentationFormat presentationFormat1 = new Ap.PresentationFormat();
presentationFormat1.Text = "A4 Paper (210x297 mm)";
Ap.Paragraphs paragraphs1 = new Ap.Paragraphs();
paragraphs1.Text = "27";
Ap.Slides slides1 = new Ap.Slides();
slides1.Text = "1";
Ap.Notes notes1 = new Ap.Notes();
notes1.Text = "1";
Ap.HiddenSlides hiddenSlides1 = new Ap.HiddenSlides();
hiddenSlides1.Text = "0";
Ap.MultimediaClips multimediaClips1 = new Ap.MultimediaClips();
multimediaClips1.Text = "0";
Ap.ScaleCrop scaleCrop1 = new Ap.ScaleCrop();
scaleCrop1.Text = "false";
Ap.HeadingPairs headingPairs1 = new Ap.HeadingPairs();
Vt.VTVector vTVector1 = new Vt.VTVector()
{
BaseType = Vt.VectorBaseValues.Variant, Size = (UInt32Value)6U
};
Vt.Variant variant1 = new Vt.Variant();
Vt.VTLPSTR vTLPSTR1 = new Vt.VTLPSTR();
vTLPSTR1.Text = "Fonts Used";
variant1.Append(vTLPSTR1);
Vt.Variant variant2 = new Vt.Variant();
Vt.VTInt32 vTInt321 = new Vt.VTInt32();
vTInt321.Text = "5";
variant2.Append(vTInt321);
Vt.Variant variant3 = new Vt.Variant();
Vt.VTLPSTR vTLPSTR2 = new Vt.VTLPSTR();
vTLPSTR2.Text = "Theme";
variant3.Append(vTLPSTR2);
Vt.Variant variant4 = new Vt.Variant();
Vt.VTInt32 vTInt322 = new Vt.VTInt32();
vTInt322.Text = "1";
variant4.Append(vTInt322);
Vt.Variant variant5 = new Vt.Variant();
Vt.VTLPSTR vTLPSTR3 = new Vt.VTLPSTR();
vTLPSTR3.Text = "Slide Titles";
variant5.Append(vTLPSTR3);
Vt.Variant variant6 = new Vt.Variant();
Vt.VTInt32 vTInt323 = new Vt.VTInt32();
vTInt323.Text = "1";
variant6.Append(vTInt323);
vTVector1.Append(variant1);
vTVector1.Append(variant2);
vTVector1.Append(variant3);
vTVector1.Append(variant4);
vTVector1.Append(variant5);
vTVector1.Append(variant6);
headingPairs1.Append(vTVector1);
Ap.TitlesOfParts titlesOfParts1 = new Ap.TitlesOfParts();
Vt.VTVector vTVector2 = new Vt.VTVector()
{
BaseType = Vt.VectorBaseValues.Lpstr, Size = (UInt32Value)7U
};
Vt.VTLPSTR vTLPSTR4 = new Vt.VTLPSTR();
vTLPSTR4.Text = "Arial";
Vt.VTLPSTR vTLPSTR5 = new Vt.VTLPSTR();
vTLPSTR5.Text = "Bliss Pro Regular";
Vt.VTLPSTR vTLPSTR6 = new Vt.VTLPSTR();
vTLPSTR6.Text = "DaxPro-Medium";
Vt.VTLPSTR vTLPSTR7 = new Vt.VTLPSTR();
vTLPSTR7.Text = "Times";
Vt.VTLPSTR vTLPSTR8 = new Vt.VTLPSTR();
vTLPSTR8.Text = "Wingdings";
Vt.VTLPSTR vTLPSTR9 = new Vt.VTLPSTR();
vTLPSTR9.Text = "NAS001_FINRA_Presentation_071907";
Vt.VTLPSTR vTLPSTR10 = new Vt.VTLPSTR();
vTLPSTR10.Text = "PowerPoint Presentation";
vTVector2.Append(vTLPSTR4);
vTVector2.Append(vTLPSTR5);
vTVector2.Append(vTLPSTR6);
vTVector2.Append(vTLPSTR7);
vTVector2.Append(vTLPSTR8);
vTVector2.Append(vTLPSTR9);
vTVector2.Append(vTLPSTR10);
titlesOfParts1.Append(vTVector2);
Ap.Company company1 = new Ap.Company();
company1.Text = "";
Ap.LinksUpToDate linksUpToDate1 = new Ap.LinksUpToDate();
linksUpToDate1.Text = "false";
Ap.SharedDocument sharedDocument1 = new Ap.SharedDocument();
sharedDocument1.Text = "false";
Ap.HyperlinksChanged hyperlinksChanged1 = new Ap.HyperlinksChanged();
hyperlinksChanged1.Text = "false";
Ap.ApplicationVersion applicationVersion1 = new Ap.ApplicationVersion();
applicationVersion1.Text = "16.0000";
properties1.Append(template1);
properties1.Append(totalTime1);
properties1.Append(words1);
properties1.Append(application1);
properties1.Append(presentationFormat1);
properties1.Append(paragraphs1);
properties1.Append(slides1);
properties1.Append(notes1);
properties1.Append(hiddenSlides1);
properties1.Append(multimediaClips1);
properties1.Append(scaleCrop1);
properties1.Append(headingPairs1);
properties1.Append(titlesOfParts1);
properties1.Append(company1);
properties1.Append(linksUpToDate1);
properties1.Append(sharedDocument1);
properties1.Append(hyperlinksChanged1);
properties1.Append(applicationVersion1);
extendedFilePropertiesPart1.Properties = properties1;
}
private void GenerateExtendedFilePropertiesPartContent(ExtendedFilePropertiesPart extendedFilePropertiesPart)
{
if (extendedFilePropertiesPart.Properties == null)
{
extendedFilePropertiesPart.Properties = new DocumentFormat.OpenXml.ExtendedProperties.Properties();
}
var properties = extendedFilePropertiesPart.Properties;
if (
!properties.NamespaceDeclarations.Contains(new KeyValuePair <string, string>("vt",
"http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes")))
{
properties.AddNamespaceDeclaration("vt",
"http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes");
}
if (properties.Application == null)
{
properties.AppendChild(new Application {
Text = "Microsoft Excel"
});
}
if (properties.DocumentSecurity == null)
{
properties.AppendChild(new DocumentSecurity {
Text = "0"
});
}
if (properties.ScaleCrop == null)
{
properties.AppendChild(new ScaleCrop {
Text = "false"
});
}
if (properties.HeadingPairs == null)
{
properties.HeadingPairs = new HeadingPairs();
}
if (properties.TitlesOfParts == null)
{
properties.TitlesOfParts = new TitlesOfParts();
}
properties.HeadingPairs.VTVector = new VTVector {
BaseType = VectorBaseValues.Variant
};
properties.TitlesOfParts.VTVector = new VTVector {
BaseType = VectorBaseValues.Lpstr
};
var vTVectorOne = properties.HeadingPairs.VTVector;
var vTVectorTwo = properties.TitlesOfParts.VTVector;
var modifiedWorksheets =
Worksheets.Select(w => new { w.Name, Order = w.Position }).ToList();
var modifiedWorksheetsCount = modifiedWorksheets.Count;
InsertOnVtVector(vTVectorOne, "Worksheets", 0, modifiedWorksheetsCount.ToString());
vTVectorTwo.Size = (UInt32)(modifiedWorksheetsCount);
foreach (var vTlpstr3 in modifiedWorksheets.OrderBy(w => w.Order).Select(w => new VTLPSTR {
Text = w.Name
}))
{
vTVectorTwo.AppendChild(vTlpstr3);
}
}
private void CreateParts(PresentationDocument document, PresentationGenerationData data)
{
ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart <ExtendedFilePropertiesPart>("rId3");
GenerateExtendedFilePropertiesPartHelper.GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1);
PresentationPart presentationPart1 = document.AddPresentationPart();
GeneratePresentationPartHelper.GeneratePresentationPart1Content(presentationPart1);
CommentAuthorsPart commentAuthorsPart1 = presentationPart1.AddNewPart <CommentAuthorsPart>("rId8");
GenerateCommentAuthorsPartHelper.GenerateCommentAuthorsPart1Content(commentAuthorsPart1);
CustomXmlPart customXmlPart1 = presentationPart1.AddNewPart <CustomXmlPart>("application/xml", "rId3");
GenerateCustomXmlPartHelper.GenerateCustomXmlPart1Content(customXmlPart1);
CustomXmlPropertiesPart customXmlPropertiesPart1 = customXmlPart1.AddNewPart <CustomXmlPropertiesPart>("rId1");
GenerateCustomXmlPropertiesPartHelper.GenerateCustomXmlPropertiesPart1Content(customXmlPropertiesPart1);
HandoutMasterPart handoutMasterPart1 = presentationPart1.AddNewPart <HandoutMasterPart>("rId7");
GenerateHandoutMasterPartHelper.GenerateHandoutMasterPart1Content(handoutMasterPart1);
ThemePart themePart1 = handoutMasterPart1.AddNewPart <ThemePart>("rId1");
GenerateThemePartHelper.GenerateThemePart1Content(themePart1);
TableStylesPart tableStylesPart1 = presentationPart1.AddNewPart <TableStylesPart>("rId12");
GenerateTableStylesPartHelper.GenerateTableStylesPart1Content(tableStylesPart1);
CustomXmlPart customXmlPart2 = presentationPart1.AddNewPart <CustomXmlPart>("application/xml", "rId2");
GenerateCustomXmlPartHelper.GenerateCustomXmlPart2Content(customXmlPart2);
CustomXmlPropertiesPart customXmlPropertiesPart2 = customXmlPart2.AddNewPart <CustomXmlPropertiesPart>("rId1");
GenerateCustomXmlPropertiesPartHelper.GenerateCustomXmlPropertiesPart2Content(customXmlPropertiesPart2);
CustomXmlPart customXmlPart3 = presentationPart1.AddNewPart <CustomXmlPart>("application/xml", "rId1");
GenerateCustomXmlPartHelper.GenerateCustomXmlPart3Content(customXmlPart3);
CustomXmlPropertiesPart customXmlPropertiesPart3 = customXmlPart3.AddNewPart <CustomXmlPropertiesPart>("rId1");
GenerateCustomXmlPropertiesPartHelper.GenerateCustomXmlPropertiesPart3Content(customXmlPropertiesPart3);
NotesMasterPart notesMasterPart1 = presentationPart1.AddNewPart <NotesMasterPart>("rId6");
GenerateNotesMasterPartHelper.GenerateNotesMasterPart1Content(notesMasterPart1);
ThemePart themePart2 = notesMasterPart1.AddNewPart <ThemePart>("rId1");
GenerateThemePartHelper.GenerateThemePart2Content(themePart2);
ThemePart themePart3 = presentationPart1.AddNewPart <ThemePart>("rId11");
GenerateThemePartHelper.GenerateThemePart3Content(themePart3);
SlidePart slidePart1 = presentationPart1.AddNewPart <SlidePart>("rId5");
GenerateSlidePartHelper.GenerateSlidePart1Content(slidePart1, data);
var pictureType = string.Empty;
if (!string.IsNullOrEmpty(data.PictureType))
{
pictureType = data.PictureType;
}
else
{
pictureType = "image/png";
}
ImagePart imagePart1 = slidePart1.AddNewPart <ImagePart>(pictureType, "rId3");
GenerateImagePartHelper.GenerateImagePart1Content(imagePart1, data.PictureContent);
NotesSlidePart notesSlidePart1 = slidePart1.AddNewPart <NotesSlidePart>("rId2");
GenerateNotesSlidePartHelper.GenerateNotesSlidePart1Content(notesSlidePart1);
notesSlidePart1.AddPart(slidePart1, "rId2");
notesSlidePart1.AddPart(notesMasterPart1, "rId1");
SlideLayoutPart slideLayoutPart1 = slidePart1.AddNewPart <SlideLayoutPart>("rId1");
GenerateSlideLayoutPartHelper.GenerateSlideLayoutPart1Content(slideLayoutPart1);
SlideMasterPart slideMasterPart1 = slideLayoutPart1.AddNewPart <SlideMasterPart>("rId1");
GenerateSlideMasterPartHelper.GenerateSlideMasterPart1Content(slideMasterPart1);
SlideLayoutPart slideLayoutPart2 = slideMasterPart1.AddNewPart <SlideLayoutPart>("rId8");
GenerateSlideLayoutPartHelper.GenerateSlideLayoutPart2Content(slideLayoutPart2);
slideLayoutPart2.AddPart(slideMasterPart1, "rId1");
ImagePart imagePart2 = slideMasterPart1.AddNewPart <ImagePart>("image/jpeg", "rId13");
GenerateImagePartHelper.GenerateImagePart2Content(imagePart2);
SlideLayoutPart slideLayoutPart3 = slideMasterPart1.AddNewPart <SlideLayoutPart>("rId3");
GenerateSlideLayoutPartHelper.GenerateSlideLayoutPart3Content(slideLayoutPart3);
slideLayoutPart3.AddPart(slideMasterPart1, "rId1");
SlideLayoutPart slideLayoutPart4 = slideMasterPart1.AddNewPart <SlideLayoutPart>("rId7");
GenerateSlideLayoutPartHelper.GenerateSlideLayoutPart4Content(slideLayoutPart4);
slideLayoutPart4.AddPart(slideMasterPart1, "rId1");
slideMasterPart1.AddPart(themePart3, "rId12");
slideMasterPart1.AddPart(slideLayoutPart1, "rId2");
SlideLayoutPart slideLayoutPart5 = slideMasterPart1.AddNewPart <SlideLayoutPart>("rId1");
GenerateSlideLayoutPartHelper.GenerateSlideLayoutPart5Content(slideLayoutPart5);
ImagePart imagePart3 = slideLayoutPart5.AddNewPart <ImagePart>("image/jpeg", "rId3");
GenerateImagePartHelper.GenerateImagePart3Content(imagePart3);
ImagePart imagePart4 = slideLayoutPart5.AddNewPart <ImagePart>("image/png", "rId2");
GenerateImagePartHelper.GenerateImagePart4Content(imagePart4);
slideLayoutPart5.AddPart(slideMasterPart1, "rId1");
SlideLayoutPart slideLayoutPart6 = slideMasterPart1.AddNewPart <SlideLayoutPart>("rId6");
GenerateSlideLayoutPartHelper.GenerateSlideLayoutPart6Content(slideLayoutPart6);
slideLayoutPart6.AddPart(slideMasterPart1, "rId1");
SlideLayoutPart slideLayoutPart7 = slideMasterPart1.AddNewPart <SlideLayoutPart>("rId11");
GenerateSlideLayoutPartHelper.GenerateSlideLayoutPart7Content(slideLayoutPart7);
slideLayoutPart7.AddPart(slideMasterPart1, "rId1");
SlideLayoutPart slideLayoutPart8 = slideMasterPart1.AddNewPart <SlideLayoutPart>("rId5");
GenerateSlideLayoutPartHelper.GenerateSlideLayoutPart8Content(slideLayoutPart8);
slideLayoutPart8.AddPart(slideMasterPart1, "rId1");
SlideLayoutPart slideLayoutPart9 = slideMasterPart1.AddNewPart <SlideLayoutPart>("rId10");
GenerateSlideLayoutPartHelper.GenerateSlideLayoutPart9Content(slideLayoutPart9);
slideLayoutPart9.AddPart(slideMasterPart1, "rId1");
SlideLayoutPart slideLayoutPart10 = slideMasterPart1.AddNewPart <SlideLayoutPart>("rId4");
GenerateSlideLayoutPartHelper.GenerateSlideLayoutPart10Content(slideLayoutPart10);
slideLayoutPart10.AddPart(slideMasterPart1, "rId1");
SlideLayoutPart slideLayoutPart11 = slideMasterPart1.AddNewPart <SlideLayoutPart>("rId9");
GenerateSlideLayoutPartHelper.GenerateSlideLayoutPart11Content(slideLayoutPart11);
slideLayoutPart11.AddPart(slideMasterPart1, "rId1");
ViewPropertiesPart viewPropertiesPart1 = presentationPart1.AddNewPart <ViewPropertiesPart>("rId10");
GenerateViewPropertiesPartHelper.GenerateViewPropertiesPart1Content(viewPropertiesPart1);
presentationPart1.AddPart(slideMasterPart1, "rId4");
PresentationPropertiesPart presentationPropertiesPart1 = presentationPart1.AddNewPart <PresentationPropertiesPart>("rId9");
GeneratePresentationPropertiesPartHelper.GeneratePresentationPropertiesPart1Content(presentationPropertiesPart1);
CustomFilePropertiesPart customFilePropertiesPart1 = document.AddNewPart <CustomFilePropertiesPart>("rId4");
CustomFilePropertiesPartHelper.GenerateCustomFilePropertiesPart1Content(customFilePropertiesPart1);
SetPackageProperties(document);
}
