Best Approach to Insert bulk collection Data to Excel
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
------------------------------
May I know what is the Best Approach to Insert bulk collection (say >50k) to excel without chunking the collection
------------------------------
vinod chinthakindi
------------------------------
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
------------------------------
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
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
------------------------------
Requirement is I need to process(apply some business logics) all data in collection then needs to insert Bulk data to Excel
------------------------------
vinod chinthakindi
------------------------------