How to automate excel which have aprox 200 million record
use excel as database to proceed with this
Use workbook activity to read excel (don’t use Excel Application scope, it is slower), then you have two options:
Process data table with LINQ statements
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.
Can you help me how to learn excel activity in vb .net? Any learning platform or video tutorials?
Here are some links to start from:
If anyone has more suggestions, feel free to post more useful resources.
Any other solution please help me for this topic
LINQ isn’t faster. This is a myth.
How do you have a spreadsheet with almost 200 times more rows than the limit for Excel?