title: Getting a check box from Excel sheet with Powershell?
body: <p>I have an Excel Sheet with check boxes (Developer -> Controls -> Insert -> Check Box) in cells. I need to check if the check box is ticked or not. If there is a better / easier way to accomplish the same result let me know.
  I tried this:</p>
  
  <pre><code>$Excel = New-Object -ComObject excel.application
  $Excel.Visible = $openExcel
  $Workbook = $Excel.Workbooks.Open($file)
  $Table = $Workbook.Worksheets.Item($sheet)
  $CheckBox = $Table.Cells.Item($row, $column)
  ($CheckBox | Format-List | Out-String) | Out-File -File output.txt
  </code></pre>
  
  <p>In the output is no sign of the checkbox in the cell. Do I have to access them differently?</p>
  
  <p>Output: <a href="https://pastebin.com/raw/KeAKDi2n" rel="nofollow noreferrer">https://pastebin.com/raw/KeAKDi2n</a></p>