X-Git-Url: https://us-delaporte.pagekite.me/gitweb/dotfiles.git/blobdiff_plain/34b6143db4367591d895c2ec40e99bd54aa07223..0b1b393bc7fec24e1d06e87aff97f247de84d5bf:/Toybox/Teams2Markdown.ps1 diff --git a/Toybox/Teams2Markdown.ps1 b/Toybox/Teams2Markdown.ps1 index 3d3ebc7..fc1a156 100644 --- a/Toybox/Teams2Markdown.ps1 +++ b/Toybox/Teams2Markdown.ps1 @@ -11,7 +11,7 @@ .EXAMPLE -> ./Teams2Markdown.ps1 -Path C:\tmp\TeamsExport.xlsx | Out-File -Path c:\TeamsMarkdown.md +> ./Teams2Markdown.ps1 -Path C:\tmp\TeamsExport.xlsx | Out-File c:\tmp\TeamsMarkdown.md .NOTES @@ -29,7 +29,8 @@ $xlData = Import-Excel -Path $Path -StartRow $StartRow # $xlData | Select-Object -First 2 | Format-List -$xlData | Sort-Object { $_."Bucket" } | ForEach-Object { +$xlData | Sort-Object { $_."Bucket Name" } | ForEach-Object { + if(!$_."Task Name" -eq "") { "" "## $($_."Task Name") - $($_."Bucket Name")" @@ -45,4 +46,7 @@ $xlData | Sort-Object { $_."Bucket" } | ForEach-Object { } } } -} \ No newline at end of file +} + +"Generated by [Teams2Markdown Script][1]." +"[1]: https://github.com/edthedev/dotfiles/blob/master/Toybox/Teams2Markdown.ps1" \ No newline at end of file