topic Denis in Product Forum

To Write A Collection Onto a Word Dynamically

PrateekMehan — Thu, 30 Mar 2017 10:59:00 GMT

HI All, I want to write a collection with unknown number of fields into a table in the word document. I know how to do it if the number of fields in the collection are known but if the fields in the collection can vary at run time and I am stuck as how to proceed further. Any suggestions would be appreciated. Thanks.

Looking at the MS Word VBO

Denis__Dennehy — Thu, 30 Mar 2017 14:06:00 GMT

Looking at the MS Word VBO object I can see that it has an 'Add Table Row' action. Can you not simply loop through your collection and use this 'Add Table Row' action when required to add additionally required rows?

I agree with you Dennis but

PrateekMehan — Thu, 30 Mar 2017 15:21:00 GMT

I agree with you Dennis but adding a table row would require me to know the number of columns in a collection which I stated could change. That's where I am stuck at , if collection has 2 columns and sometimes 3 columns, how to tackle that??

If you are asking how do i

Denis__Dennehy — Thu, 30 Mar 2017 15:44:00 GMT

If you are asking how do i discover the number of rows are in a collection, there is a Count Rows action in the internal collections object, or if you are looping through a collection you simply need to increment a data item counter as you loop?

Denis

FirstName — Fri, 31 Mar 2017 17:28:00 GMT

Denis I think the question was more around the number of columns, if this isn't fixed and can change from 2 to 3 or more... I'm keen to find a solution to this also as it's something I'm currently being faced with... Thanks

I see... well if the action

Denis__Dennehy — Fri, 31 Mar 2017 18:06:00 GMT

I see... well if the action does not exist in the word interface, your option is probably to create a new action that does what you want. So, I see that the Add Row action has code that looks like: Dim doc as Object = GetDocument(handle,documentname) doc.Tables.Item(TableNumber).Rows.Add() I would suggest that a new Add Column action would be extreamly similar and probably look something like this: Dim doc as Object = GetDocument(handle,documentname) doc.Tables.Item(TableNumber).Columns.Add() NOTE: I don't know if that is the code you need, that is my non-research guess. I would suggest using google to find out for sure. This kind of thing: https://msdn.microsoft.com/en-us/library/office/ff837258.aspx However, I would guess that adding columns is more likely to impact the general formatting of a word document (such as going over the right of page boundary) - so even more actions/logic would probably be required to somehoe counter that.

Thanks Denis , I would give

PrateekMehan — Fri, 07 Apr 2017 14:02:00 GMT

Thanks Denis , I would give it a try