Export 2000 records from datatable to excel

Help Studio
, ,
1

Hi,

I am trying to export 2000 entries from SAP to Data table. Currently I am having 2000 entries copied in my datatable. When i tried writing entire content from datatable to excel via Write Range activity, it is copying only 91 records. When i check count of datatable, it is showing count as 2000. Can anyone please suggest me some solutions.

Regards,
Meena

2

Hi @Meena_Kumari,

Welcome to UiPath community!.

Use Excel application scope with Excel write range activity.

3

@sarathi125

Thanks for the suggestion. I am using excel application scope, inside that I am using write range activity. Still it is copying only 91 records.

4

@Meena_Kumari,

Are you passing any range? in the Write Range activity?

Try to write into a different excel file and check the same.

5

@sarathi125

I am not passing any range. I have added write range activity and gave inputs as sheet name and data table name. Can you please tell me if any range needs to be mentioned in write range activity. I have tried with new excel also. But still it is copying only 91records.

6

Please share your code if possible or else provide screenshot of your code with the details