OpenXML.types.ps1xml
|
<!-- Generated with EZOut 2.0.6: Install-Module EZOut or https://github.com/StartAutomating/EZOut --> <Types> <Type> <Name>OpenXML</Name> <Members> <AliasProperty> <Name>CreatedAt</Name> <ReferencedMemberName>Created</ReferencedMemberName> </AliasProperty> <AliasProperty> <Name>CreationTime</Name> <ReferencedMemberName>Created</ReferencedMemberName> </AliasProperty> <AliasProperty> <Name>DocProps</Name> <ReferencedMemberName>DocumentProperty</ReferencedMemberName> </AliasProperty> <AliasProperty> <Name>DocumentProperties</Name> <ReferencedMemberName>DocumentProperty</ReferencedMemberName> </AliasProperty> <AliasProperty> <Name>LastWriteTime</Name> <ReferencedMemberName>Modified</ReferencedMemberName> </AliasProperty> <AliasProperty> <Name>ModifiedAt</Name> <ReferencedMemberName>Modified</ReferencedMemberName> </AliasProperty> <AliasProperty> <Name>Part</Name> <ReferencedMemberName>Parts</ReferencedMemberName> </AliasProperty> <ScriptProperty> <Name>Created</Name> <GetScriptBlock> <# .SYNOPSIS Gets OpenXML creation time .DESCRIPTION Gets the time an OpenXML file was created, according to core document metadata. .EXAMPLE Get-OpenXML ./Examples/Blank.docx | Select-Object -ExpandProperty Created #> param() $this.Parts.'/docProps/core.xml'.content.coreProperties.created.innerText -as [DateTime] </GetScriptBlock> </ScriptProperty> <ScriptProperty> <Name>DocumentProperty</Name> <GetScriptBlock> if (-not $this.Parts) { return } $docProps = $this.Parts[$this.Parts.Keys -match '/docProps/'] $docProps </GetScriptBlock> </ScriptProperty> <ScriptProperty> <Name>Modified</Name> <GetScriptBlock> <# .SYNOPSIS Gets OpenXML modified time .DESCRIPTION Gets the time an OpenXML file was modified, according to core document metadata. .EXAMPLE Get-OpenXML ./Examples/Blank.docx | Select-Object -ExpandProperty Modified #> $this.Parts.'/docProps/core.xml'.content.coreProperties.modified.innerText -as [DateTime] </GetScriptBlock> </ScriptProperty> <ScriptProperty> <Name>Parts</Name> <GetScriptBlock> if ($this.'.Parts') { return $this.'.Parts' } filter getPartContent { $part = $_ $partStream = $part.GetStream() if (-not $partStream) { return } switch ($part.ContentType) { # If the content type looks like XML, read it as XML { $part.ContentType -match '[\./\+]xml' } { $streamReader = [IO.StreamReader]::new($partStream) $streamReader.ReadToEnd() -as [xml] $streamReader.Close() break } # If the part looks like JSON, read it as JSON { $part.Uri -match '\.json$'} { $streamReader = [IO.StreamReader]::new($partStream) $jsonContent = $streamReader.ReadToEnd() $streamReader.Close() $jsonContent | ConvertFrom-Json break } { $part.ContentType -match 'text/.+?$'} { $streamReader = [IO.StreamReader]::new($partStream) $textContent = $streamReader.ReadToEnd() $streamReader.Close() $textContent break } # Otherwise, read it as a memory stream and return the byte array default { $outputStream = [IO.MemoryStream]::new() $partStream.CopyTo($outputStream) $outputStream.Seek(0, 'Begin') $outputStream.ToArray() } } $partStream.Close() $partStream.Dispose() } $packageParts = @($this.GetParts()) $packageContent = [Ordered]@{} # Now we will read each part in the package, and store it in an `[Ordered]` dictionary # Since this _might_ take a while (if you used a lot of PowerPoint images) we want to show a progress bar. # Prepare the progress bar $partCount = 0 $partTotal = $packageParts.Length $partProgress = [Ordered]@{Id=Get-Random;Activity='Reading Parts'} # Then read each part @(foreach ($part in $packageParts) { $partCount++ # update the progress bar Write-Progress @partProgress -Status "Reading part $($part.Uri) ($partCount of $partTotal)" -PercentComplete ( [math]::Round(($partCount * 100/ $partTotal)) ) # and store the part in the dictionary $packageContent["$($part.Uri)"] = [PSCustomObject]@{ PSTypeName = 'OpenXML.Part' Uri = $part.Uri ContentType = $part.ContentType # (we'll use our helper function to get the content) Content = $part | getPartContent FilePath = "$resolvedPath" } }) <## Now that we've read all parts, we can close the package $filePackage.Close() # and the memory stream, too. $memoryStream.Close()#> # and finally, complete the progress bar. Write-Progress @partProgress -Status "Completed reading $partCount parts" -Completed $this | Add-Member NoteProperty '.Parts' -Force $packageContent return $this.'.Parts' </GetScriptBlock> </ScriptProperty> </Members> </Type> <Type> <Name>OpenXML.Excel.File</Name> <Members> <AliasProperty> <Name>SharedString</Name> <ReferencedMemberName>SharedStrings</ReferencedMemberName> </AliasProperty> <AliasProperty> <Name>Worksheet</Name> <ReferencedMemberName>Worksheets</ReferencedMemberName> </AliasProperty> <ScriptProperty> <Name>SharedStrings</Name> <GetScriptBlock> <# .SYNOPSIS Gets an Excel File's Shared Strings .DESCRIPTION Gets an Excel File's Shared Strings. In Excel, any cell with text in it really contains an index of it's shared string. .EXAMPLE Get-OpenXML ./Examples/HelloWorld.xlsx | Select -Expand SharedString #> ,@($this.Parts.'/xl/sharedStrings.xml'.Content.sst.si.t) </GetScriptBlock> </ScriptProperty> <ScriptProperty> <Name>Worksheets</Name> <GetScriptBlock> $worksheetNames = @($this.Parts['/docProps/app.xml'].Content.Properties.TitlesOfParts.vector.lpstr) $worksheetsInOrder = @($this.Parts[$this.Parts.keys -match '/sheet\d+'] | Sort-Object { $_.Uri -replace '\D' -as [int]} | Select-Object) $worksheetCounter = 0 foreach ($worksheet in $worksheetsInOrder) { $worksheetName = $worksheetNames[$worksheetCounter] if (-not $worksheetName) { $worksheetName = "Sheet$($worksheetCounter + 1)" } [PSCustomObject][Ordered]@{ PSTypeName = 'OpenXML.Excel.Worksheet' FilePath = $this.FilePath Uri = $worksheet.Uri WorksheetName = $worksheetName Content = $worksheet.Content ContentType = $worksheet.ContentType OpenXML = $this } $worksheetCounter++ } </GetScriptBlock> </ScriptProperty> </Members> </Type> <Type> <Name>OpenXML.Excel.Worksheet</Name> <Members> <AliasProperty> <Name>Cells</Name> <ReferencedMemberName>Cell</ReferencedMemberName> </AliasProperty> <AliasProperty> <Name>Formulae</Name> <ReferencedMemberName>Formula</ReferencedMemberName> </AliasProperty> <AliasProperty> <Name>Formulas</Name> <ReferencedMemberName>Formula</ReferencedMemberName> </AliasProperty> <ScriptProperty> <Name>Cell</Name> <GetScriptBlock> <# .SYNOPSIS Gets cells from Excel .DESCRIPTION Gets individual cells in an Excel worksheet. .EXAMPLE Get-OpenXML ./Examples/Sum.xlsx | Select-Object -ExpandProperty Worksheets | Select-Object -ExpandProperty Cell #> param() $excelCells = [Ordered]@{} # Get each row from our sheet data foreach ($worksheetRow in $this.content.worksheet.sheetdata.row) { # and get each column from each row foreach ($worksheetColumn in $worksheetRow.c) { # The `r` attribute contains the cell coordinate $excelCells[$worksheetColumn.r] = # Excel cells are always numbers. # If the cell contains a string, it is actually stored as an index in "sharedStrings" if ($worksheetColumn.t -eq 's') { # which makes indexing awfully easy (and has the side-effect of reducing the total file size for worksheets with similar text) $this.OpenXML.SharedStrings[$worksheetColumn.v] } else { # Otherwise, the value should be `v`. $worksheetColumn.v } } } # Return our cells as dictionary return $excelCells </GetScriptBlock> </ScriptProperty> <ScriptProperty> <Name>Formula</Name> <GetScriptBlock> $formulaCells = [Ordered]@{} foreach ($worksheetRow in $this.content.worksheet.sheetdata.row) { foreach ($worksheetColumn in $worksheetRow.c) { if ($worksheetColumn.f) { $formulaCells[$worksheetColumn.r] = $worksheetColumn.f } } } $formulaCells </GetScriptBlock> </ScriptProperty> </Members> </Type> <Type> <Name>OpenXML.File</Name> <Members> <MemberSet> <Name>PSStandardMembers</Name> <Members> <PropertySet> <Name>DefaultDisplayPropertySet</Name> <ReferencedProperties> <Name>FilePath</Name> <Name>Parts</Name> </ReferencedProperties> </PropertySet> </Members> </MemberSet> <NoteProperty> <Name>DefaultDisplay</Name> <Value>FilePath Parts</Value> </NoteProperty> </Members> </Type> <Type> <Name>OpenXML.PowerPoint.File</Name> <Members> <AliasProperty> <Name>Slide</Name> <ReferencedMemberName>Slides</ReferencedMemberName> </AliasProperty> <ScriptProperty> <Name>Slides</Name> <GetScriptBlock> $slidesInOrder = @($this.Parts[$this.Parts.keys -match '/slide\d+\.xml$'] | Sort-Object { $_.Uri -replace '\D' -as [int]} | Select-Object) foreach ($slide in $slidesInOrder) { [PSCustomObject][Ordered]@{ PSTypeName = 'OpenXML.PowerPoint.Slide' FilePath = $this.FilePath Uri = $slide.Uri SlideNumber = $slide.Uri -replace '\D' -as [int] Content = $slide.Content ContentType = $slide.ContentType } } </GetScriptBlock> </ScriptProperty> <ScriptProperty> <Name>Text</Name> <GetScriptBlock> $this.Slides.Content | Select-Xml -XPath '//a:t' -Namespace @{a='http://schemas.openxmlformats.org/drawingml/2006/main'} | Foreach-Object { if ($_.Node.LocalName -eq 't') { $_.Node.InnerText } else { [Environment]::NewLine } } </GetScriptBlock> </ScriptProperty> </Members> </Type> <Type> <Name>OpenXML.PowerPoint.Slide</Name> <Members> <ScriptProperty> <Name>Text</Name> <GetScriptBlock> @($this.Content | Select-Xml -XPath '//a:t' -Namespace @{a='http://schemas.openxmlformats.org/drawingml/2006/main'} | Foreach-Object { if ($_.Node.LocalName -eq 't') { $_.Node.InnerText } else { [Environment]::NewLine } }) -join '' </GetScriptBlock> </ScriptProperty> </Members> </Type> <Type> <Name>OpenXML.Word.File</Name> <Members> <ScriptProperty> <Name>Text</Name> <GetScriptBlock> @($this.Parts['/word/document.xml'].Content | Select-Xml -XPath '//w:t|//w:p' -Namespace @{w='http://schemas.openxmlformats.org/wordprocessingml/2006/main'} | Foreach-Object { if ($_.Node.LocalName -eq 't') { $_.Node.InnerText } else { [Environment]::NewLine } }) -join '' </GetScriptBlock> </ScriptProperty> </Members> </Type> </Types> |