Blue Prism How to write a collection in MS Word VBO

Question

I've got one problem. I need to write my collection which contains 50 rows into my MS Word file. How can I do it? I've checked that there is an action named Type Text, but it is only for text type, not for a collection. Could you please give me some advice ? Best regards

Answer 1

You should try doing this : 

Use a loop for your specified collection

Inside your loop use Object MS Word VBO and Action Type Text.

In text field use the columns of your collection that you want to write to the word file (Example [Collection.Column1]&"-----"&[Collection.Column2])

Use Object MS Word VBO and Action Save As to save your file

Finally use Object MS Word VBO and Action Exit

Use Object MS Word VBO and Action Show for your files when you want to write some values (in your case Word)

Check the solution below:

Answer 2

Dim doc as Object = GetDocument(handle,documentname)
Dim range As Object
'range = doc.Content.InsertAfter(text)
Try
Dim strbuilder As New StringBuilder
'Start with new line in word document.
strbuilder.AppendLine()
For J As Integer = 0 TO SourceCollection.Columns.Count-1
strbuilder.Append(SourceCollection.Columns(J).ColumnName & Chr(9))
Next
strbuilder.AppendLine()
For I As Integer = 0 To SourceCollection.Rows.Count-1
    Dim Values(SourceCollection.Columns.Count-1) As Object
    For J As Integer = 0 To SourceCollection.Columns.Count-1
        Values(J)=SourceCollection.Rows(I)(J)
        strbuilder.Append(Values(J)& Chr(9))
    Next
        strbuilder.AppendLine()
Next
range = doc.Content.InsertAfter(strbuilder.ToString)
Catch Ex As Exception
ExceptionMessage=Ex.ToString
End TryDim doc as Object = GetDocument(handle,documentname)

Dim range As Object
'range = doc.Content.InsertAfter(text)
Try
Dim strbuilder As New StringBuilder
'Start with new line in word document.
strbuilder.AppendLine()
For J As Integer = 0 TO SourceCollection.Columns.Count-1
strbuilder.Append(SourceCollection.Columns(J).ColumnName & Chr(9))
Next
strbuilder.AppendLine()
For I As Integer = 0 To SourceCollection.Rows.Count-1
    Dim Values(SourceCollection.Columns.Count-1) As Object
    For J As Integer = 0 To SourceCollection.Columns.Count-1
        Values(J)=SourceCollection.Rows(I)(J)
        strbuilder.Append(Values(J)& Chr(9))
    Next
        strbuilder.AppendLine()
Next
range = doc.Content.InsertAfter(strbuilder.ToString)
Catch Ex As Exception
ExceptionMessage=Ex.ToString
End Try

For more information or tech support visit Data Recovery Dubai