Examples/Excel/New-Spreadsheet.ps1
|
#Requires -Modules ImportExcel, PowerShellAI <# .SYNOPSIS Creates a new spreadsheet from a prompt .DESCRIPTION Creates a new spreadsheet from a prompt .PARAMETER prompt The prompt to use .PARAMETER Raw If set, returns the raw markdown table instead of converting it to an Excel spreadsheet .EXAMPLE .\New-Spreadsheet.ps1 "first 5 US presidents name, term, party" .EXAMPLE .\New-Spreadsheet.ps1 "first 5 US presidents name, term, party" -Raw #> param( [Parameter(Mandatory)] $prompt, [Switch]$Raw ) $result = ai "A spreadsheet of: $($prompt)" if ($Raw) { return $result } else { $result | ConvertFrom-GPTMarkdownTable | Export-Excel } |