Hi,
My process interacts with SAP and Excel. One of the tasks is to copy a column of values (no more than 100 items) from an Excel worksheet and paste it into separate rows of a table on an SAP screen. I use the MS Excel VBO Select and Copy actions to place the values in the clipboard and the SAP screen has an Import Clipboard button that pastes the copied items into contiguous rows of the table. The process is in a loop that handles many items and each iteration requires the values extracted from Excel to be pasted into SAP. That means I need to keep the worksheet open and read the desired values in each iteration. The values in the Excel file can change on a daily basis but, once read, can be considered constant for the duration of a single run, regardless of the number of iterations. I want to read these values once at the beginning of a run, put them into a collection, then close the Excel file and click the SAP button to paste those values into the table for each iteration of the loop. I can use the MS Excel VBO Get Worksheet Range As Collection action to put the data into a collection but I don't know how to put that collection of values into the clipboard for each iteration (the clipboard is used in other activities so the clipboard contents do not persist beyond a single iteration). The Utility-Environment Set Clipboard takes a text argument rather than a collection and the Utility-Collection Manipulation Copy Rows action cannot output to the clipboard.
Does anyone know how I can populate the clipboard from a collection so that, when pasted, the items appear on separate rows rather than a long string on a single row of the table?
Thanks,
Michael Bailey
My process interacts with SAP and Excel. One of the tasks is to copy a column of values (no more than 100 items) from an Excel worksheet and paste it into separate rows of a table on an SAP screen. I use the MS Excel VBO Select and Copy actions to place the values in the clipboard and the SAP screen has an Import Clipboard button that pastes the copied items into contiguous rows of the table. The process is in a loop that handles many items and each iteration requires the values extracted from Excel to be pasted into SAP. That means I need to keep the worksheet open and read the desired values in each iteration. The values in the Excel file can change on a daily basis but, once read, can be considered constant for the duration of a single run, regardless of the number of iterations. I want to read these values once at the beginning of a run, put them into a collection, then close the Excel file and click the SAP button to paste those values into the table for each iteration of the loop. I can use the MS Excel VBO Get Worksheet Range As Collection action to put the data into a collection but I don't know how to put that collection of values into the clipboard for each iteration (the clipboard is used in other activities so the clipboard contents do not persist beyond a single iteration). The Utility-Environment Set Clipboard takes a text argument rather than a collection and the Utility-Collection Manipulation Copy Rows action cannot output to the clipboard.
Does anyone know how I can populate the clipboard from a collection so that, when pasted, the items appear on separate rows rather than a long string on a single row of the table?
Thanks,
Michael Bailey