Not able to get Cells.Items method of the work sheet object in power shell

Question

I need to read cells values from worksheet and i am referening folowing piece of code, however i don't get .Items() method

Code Refered: $objWorksheet.Cells.Item(2,1).Text

Also is there any other way we can read the cell values? Any suggestions/help would be highly appreciated

Regards, Ketan

ali Sharepoint · Answer 1 · 2012-08-17 11:06:14Z

up vote 0 down vote

I belive it would be:

$VaribleObject = $objWorksheet.Cells.Item(2, 1).Value()

I hope this helps ;)

answered Aug 17 '12 at 11:06

ali Sharepoint
4,1721521

	Done using same way..still giving error $excelObj = New-Object -ComObject "Excel.Application" $wrkBook = $excelObj.Workbooks.Open("FILE_PATH") $wrkShtGroup = $wrkBook.Worksheets.Item(4) $wrkShtGroup.Cells.Items(2,2).Value() – Ketan03 Aug 17 '12 at 11:43
	Hi that really strange! I dont really use poweshell meself but I fond this that should help! goto page 378. It goes into detail far more than I could as I dont know what code you might have thats effecting the result! hope it helps – ali Sharepoint Aug 17 '12 at 12:59

1 Answer