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)

  

posted @ 2022-05-10 14:49  Ender.Lu  阅读(90)  评论(0)    收藏  举报