I have files in a folder and sub-folders, which I take and filter it down based on the extension ".xlsx"
Now for each file
1. Launch the excel file
2. Read the data
3. Close the excel file
4. Launch 2nd Excel file
5. Write the data from the empty row
6. Close it
After writing the data in the 5th step, I have to write data in the column Column.Count + 1, which is nothing but the filePath
In the next iteration the data should be appended directly under the file path column (File2, 3,...)
Can someone help me on this?
