在 Excel 2007 / PowerShell 中将数据写入单元格
为什么我无法使用 Worksheet 类或 Sheet 接口将值写入 Excel？我希望能够做这样的事情：
[Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Interop.Excel")
$Excel = New-Object Microsoft.Office.Interop.Excel.ApplicationClass
$Workbook = $Excel.Workbooks.Add()
$Worksheet = $Workbook.Worksheets.Add()
$Worksheet.Cells.Item(1,1).Value2 = "Test"
但是，似乎您必须使用 ApplicationClass 对象写入值：
[Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Interop.Excel")
$Excel = New-Object Microsoft.Office.Interop.Excel.ApplicationClass
$Workbook = $Excel.Workbooks.Add()
$Worksheet = $Workbook.Worksheets.Add()
$Excel.Cells.Item(1,1).Value2 = "Test"
这对我来说似乎不合逻辑，因为我正在将值写入特定的工作表我'我正在使用，而不是在应用程序级别。
对此有什么想法吗？
Why can I not write values to Excel using the Worksheet class, or Sheet interface? I would expect to be able to do something like this:
[Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Interop.Excel")
$Excel = New-Object Microsoft.Office.Interop.Excel.ApplicationClass
$Workbook = $Excel.Workbooks.Add()
$Worksheet = $Workbook.Worksheets.Add()
$Worksheet.Cells.Item(1,1).Value2 = "Test"
But instead, it seems that you have to write values using the ApplicationClass object:
[Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Interop.Excel")
$Excel = New-Object Microsoft.Office.Interop.Excel.ApplicationClass
$Workbook = $Excel.Workbooks.Add()
$Worksheet = $Workbook.Worksheets.Add()
$Excel.Cells.Item(1,1).Value2 = "Test"
This doesn't seem logical to me, because I'm writing the value to the specific worksheet I'm working with, not at the application level.
Any thoughts on this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我无法重现这个。你之前的例子非常适合我。我通过设置 $Excel.Visible = $true 进行验证，我可以在单元格（1,1）中看到“测试”。
-奥辛
I cannot reproduce this. Your former example works perfectly for me. I verified by setting $Excel.Visible = $true and I can see "Test" in cell(1,1).
-Oisin