When we try to write more than 2 Lacs record from database to excel, Getting error 'Range does not exists' in community edition

Help
1

Scenario: When we try to write more than 2 Lacs record from database to excel, Getting error ‘Range does not exists’ in community edition.

Steps to reproduce: Create a excel scope and write the data table which have more than 2 lacs record

Current Behavior: Getting Exception

Expected Behavior: Should write the data in excel file

Studio/Robot/Orchestrator Version: NA

Last stable behavior: NA
Last stable version: NA
OS Version: W-10
Others if Relevant: (workflow, logs, .net version, service pack, etc):

2

not sure datatable have any limit for storing values but could you please confirm for how many records you able to copy to excel?

3

There is a limit but it is huge.

According to the Documentation, the limit is 16,777,216 rows.(Check Remark Section).
But the page is not showing limitations in terms of MBs

Regards…!!
Aksh

1 Like
4

I am also facing the same issue.
My datatable is having around 3 lac records.
It is working fine till ~1,60,000 records but more than that causing ‘range does not axist error’.
Please give me some solution around this.

1 Like