You need to download scriptella , sqlsheet driver and it's dependencies .
Follow the steps:
- Download scriptella binary distribution
- Unpack it and add a ${SCRIPTELLA_DIR}/bin to a system PATH variable
- Use set PATH=%PATH%;SCRIPTELLA_DIR\bin for Windows
- Use export PATH=${PATH}:SCRIPTELLA_DIR/bin for Unix
- Check if JRE has been installed correctly by running:
java -version
- Check if scriptella has been installed correctly by running:
scriptella -version
- Put sqlsheet driver to the ${SCRIPTELLA_DIR}/lib directory
- Put sqlsheet driver dependencies to the ${SCRIPTELLA_DIR}/lib directory
- Put janino.jar and commons-compiler.jar to the ${SCRIPTELLA_DIR}/lib directory
- Download test script
- Execute test script:
scriptella xls_test.xml
- Check generated XLS/XLSX files
- Enjoy!