4ee98f4d-c13f-41fa-babe-dbd4059e4563.png

This workflow reads all the sheets present in the .xls and .xlsx files placed inside folders/subfolders. As an output it creates one Excel file per sheet read. The workflow accepts three input arguments, namely:

*   in\_FolderPath(String) -  accepts the folder path containing other folders and subfolders.
*   in\_OutputFolder(String) - accepts the folder path where the output files will be placed.
*   in\_TakePathFromUser(Boolean) - flag to decide if value of in\_FolderPath and in\_OutputFolder is to be taken through input dialog box or through arguments.

This workflow can be used if there is a need to read out multiple sheets in multiple Excel files placed inside folders or their sub folders. Just provide the parent folder path and the output location path, this workflow will iterate through all the sheets of all the Excel files. It will read the data in each sheet and create an output Excel file per sheet at the designated location. 

The output file will be created at the path provided in the in\_OutputFolder argument. The name of each file will be following the naming convention as: **"File\_"+sheet.ToString+"\_"+Now.ToString("ddMMyy.HHmmss")+".xlsx"**

where the **sheet.ToString** is the name of the sheet currently being processed.

Workflow to read all the sheets present in Excel files inside folders and their subfolders. As an output creates one Excel file per read sheet.

c4d4b003-77ca-49aa-b3a9-0dc56c07dd29.png

This snippet is designed to group all files into different subfolders based on file extension. The folder path is provided by the user. This workflow accepts the following **input arguments:**

*   in\_strOptionByUser (String) - represents the value to decide whether the bot should start or not.
*   in\_strUserInputFolderPath (String) - represents the folder path to organize the files.
*   in\_strUserInput (String) – represents the selected option (out of 3 options – Create new folder, Add in existing folder, Keep in Miscellaneous), chosen by the user if file type is unknown.

This workflow can be used to organize any given folder. It comes preloaded with the essential file types and folder structure. The file types defined in the Config file are:

*   **Documents:**

         o Compressed - .zip

         o Pdf – .pdf

         o Excel\_WordDoc – .doc, .docx, .csv, .xls, .xlsx

*   **Photos** - .png, .jpg, .bmp, .jpeg
*   **Videos** - .mp4
*   **Music** - .mp3
*   **Application Setup** - .exe, .msi
*   **Miscellaneous**

It asks the user to select the folder he/she wants to organize, loops all the files present in the folder, checks the extension of each file and moves it into the respective subfolder. More file types can be pre-defined in the Config file just by adding a row and entering the details ‘File extension’ and ‘Folder Name’. For any file which has an unknown extension, it gives the user the three options below:

*   **Create a new folder** – Creates a new subfolder with the name entered by the user and moves the file to that subfolder. It also adds this file-folder mapping into the Config file and moves all the files with this extension to the required subfolder.
*   **Add in existing folder** – Gives a drop-down option to the user and moves the file to the chosen subfolder. It also adds this file-folder mapping into the Config file and moves all the files with this extension to the required subfolder.
*   **Keep in miscellaneous** – Moves the file to the miscellaneous subfolder.

This workflow also gives the user the option to move all the personal files to the personal subfolder if the ‘Username’ is filled in the Config file. The bot will check the name of each file and if it has ‘Username’ in it, it will create a sub-folder named “Username” and moves the file into it.

Attended bot to organize files in a folder into different subfolders based on extension. For unknown file types, option appears to create a new, add in existing or move to Miscellaneous sub-folder.

About me