Usage

Respix always requires a current Java Runtime Environment to be installed (Java 1.7 or higher strongly recommended). The Respix transformation is implemented as an independent library that can be accessed in multiple ways

  1. Call in a Java program:
    Respix itself is just a piece of Java code that can be called by other programs and writes a new result file, given a specification and a configuration file.
    It can be called by the following two lines (no linebreaks, of course):
    RSXProcessor proc =
    new RSXProcessor("pathToSpecification.xlsx","pathToOutputFile.xlsx", "pathToConfig.config");
    proc.process();


  2. Command line: You can also run respix from the command line using the packaged respix.jar:

    d:\test > java -jar respix.jar -s HelloWorld.xlsx -o HelloWorld_out.xlsx -c respix.config

    -s gives the specification (source) .xlsx file, -o determines the output file, and -c specifies the configuration file.

  3. GUI: Respix also provides a simplistic graphical user interface to choose the specification file, the output file and the configuration. It can be called by

    d:\test > java -jar respix.jar -gui


  4. Excel Macro
    Respix also provides the possibility to start respix directly from within MS-Excel.
    For that purpose a template file is provided that contains the respective macro and additional ribbon (see ~\Cref{fig:respix-addin}).
    The macro assumes that the \code{respix.jar} and a configuration file called \code{respix.config} are located in the same folder as the specification file.
    This option is currently only available for MS-Excel, not form OpenOffice/LibreOffice.