Powershell - kontrol af script - Word tabeller til Excel

Hej,

Jeg er ved at lave et script der trækker data ud fra alle tabeller i en .docx-fil, der anvender en bestemt typografi i celle (1,1) og sender det til et Excel-ark. Men jeg kan ikke få det til at virke.

Er der nogen, der kan hjælpe mig med at få styr på dette? Jeg har kendt til Powershell i et par dage, så jeg skal nok have et eventuelt svar ind med ske.

På forhånd tak!

Selve scriptet:

[code]
function Invoke([object]$m, [string]$method, $parameters)
{
$m.PSBase.GetType().InvokeMember(
$method, [Reflection.BindingFlags]::InvokeMethod, $null, $m, $parameters,$ciUS)
}

$word = new-object -ComObject "word.application"
#$word.Visible = $true

del "C:\PowerShell Kravextractor\excelfil.xls"

$doc = $word.documents.open("C:\PowerShell Kravextractor\ks_test.docx")
$sel = $word.Selection

$tables = $doc.Tables

# debug $paras.Item(7).Style.NameLocal

$excel = New-Object -comobject Excel.Application
#$excel.Visible = $True

$ciUS = [System.Globalization.CultureInfo]'en-US'


$workbook = Invoke $excel.Workbooks Add
$worksheet = $workbook.Worksheets.Item(1)
#$worksheet.Cells.Item(1,1).FormulaLocal = "A value in cell A1."
 
$worksheet.Cells.Item(1,1).FormulaLocal  = "Krav # (ID)"
$worksheet.Cells.Item(1,2).FormulaLocal  = "Titel"
$worksheet.Cells.Item(1,3).FormulaLocal  = "Kategori"
$worksheet.Cells.Item(1,4).FormulaLocal  = "Type"
$worksheet.Cells.Item(1,5).FormulaLocal  = "Beskrivelse"

# debug
#  $doc.Paragraphs.Item(9).Style.NameLocal

$cnt = 1


foreach ($table in $tables)

{
    $style = $table.Cells.Item(1,1).Style

    If ($style.NameLocal.Contains("Krav1 Overskrift")) 
    {


        #echo $cnt
        $id = $table.Cells.Item(1,1).Text
        $titel = $table.Cells.Item(1,2).Text
        $kat = $table.Cells.Item(2,2).Text
        $type = $table.Cells.Item(2,4).Text
        $besk = $table.Cells.Item(3,2).Text


        $cnt += 1

        $worksheet.Cells.Item($cnt,1).FormulaLocal = $id
        $worksheet.Cells.Item($cnt,2).FormulaLocal = $titel
        $worksheet.Cells.Item($cnt,3).FormulaLocal = $kat
        $worksheet.Cells.Item($cnt,4).FormulaLocal = $type
        $worksheet.Cells.Item($cnt,5).FormulaLocal = $besk

        echo $id
    }
}
#echo $cnt
#$excel.DisplayAlerts = $False
Invoke $workbook SaveAs "C:\PowerShell Kravextractor\excelfil.xls" > $null
Invoke $workbook Close 0 > $null

$word.Quit()
$excel.Quit()
[/code]


Og fejlmeddelelser fra Powershell ISE:
[code]
PS P:\> C:\PowerShell Kravextractor\Kravextractor.ps1
Exception calling "Open" with "1" argument(s): "Filen blev ikke fundet. ("C:\...\ks_test.docx")"
At C:\PowerShell Kravextractor\Kravextractor.ps1:12 char:28
+ $doc = $word.documents.open <<<< ("C:\PowerShell Kravextractor\ks_test.docx")
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : ComMethodTargetInvocation

You cannot call a method on a null-valued expression.
At C:\PowerShell Kravextractor\Kravextractor.ps1:44 char:31
+    $style = $table.Cells.Item <<<< (1,1).Style
    + CategoryInfo          : InvalidOperation: (Item:String) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At C:\PowerShell Kravextractor\Kravextractor.ps1:46 char:34
+    If ($style.NameLocal.Contains <<<< ("Krav1 Overskrift")) 
    + CategoryInfo          : InvalidOperation: (Contains:String) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

Exception calling "InvokeMember" with "6" argument(s): "Typeuoverensstemmelse. (Undtagelse fra HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))"
At C:\PowerShell Kravextractor\Kravextractor.ps1:3 char:33
+ $m.PSBase.GetType().InvokeMember <<<< (
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodTargetInvocation
[/code]