I am wanting to create a script that would basically add the sum of what is in excel and save it as a variable so i can input it somewhere else.
Excel looks like this:
$excelObj = New-Object -ComObject Excel.Application
$excelObj.Visible = $false
$workBook = $excelObj.Workbooks.Open($filePath)
$workSheet = $workBook.sheets.Item(1)
#Select the range of rows should read
This is what i have learned so far, but im sure there are better ways than me copying
$worksheet.Range ("A1").Textfor the whole column until 300, and then trying to find out how to add them together.