First simple test on Linux

[nicolasr75]

Used this simple test script to prove that I can easily fill my Excel report templates on Linux:

Import-Module ImportExcel

$filename = [System.IO.Path]::Combine($PSScriptRoot, "EnergyReport.xlsx")

$excel = Open-ExcelPackage -Path $filename

$ws = $excel.Workbook.Worksheets["Sheet 1"]

$ws.Cells["B1"].Value = "Hello Excel from ImportExcel"

$excel.Save()

Used PowerShell 7.3.0 on Debian 10.

[dfinke]

Good stuff. You can also use Close-ExcelPackage $excel which saves the changes, plus it has other parameters that are useful.