I need a quick help from you.
I am currently working on the excel automation. For this I am doing the following:-
- Inside while loop I am doing data extraction (in other words I have the datatable)
- Now, I am writing this dataTable into the excel.
- In the second iteration, I get another data extraction(dataTable) which is appended to this one.
Now for this I want to know how do I get the cell number from where the appending on the second table will start such that there is no Empty row in between and also there is no overlapping.
I want to do this dynamically for multiple datatable appending in excel sheet.
Thanks and Regards,