We require a tool/program/utility that can do the following - Scan folders to lo

Question

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?

Explanation / Answer

You almost certainly will need to write such a tool yourself. While there are various libraries that allow you to interpret Excel files etc. a tool that does this specific thing must need to be created first.

If you decide to write such a tool, I can recommend the Apache POI Library to do the excel handling. It is a Java Library from the well known Apache Foundation. Java could handle the other tasks as well, but is really on the "heavy" side for such a small tool (seriously).

Other languages bring other tools and some tools may even have command line support so you can parse that excel from within a shell script (or batch if you are on windows).

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.