Hi,
I want to read an excel file that contains 200,000 + rows of records, spanning across 50 + columns.
I read in the forum that the number of rows can be split and the dataTable can read 10K rows at a time.
However I require to perform VLOOKUP on few columns from a file that is equally heavy. (200,000+ rows & 50+ columns).
Can someone suggest the approach to go about this problem?
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu