DESCRIPTION:
xls2odat converts one or more XLS files to flat files so they can be imported to a drugstore software or a pharmacy software in Switzerland.
xls2odat parses XLS files depending on a configuration XLS file, and outputs the data separated by “|” symbol.
FEATURES/PROBLEMS:
xls2odat just converts files. It does not manage any codes.
REQUIREMENTS:
ruby 1.8 or later
spreadsheet
INSTALL LINUX:
The easiest way to install is via RubyGems. On the command line enter:
sudo gem install xls2odat
To manually install, use the included setup.rb script:
sudo ruby setup.rb
See test directory for tests. Run
ruby test/test_xls2odat.rb
for testing.
INSTALL WINDOWS:
For Windows users, use this oneclick installer to install Ruby.
* http://rubyforge.org/frs/download.php/71066/rubyinstaller-1.8.6-p398.exe
then
* be sure to check the two checkboxes (.rb and PATH for Ruby on Windows) * gem install spreadsheet * gem install xls2odat * chdir to where your config file and XLS files are * xls2odat config.xls file_1.xls file_2.xls * enjoy the output files.
xls2odat will tell the difference of the file version by the config file.
USAGE:
xls2odat config_file.xls data_file1.xls data_file2.xls
LICENSE:
GPLv2, see LICENSE file
Author:
Masaomi Hatakeyama
Author README
Masaomi Hatakeyama
Zeno R.R. Davatz