First I'd write here my code and what I have done so far to work this out.
$page = invoke-WebRequest -Uri "someURL"
$location = $page.ParsedHtml.body.getElementsByTagName('Tag0') | Where {$_.getAttributeNode('class').Value -eq 'value0'}
$rooms = $page.ParsedHtml.body.getElementsByTagName('Tag1') | Where {$_.getAttributeNode('class').Value -eq 'value1'}
$size = $page.ParsedHtml.body.getElementsByTagName('Tag2') | Where {$_.getAttributeNode('class').Value -eq 'value2'}
$price = $page.ParsedHtml.body.getElementsByTagName('Tag3') | Where {$_.getAttributeNode('class').Value -eq 'value3'}
$locationText=$location.innerText -replace "`n"," " -replace "`r"," "
$roomsText=$rooms.innerText -replace "`n"," " -replace "`r"," "
$sizeText=$size.innerText -replace "`n"," " -replace "`r"," "
$priceText=$price.innerText -replace "`n"," " -replace "`r"," "
$exportLoc= $locationText | select-object @{Name='locataion';Expression={$_}}
$exportRooms = $toomsText | select-object @{Name='rooms';Expression={$_}}
$exportSize = $sizeText | select-object @{Name='size';Expression={$_}}
$exportPrice = $priceText | select-object @{Name='price';Expression={$_}}
Now I tried to export $exportLoc with
$exportLoc | Export-Csv data.csv -Encoding Unicode
And it worked. But I cannot append (the following line generates an error)
$exportRooms | Export-Csv data.csv -Encoding Unicode
So I tried to wrap them in an object and export that object at once like this
$wrapper = @{
'locations' = $exportLoc
'rooms' = $exportRooms
'size' = $exportSize
'prices' = $exportPrice
}
$wrapper | Export-Csv data.csv -Encoding Unicode
The above code didn't work as well. The content of the column in CSV file appears to be
System.Object[]
instead of the actual content of the value.
How can I have 4 different columns in Excel sheet each contains one of the above objects?
