Excel command action (Last Author)

Feature requests
1

This will work with Powershell, but it would be nice if it was built into the action.

$excel = New-Object -ComObject Excel.Application
$excel.Visible = $false
$workbook = $excel.Workbooks.Open("file.xlsx")
$binding = "System.Reflection.BindingFlags" -as [type]

Foreach($property in $workbook.BuiltInDocumentProperties){
    if ([System.__ComObject].invokemember("name",$binding::GetProperty,$null,$property,$null) -eq "Last author"){
        [System.__ComObject].invokemember("value",$binding::GetProperty,$null,$property,$null)
    }
}
$excel.quit()
2

Looking at the script, “Last author” is an Excel-specific attribute that is not available on other files.

3

You’re right. Do you think it could be an Excel command action?