title: Jxls Error : Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath
body: <p>This question has been already asked once but no one gave a absolute solution to it.
  Im trying to generate a xls file from a existing template but im getting an error which I dont know how to face out!</p>
  
  <p>My code:
  String nombre = "Manuel";</p>
  
  <pre><code>        try (InputStream templateFileName = ExportExcelServlet.class.getResourceAsStream("/segJBOSS/lib/xls/Tabla_Gestion.xlsx")) {
              try (OutputStream destFileName = new FileOutputStream("Tabla_Gestion.xls")) {
                  ArrayList&lt;String&gt; array = new ArrayList&lt;String&gt;();
                  array.add(nombre);
                  Context context = new Context();
                  context.putVar("gestion", array);
                  JxlsHelper.getInstance().processTemplate(templateFileName, destFileName, context);              
                  } catch (Exception e) {
                  // TODO: handle exception
                  System.out.println(e.getMessage());
                  e.printStackTrace();                
                  }
  
          } catch (Exception e) {
              // TODO: handle exception
              System.out.println(e.getMessage());
              e.printStackTrace();
          }
      } catch (Exception e) {
          // TODO: handle exception
          System.out.println(e.getMessage());
          e.printStackTrace();
      }
  </code></pre>
  
  <p>This is being implemented into a WebServlet.</p>
  
  <pre><code>17:08:43,472 ERROR [org.jxls.util.TransformerFactory] (default task-3) Method createTransformer of org.jxls.transform.poi.PoiTransformer class thrown an Exception: java.lang.reflect.InvocationTargetException
  
  Caused by: java.lang.NullPointerException
  
  17:08:43,478 INFO  [stdout] (default task-3) Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath
  17:08:43,479 ERROR [stderr] (default task-3) java.lang.IllegalStateException: Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath
  </code></pre>
  
  <p>Thanks alot!</p>