How to automate excel which have aprox 200 million record

Help Activities
, , , , , , , , , , , , , ,
1

How to automate excel which have aprox 200 million record

2

use excel as database to proceed with this

3

Use workbook activity to read excel (don’t use Excel Application scope, it is slower), then you have two options:

  1. Process data table with LINQ statements

  2. Process data table with either VB.NET or C#, through “Invoke Code”

The latter option is highly performant, when it comes to large data sets.

4

Can you help me how to learn excel activity in vb .net? Any learning platform or video tutorials?

5

Here are some links to start from:

VB.NET / C#:
Excel Automation Using VB.NET In UiPath

LINQ:

If anyone has more suggestions, feel free to post more useful resources.

6

Any other solution please help me for this topic

7

LINQ isn’t faster. This is a myth.

8

How do you have a spreadsheet with almost 200 times more rows than the limit for Excel?