Loading in multiple columns of excel

  • 66 Views
  • Last Post 2 weeks ago
ayush.kumar@globalfinfocus.com posted this 2 weeks ago

Hi Support Team,

I was trying to populate the Excel columns using the method SetCellValueIfRowHas. But it only populates one column at a time. I'd like to populate the subsequent columns each time the for each loop runs as shown in the image. Also I'd like to know if the same procedure can be executed row-wise instead of column-wise.

 

Attached Files

Order By: Standard | Newest | Votes
ayush.kumar@globalfinfocus.com posted this 2 weeks ago

I have attached the image with better resolution. 

Intellibot Support posted this 2 weeks ago

Hi,

 If you want to set multiple column values you can double click on the component and chose columns as per your requirement. Please find the screenshot for your reference.

Thanks & Regards,

Intellibot Support.

ayush.kumar@globalfinfocus.com posted this 2 weeks ago

Hi,

The number of subsequent columns is not predetermined and is received from the same data port which is connected with a for each loop meaning that in each iteration of the loop a different set of data is transferred. I'd like the data to be loaded in a dynamic fashion in subsequent columns (or rows if it is possible to get it in a tabular format) where the number of columns is not predetermined.

Intellibot Support posted this 2 weeks ago

Hi,

Our team will connect with you over the email and share the details on this.

Thanks & Regards,

Intellibot Support.

Close