This post shows you how to create an excel spreadsheet in Powershell with OfficeWriter.
PowerShell
##################################################################
##
## Create an Excel Spreadsheet with ExcelApplication in Powershell ##
## by Jim Stallings (http://www.officewriter.com)
##
##################################################################
# Add the assembly Add-Type -Path ‘C:\Program Files (x86)\SoftArtisans\OfficeWriter\bin\dotnet\SoftArtisans.OfficeWriter.ExcelWriter.dll‘
# Create a new ExcelApplication object
$xla = New-Object “SoftArtisans.OfficeWriter.ExcelWriter.ExcelApplication”
# Create a new workbook
$wb = $xla.Create()
# Add a worksheet to the workbook
$ws = $wb.Worksheets[0]
# Add some text to the first cell in the sheet
$ws.Cells[‘A1’].Value = “Welcome to SoftArtisans OfficeWriter!”
# Save the workbook to disk
$xla.Save($wb, “C:\myfile.xls“)