PowerShell で Excel 2007 のシートを操作する

  • Article

PowerShell ??????????????????????? Excel ???????????????????????????????? Excel ?????????????????????????????????????????

2007 Office system ???????????? Office Open XML ??????????????????????????????? API ??????????System.IO.Packaging ????????.NET Framework 3.0 ???????????????Excel 2007 ?? (xlsx) ?????System.IO.Packaging ?????? Excel ???????????????????????????????????????????Office OpenXML ????????????

?????CodePlex ?????????????????????????????????????Excel 2007 ?????????????????????????? System.IO.Packaging ???? ????

ExcelPackage: Office Open XML Format file creation
https://www.codeplex.com/ExcelPackage

???? (?????)?????????????????????????????ExcelPackageBinary.zip ?????? ExcelPackage.dll ?????????????? Excel ????????TestSheet.xlsx ??? ExcelPackage.dll ?????????????????

? ?
?? ??
?? ??
?? ??

System.IO.Packaging ??????? .NET Framework 3.0 ???????????????????? PowerShell ???????

[Reflection.Assembly]::LoadFrom("$pwd\excelpackage.dll")
$ep = New-Object OfficeOpenXml.ExcelPackage (dir TestSheet.xlsx)
foreach ($i in 1..4) {
foreach ($j in 1..2) {
$ep.workbook.worksheets[1].Cell($i,$j).value
}
}

????????????????????????

?
?
??
??
??
??
??
??

??????(???????????????????????????????????)

???????????? Excel 2007 ???????????????????????????????????????????