power shell通过epplus操作excel
[void][Reflection.assembly]::LoadFrom("C:\ww\EPPlus.dll")
[void][Reflection.assembly]::LoadFrom("C:\ww\Microsoft.IO.RecyclableMemoryStream.dll")
$ex = New-Object OfficeOpenXml.ExcelPackage("C:\ww\x.xlsx")
#$ex.SaveAs("C:\ww\x1.xlsx")
[System.Windows.Forms.MessageBox]::Show(($ex.Workbook.Worksheets[3].Cells[4,4]).ToString())
[System.Windows.Forms.MessageBox]::Show($ex.Workbook.Worksheets[3].Name)
浙公网安备 33010602011771号