Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Best Approach to Insert bulk collection Data to Excel

vinodchinthakin
Level 9

‎08-11-22 09:41 AM

Hi All,

May I know what is the Best Approach to Insert bulk collection (say >50k) to excel without chunking the collection

------------------------------
vinod chinthakindi
------------------------------
0 Likes
2 REPLIES 2

MichaelAnnis1
Staff
Staff

‎08-11-22 03:53 PM

You are reading from some other source.  Is it possible to break the source before importing it in?

For example, if I am getting it from Excel, I could just read rows 1-10,000, and then on the next loop read 10,001 - 20,000.

------------------------------
Michael Annis
------------------------------
0 Likes

vinodchinthakin
Level 9
In response to MichaelAnnis1

‎08-11-22 04:04 PM

Lets say I am getting from other source SQL DB or API or some other DB.
Requirement is I need to process(apply some business logics) all data in collection then needs to insert Bulk data to Excel

------------------------------
vinod chinthakindi
------------------------------
0 Likes