Excel to Sap based on condition

Learning Initatives Automation Starter
1

Hi,

Generate Event Text.xlsx (9.3 KB)
In the above excel file has 28 lines of processed data that should not be written into SAP because sap screen can store only 20 lines, its should show a error message. How to do that.

image
image747×538 4.18 KB

Thanks,
Lakshmi

2

Check the number of rows in excel file …dt.rows.count
check if dt.rows.count >20
then throw the exception

3

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