Help writing a excel function to a cell using powershell
i have been working on function write worklog information excel template. able work once added date column , tried write excel function i'm getting below error. exception setting "item": "exception hresult: 0x800a03ec"at c:\users\shuppz\documents\windowspowershell\modules\client config cdrl\source\get-assignment.ps1:1482 char:4 + $main.cells.item($i, 9) = $datefunction + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + categoryinfo : notspecified: (:) [], setvalueinvocationexception + fullyqualifiederrorid : catchfrombaseadapterparameterizedpropertysetvalueti the excel string need add cell add date , string created in below function called $datefunction. function create-worklog { param ($newfile, $dbname, $work) $before = @(get-process [e]xcel | %{ $_.id }) $excelobject = new-object -comobject excel.application $excelid = get-process excel | %{ $_.id } | ? { $before -notcontains $_ } $excelobject.visible ...
