Hi, I have this excel files.
Now I want to split the row data and want to save in diff - 2 excel files.
Like. In this 5 excel will be creating,
Ex. Excel1 contain the Headers with the A2 complete row data,
Excel2 contains the Headers with A2 complete row data.
I want to save this data into diff 2 excel files.
I created the logic but confused while writing the data of single row. since I am storing this complete data in a dt variable. but confused how to write only the single - 2 row data with the headers.