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

75804c2d-d969-486a-be75-b5de9cea9af2.xaml

The goal of this workflow is to read data from all the sheets present in Excel files placed inside folders/subfolders and create one output file per read sheet.

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.

f7071e4d-6130-414c-90ae-0f60b144190c.jpeg

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Visual Basic

This is the first version of this snippet. The snippet deals with reading all of the sheets present in an .xls or .xlsx file in a folder/subfolder. As an output, this snippet creates one Excel file for each sheets that it reads.

Read Sheets from .xls/.xlsx file

Read Sheets from .xls/.xlsx file

Merge Content of Multiple Excel Files…