exportToDifferentXLSXSheets.ps1

$data = @('Zero','One','Two','Three')

#Install-Module ImportExcel -AllowClobber -Force
Get-Module ImportExcel -ListAvailable | Import-Module -Force -Verbose

$data | Export-Excel -workSheetName "Character" -Path "C:\Temp\xlsm\\dataExp.xlsx"
0..3 | Export-Excel -workSheetName "Numbers" -Path "C:\Temp\xlsm\\dataExp.xlsx"