Get-ExcelWorkbookInfo

NAME Get-ExcelWorkbookInfo



SYNOPSIS

Retrieve information of an Excel workbook.





SYNTAX

Get-ExcelWorkbookInfo [-Path] <String> [<CommonParameters>]





DESCRIPTION

The Get-ExcelWorkbookInfo cmdlet retrieves information (LastModifiedBy, LastPrinted, Created, Modified, ...) fron

an Excel workbook. These are the same details that are visible in Windows Explorer when right clicking the Excel

file, selecting Properties and check the Details tabpage.





PARAMETERS

-Path <String>

Specifies the path to the Excel file. This parameter is required.



Required? true

Position? 1

Default value None

Accept pipeline input? True (ByPropertyName, ByValue)

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



NOTES





CHANGELOG 2016/01/07 Added Created by Johan Akerstrom (https://github.com/CosmosKey)



-------------------------- EXAMPLE 1 --------------------------



Get-ExcelWorkbookInfo .\\Test.xlsx



CorePropertiesXml : #document Title : Subject : Author : Konica

Minolta User Comments : Keywords : LastModifiedBy : Bond, James (London) GBR

LastPrinted : 2017-01-21T12:36:11Z Created : 17/01/2017 13:51:32 Category :

Status : ExtendedPropertiesXml : #document Application : Microsoft Excel HyperlinkBase

: AppVersion : 14.0300 Company : Secret Service Manager : Modified

: 10/02/2017 12:45:37 CustomPropertiesXml : #document



RELATED LINKS

https://github.com/dfinke/ImportExcel https://github.com/dfinke/ImportExcel





CommonParameters : True

WorkflowCommonParameters : False

details : @{name=Get-HtmlTable; noun=; verb=}

Syntax : @{syntaxItem=System.Object[]}

parameters : @{parameter=System.Object[]}

inputTypes : @{inputType=}

returnValues : @{returnValue=}

aliases : None



remarks : None

alertSet :

description :

examples :

Synopsis :

Get-HtmlTable [-url] <Object> [[-tableIndex] <Object>] [[-Header] <Object>]

[[-FirstDataRow] <int>] [-UseDefaultCredentials] [<CommonParameters>]



ModuleName : ImportExcel

nonTerminatingErrors :

xmlns:command : http://schemas.microsoft.com/maml/dev/command/2004/10

xmlns:dev : http://schemas.microsoft.com/maml/dev/2004/10

xmlns:maml : http://schemas.microsoft.com/maml/2004/10

Name : Get-HtmlTable

Category : Function

Component :

Role :

Functionality :





CommonParameters : True

WorkflowCommonParameters : False

details : @{name=Get-Range; noun=; verb=}

Syntax : @{syntaxItem=System.Object[]}

parameters : @{parameter=System.Object[]}

inputTypes : @{inputType=}

returnValues : @{returnValue=}

aliases : None



remarks : None

alertSet :

description :

examples :

Synopsis :

Get-Range [[-start] <Object>] [[-stop] <Object>] [[-step] <Object>] [<CommonParameters>]



ModuleName : ImportExcel

nonTerminatingErrors :

xmlns:command : http://schemas.microsoft.com/maml/dev/command/2004/10

xmlns:dev : http://schemas.microsoft.com/maml/dev/2004/10

xmlns:maml : http://schemas.microsoft.com/maml/2004/10

Name : Get-Range

Category : Function

Component :

Role :

Functionality :





CommonParameters : True

WorkflowCommonParameters : False

details : @{name=Get-XYRange; noun=; verb=}

Syntax : @{syntaxItem=System.Object[]}

parameters : @{parameter=System.Object[]}

inputTypes : @{inputType=}

returnValues : @{returnValue=}

aliases : None



remarks : None

alertSet :

description :

examples :

Synopsis :

Get-XYRange [[-targetData] <Object>] [<CommonParameters>]



ModuleName : ImportExcel

nonTerminatingErrors :

xmlns:command : http://schemas.microsoft.com/maml/dev/command/2004/10

xmlns:dev : http://schemas.microsoft.com/maml/dev/2004/10

xmlns:maml : http://schemas.microsoft.com/maml/2004/10

Name : Get-XYRange

Category : Function

Component :

Role :

Functionality :