#------------------------------------------------------------------------------------------------------------------------
# Write to Excel Sheet
#------------------------------------------------------------------------------------------------------------------------


$strFileName   = "C:\Temp\Files.xlsx"
$strSheetName  = 'Info$'
$strProvider   = "Provider=Microsoft.ACE.OLEDB.12.0"
$strDataSource = "Data Source = $strFileName"
$strExtend     = "Extended Properties=Excel 12.0;"
$strQuery      = "UPDATE [$strSheetName] set [C1]='CHECK1' where [B1]='CHECK2' "

$objConn = New-Object System.Data.OleDb.OleDbConnection ("$strProvider;$strDataSource;$strExtend")
$objConn.Open()

$sqlCommand = New-Object System.Data.OleDb.OleDbCommand
$sqlCommand.Connection = $objConn
$sqlCommand.CommandText = $strQuery 

$sqlCommand.ExecuteNonQuery() 

$sqlCommand.Connection.Close()