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


#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