I have a datatable with about 50K rows and 30 columns. And, i need to write one particular column from that data table into an excel that is already opened.
Excel also contains 30+ columns. I would like to write the values in column number 5.
Any suggestions appreciated.
PS: The excel file that i use has predefined validation. Hence it is mandatory that i use that particular file rather than writing the entire datatable in a new excel.