Copy/paste range for each row in excel for only a few columns

Help StudioX
,
1

Hi there -

I’m currently creating a bot in StudioX to enter data into SAP from excel by row. I’m looking to have the bot enter three columns into an SAP screen. I’m trying to use a for each excel row command, with a nested copy/paste range, but i can’t seem to find any way to get it to recognize that I only want columns B-D in the current row (the only option to use the current row seems to just copy the entire current row).

I’ve been researching and seeing some people try to use data table commands, but trying to define the data table and define these three columns also wouldn’t let me copy the data to the clipboard. Any advice is appreciated. Thank you!

2

@mwells accessing the column using index for each row would do the work.Can your share the screenshot of the workflow?

3

image
image520×574 18.3 KB

This is what i’m trying to do - nested within a for each row command.

4

Hi @mwells
You could pass the type into text like below.No need for copy paste range.

image
image600×623 18.3 KB

5

Thank you! This worked to do one column at a time. Do you know if there is a way to do three columns at a time? I.E. i tried doing CurrentRow.ByField(“A:C”) which didn’t work.

6

@mwells
You should introduce three type into for three columns in this case

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.