Problem:
I have a column that I should add in an excel file.
The data that should be written for the new column is the same for all rows.
Is there a way to write the column data without using a loop - may it be looping for the datatable or the excel - write cell? Because the rows are over 100k, and looping for such a number takes quite a long time. And users can actually just drag the first row to the last, writing the data almost instantly.
Given:
Please advise.
Thanks,
Michael