We require a tool/program/utility that can do the following -
- Scan folders to look for Excel files at regular intervals.
- The Excel file might have different formats and the output has to be in a corresponding format in CSV file.
- When an Excel file is found, read the file, do some data manipulation to achieve the desired format and then save the output as a CSV file at a desired network location.
- Data manipulation can be of following kinds - ignore a particular column of the spreadsheet, perform a mathematical operation on two columns and save into a single column in CSV, concatenate two columns, etc.
Does anyone know if there is any tool to achieve the above requirement?