New user here. While we use Excel here at work, it is only in the capacity
of providing input data and reviewing test results of our testing.
At work, they use a 3rd party tool that accepts
a .csv file and converts it
to an .xls file. This is input data for data driven scripts used by
WinRunner (a testing tool). We don't want to be loading Excel and simply
reading the .csv file and then save it as an .xls file because we have the
conversion scheduled to run in the morning when the input data is supposed
to arrive. We also don't want to be using Excel itself since we would have
to lose a license for a copy to install it on the server.
Preferrably the tool should be open source (i.e., free)
WinRunner doesn't accept .xls files with more than one worksheet in them
(i.e., you need to have just one spreadsheet in the file). This is the
format that the users are supposed to use when they give us the data.
To summarize, the requirements are:
- Converts .csv file to an .xls file.
- Only need to support an .xls file with one worksheet.
- Runs on a NT-based Windows platform (Windows 2000/2003/XP).
- Has command-line parameter to specify the input and output files. No GUI
gets used (if it has one, it must still run from a command line).