This Powershell script is working for my requirements now. Hope its of some value to somebody.
$excel = new-object -comobject excel.application
$excel.visible = $true
$wb = $excel.workbooks.add()
$ws = $wb.worksheets.item(1)
# Create Associated array of site names and associated share paths
$NasDrv = @{
'Site1' = '\\NAS1\Share';
'Site2' = '\\NAS2\Share';
'Site3' = '\\NAS3\Share';
'Site4' = '\\NAS4\Share';
'Site5' = '\\NAS5\Share';
'Site6' = '\\NAS6\Share';
'Site7' = '\\NAS7\Share'
}
# Build arrays from Associated Array above
$site = @($nasdrv.keys)
$path = @($nasdrv.get_values())
# Create array of titles to be used in Excel
$titles = ('Site','Path','Free Space (GB)','Total Space (GB)')
# Add titles to excel
for ($x=0; $x -le 3; $x++)
{
$ws.cells.item(1,$x+1) = $titles[$x]
}
# Add Data to Excel
for ($i=1; $i -le 7; $i++)
{
$ws.cells.item($i+1,1) = $site[$i-1]
,
$ws.cells.item($i+1,2) = $path[$i-1]
,
$ws.cells.item($i+1,3) = [math]::round((new-object -com scripting.filesystemobject).getdrive($path[$i-1]).availablespace / 1024 / 1024 / 1024, 2)
,
$ws.cells.item($i+1,4) = [math]::round((new-object -com scripting.filesystemobject).getdrive($path[$i-1]).totalsize / 1024 / 1024 / 1024, 2)
}