MS word tables in vb.net

[Signo.X]

Hello all,

im using the follwoing to read data from a table in MS word using vb.net,
I only want to read the value at cell 2 of each row in the table.

Dim myTable As Table
Dim myRow As Row
Dim myCell As Cell
Dim cellText As String


For Each myRow In myTable.Rows
For Each myCell In myRow.Cells

cellText = myRow.Cells(2).Range.Text
cellText = Trim$(Left$(cellText, Len(cellText) - 2))

Console.WriteLine(cellText)
Next
Next

when i print the values , its printing the value of each cell twice ?@@!#

any idea why is it printing each value twice???

Thanks in advance

~ Signo.x

 

[djjeavons]

Hi

I'm not totally familiar with the syntax for reading tables in Word but looking at your code, it suggests to me that if your table has two cells then your for statement will iterate twice and therefore print the value of cellText twice. Could you not change this to one for loop to iterate through the rows and read the value of cell 2 within that row?


HTH

 

[Signo.X]

thanks for the reply ..

'Could you not change this to one for loop to iterate through the rows and read the value of cell 2 within that row?'

how do u mean? i didnt get that ?

 

[djjeavons]

Hi

Basically, remove your inner For Loop as it is not required (or at least that is my understanding).


HTH

 

[Pleh]

like this...

Dim myTable As Table
Dim myRow As Row
Dim myCell As Cell
Dim cellText AsString


ForEach myRow In myTable.Rows

cellText = myRow.Cells(2).Range.Text
cellText = Trim$(Left$(cellText, Len(cellText) - 2))

Console.WriteLine(cellText)
Next

 

[Signo.X]

Thanks alot,

That was exactely right!

~signo.X