Read Excel cell and paste data in SAP

[Rahulsinha (RPA-DS Enthusiast)]

Hi Team,

Hope you all are safe.

I came across a new query where I have to read 6 columns and multiple rows or minimum 30 rows (Bases on sheet name) in an excel and the have to paste the data in SAP based on each row data as below.

I am unable to get the best possible way to work on this scenario, could you please help me to develop the workflow.

[raj.parsana (Raj Suresh Parsana)]

Hello @Rahulsinha,

You can extract cells like this :-
dt_Test.Rows(input row number).Item(“input column name”).ToString

[balupad14 (Balamurugan)]

Hi @Rahulsinha,

Use this activity to copy the data to set in clipboard in Excel .

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed the new activity in the package of BalaReva EasyExcel.Activities .It is called “Copy ToClipboard” .It copies the excel data to the clipboard. (The BalaReva.Excel.Activities have the same activity called “CopyData”) [image] Sample : ExcelCopyPaste.zip (26.4 KB) Thank you Balamurugan.S

Use the shortcut in SAP to paste.

Thank you
Balamurugan.S

[Rahulsinha (RPA-DS Enthusiast)]

Thanks @balupad14
Could you please confirm how will I be able to paste it in SAP because all data will need to be put in different fields in SAP. bit confused