Warm Greetings, My query Data is populated into a particular table in SAP from Excel (700 rows, 3 columns) For every 19th row in excel data, a manual intervention is required in SAP. Requirement Is there an activity or any other option to pause the bot as soon as it reaches every 19th row? So, …

Hey @vignesh_krishnamoorthy Welcome to the UiPath Community! The easiest way to achieve what you’re trying to do is to use Message Box activity. Read more about Message Box here … Add a counter variable which you will increment at the end of the loop Add an if condition for modular division to f…

Can you explain with a simple sequence? Would be helpful.

Hi @vignesh_krishnamoorthy Welcome to community. :slight_smile: Please see the attached file: Sequence30.xaml (7.7 KB) Here is the excel file also: InputTable.xlsx (21.3 KB) Best regards Mahmoud

Hi Dawodm, Thanks for your reply. Requesting a screenshot of the sequence attached. Facing a glitch loading the same. [image] Regards

Hi @vignesh_krishnamoorthy [image] I think you’re missing the following: UiPath.Excel.Activities UiPath.System.Activities

Hi @vignesh_krishnamoorthy Please see this comment. I think you don’t have these packages in your UiPath Studio, therefore you are not able to see the activities. Please import these packages and then try to see my sequence. @RPAForEveryone Thanks :slight_smile:

Hi Dawodm, Thankyou for your reply. Can you please name the packages to be imported?

Hi Dawodm, Still the sequence isnt getting enabled. [image] For your reference. Please help. Regards

oh sorry, I sent the wrong package name. You need to import the normal excel package. You don’t have the standard activities. Please make sure you have these activities: Read Range, For Each Row etc. For example for the excel activities you need the following package: [image] Best regards Mah…

EXCEL - SAP integration

Help Activities

vignesh_krishnamoorthy (vignesh krishnamoorthy) September 7, 2021, 5:22am 13

Hi Dawodm,

Thankyou for the revert. Kindly check the below.

Regards

Topic		Replies	Views
Extract from Excel to SAP more columns that are visible in SAP Activities excel , activities , question , sap_bapi	6	2039	October 11, 2021
Read and stop iteration from excel file to SAP when empty Academy Feedback datatable , excel , uiautomation , sap , activities	3	1350	June 2, 2020
Batch processing of bulk excel data in SAP Help datatable , excel , uiautomation , robot , data_scraping , data_manipulation	1	1651	October 22, 2020
Excel Grouping and Looping in SAP Studio excel , sap , studio , question , activities_panel	9	903	June 26, 2022
SAP Automation Activity StudioX studiox , question	4	1200	February 1, 2022

EXCEL - SAP integration

Related topics