为什么我不能像这样在 do till 循环中有一个计数器?我不明白这个错误。与$table有任何关联吗?
我还尝试将变量重命名为 $row,没有任何变化。
$row = [int]1
do { #Create a row
$r = $Table.NewRow()
#Enter data in the row
$r.HostName = $Sheet4.Cells.Item($row,2).Text
$r.RecordType = $Sheet4.Cells.Item($row,3).Text
$r.TimeStamp = $Sheet4.Cells.Item($row,4).Text
$r.TimeToLive = $Sheet4.Cells.Item($row,5).Text
$r.RecordData = $Sheet4.Cells.Item($row,6).Text
$r.Preference = $Sheet4.Cells.Item($row,7).Text
#Add the row to the table
$Table.Rows.Add($r)
$row++
} until (!$Sheet4.Cless.Item($row,2))
错误代码:
You cannot call a method on a null-valued expression.
At C:ScriptSCRIPT.ps1:392 char:17
+ $row++
+ ~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull
表创建数据:
$TabName = "ExcelRecords"
#Create Table object
$Table = New-Object system.Data.DataTable “$ExcelRecords”
#Define Columns
$Col1 = New-Object system.Data.DataColumn ZoneName,([string])
$Col2 = New-Object system.Data.DataColumn HostName,([string])
$Col3 = New-Object system.Data.DataColumn RecordType,([string])
$Col4 = New-Object system.Data.DataColumn TimeStamp,([string])
$Col5 = New-Object system.Data.DataColumn TimeToLive,([string])
$Col6 = New-Object system.Data.DataColumn RecordData,([string])
$Col7 = New-Object system.Data.DataColumn Preference,([string])
#Add the Columns
$Table.columns.add($Col1)
$Table.columns.add($Col2)
$Table.columns.add($Col3)
$Table.columns.add($Col4)
$Table.columns.add($Col5)
$Table.columns.add($Col6)
$Table.columns.add($Col7)
我猜你的脚本中有错别字:
更改行
} until (!$Sheet4.Cless.Item($row,2))
自:
} until (!$Sheet4.Cells.Item($row,2))
这将解释空引用异常。因为我不记得工作表的属性是Cless