Any way to hasten 'For Each Row'?


I’m try to run an automation base on Data Scraping from a web page, and load a table into an Excel. Before load into Excel, I need to insert addition Column to the table name “Date”. So I use ‘For Each Row’ to insert data into “Date” Column, after data inserted then load the table into Excel, but the entire process is taking very long(around 2k rows is counted) due to ‘For Each Row’ adding data to “Date” Column. any recommendation?

Hi @Nox_Lee
Welcome here,
I think parallel foreach will work for you…


parallel use system.Collections.generic.IEnumerable(default), not able to convert DataTable. any way i can convert?

i need to keep as DataTable so that i can able to use ‘Add Column’