This is a program to monitoring files in a specific folder that you select and check files in Excel, if the program find a excel file, it will copy the sheets into a new file root call ExcelRoot.xlsx.
When you execute the .exe program it will show you this windows
Then you have to select the folder that you want to check files
it will show you a windows, then select your folder to check files, can be any folder, for this ex. Excel
When you have selected your folder, it will start monitoring files
Then the program will create 3 files
it will create the 2 folders
- Processed: it will contains the processed excel files that have copy succesfully to the root excel file
- Not Aplicable: it will contains the files that are not excel files, any files except Excel files
ExcelRoot File: it will contains the copy sheets of the other excel files that have processed
#Tests to make the test, just copy a excel file that contains data in the sheets
in this example we will copy this file to the Excel folder that we have selected before.
Ad you can see the Root Excel File not contains any data.
Then just copy the file, and the windows it will show you if the file processed or not.
Result
And when you check the ExcelRoot.xlsx, it will copy the sheets of the Test File to ExcelRoot
And the file that have been processed, it will move to the processed folder
#Not Aplicable Files If the file that we have created in the folder that we have monitoring is not a ExcelFile, it will show that is not aplicable and it will move it to the Not Aplicable Folder. (Any File that is not .xlsx