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
}