title: Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath
body: <p>Good Morning, 
  I'm trying to replicate this: <a href="http://jxls.sourceforge.net/getting_started.html" rel="nofollow">http://jxls.sourceforge.net/getting_started.html</a> </p>
  
  <p>Using my own class action instead of employees.
  But I have some issue.</p>
  
  <p>This is my code:</p>
  
  <pre><code>package src;
  
  import java.util.List;
  import java.io.File;
  import java.io.FileInputStream;
  import java.io.FileOutputStream;
  import java.io.IOException;
  import java.io.InputStream;
  import java.io.OutputStream;
  import java.net.URISyntaxException;
  import java.net.URL;
  import java.time.LocalTime;
  import java.util.ArrayList;
  
  
  import org.jxls.common.Context;
  import org.jxls.util.JxlsHelper;
  import org.slf4j.Logger;
  import org.slf4j.LoggerFactory;
  
  
  
  public class Excel {
  
  public static void main(String[] args)throws IOException, InterruptedException{
  
      String srcFilePath  = "C:/Users/BKLYN/workspace/GenerateABSValues/action_template.xls";
      String destFilePath = "C:/Users/BKLYN/workspace/GenerateABSValues/actionCour.xls";
  
      LocalTime time = LocalTime.now();
  
      Logger logger = LoggerFactory.getLogger(Excel.class);
      logger.info("Test Action");
  
      //List&lt;action&gt; listAction = generateData(time);
  
  
      try(InputStream is = Excel.class.getResourceAsStream(srcFilePath)) {
          try (OutputStream os = new FileOutputStream(destFilePath)) {
              List&lt;action&gt; listAction = generateData(time);
              Context context = new Context();
              context.putVar("action", listAction);
              JxlsHelper.getInstance().processTemplate(is, os, context);
              System.out.println("5");
  
          }catch (Exception e){
              e.printStackTrace();
          }
      }catch (Exception e){
          e.printStackTrace();
      }
  
  
  }
  
  
  
      private static List&lt;action&gt; generateData(LocalTime time){
  
          List&lt;action&gt; listAction = new ArrayList&lt;&gt;();
          for (int i =0; i&lt;10; i++){
              listAction.add(new action("AB SCIENCE", time, i));
              System.out.println("name=" + "AB SCIENCE" + " time= " + time + " Value= " + i);
          }
          return listAction;
      }
  
  
   }
  </code></pre>
  
  <p>I generate values for action which is the employees of the tutorial.</p>
  
  <p>I add theses jar files to my project: 
  asm-3.3.1.jar -<br>
  cglib-2.2.2.jar -
  commons-beanutils-1.9.2.jar - 
  commons-codec-1.9.jar -
  commons-collections-3.2.1.jar -
  commons-digester3-3.2-with-deps.jar -
  commons-jexl-2.1.1.jar -
  commons-logging-1.1.1.jar -
  jcl-over-slf4j-1.7.12.jar -
  jxl-2.6.10.jar -
  log4j-1.2.14.jar -
  logback-classic-1.1.3.jar - 
  logback-core-1.1.3.jar - 
  poi-3.12.jar - 
  poi-ooxml-3.12.jar -
  poi-ooxml-schemas-3.12.jar - 
  slf4j-api-1.7.12.jar - 
  stax-api-1.0.1.jar - 
  xmlbeans-2.6.0.jar -
  jxls-2.3.0.jar - 
  jxls-jexcel-1.0.6.jar - 
  jxls-poi-1.0.9.jar - 
  jxls-reader-2.0.2.jar  -   </p>
  
  <p>And when I try to run the project I got this: </p>
  
  <pre><code>19:38:14.601 [main] DEBUG org.jxls.util.TransformerFactory - Transformer class is org.jxls.transform.poi.PoiTransformer
  19:38:14.608 [main] ERROR org.jxls.util.TransformerFactory - Method createTransformer of org.jxls.transform.poi.PoiTransformer class thrown an Exception
  java.lang.reflect.InvocationTargetException: null
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~   [na:1.8.0_91]
  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_91]
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_91]
  at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_91]
  at org.jxls.util.TransformerFactory.createTransformer(TransformerFactory.java:35) ~[jxls-2.3.0.jar:na]
  at org.jxls.util.JxlsHelper.createTransformer(JxlsHelper.java:202) [jxls-2.3.0.jar:na]
  at org.jxls.util.JxlsHelper.processTemplate(JxlsHelper.java:93) [jxls-2.3.0.jar:na]
  at src.Excel.main(Excel.java:43) [classes/:na]
  Caused by: java.lang.NullPointerException: null
  at    org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:162) ~[poi-ooxml-3.12.jar:3.12]
  at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:143) ~[poi-ooxml-3.12.jar:3.12]
  at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:49) ~[jxls-poi-1.0.9.jar:na]
  at org.jxls.transform.poi.PoiTransformer.createTransformer(PoiTransformer.java:42) ~[jxls-poi-1.0.9.jar:na]
  ... 8 common frames omitted
  
  
  java.lang.IllegalStateException: Cannot load XLS transformer. Please make  sure a Transformer implementation is in classpath
  at org.jxls.util.JxlsHelper.createTransformer(JxlsHelper.java:204)
  at org.jxls.util.JxlsHelper.processTemplate(JxlsHelper.java:93)
  at src.Excel.main(Excel.java:43)
  </code></pre>
  
  <p>And the dependencies I have now: </p>
  
  <pre><code> &lt;dependencyManagement&gt;
  &lt;dependencies&gt;
    &lt;dependency&gt;
      &lt;groupId&gt;org.jxls&lt;/groupId&gt;
      &lt;artifactId&gt;jxls&lt;/artifactId&gt;
      &lt;version&gt;2.3.0&lt;/version&gt;
    &lt;/dependency&gt;
    &lt;dependency&gt;
      &lt;groupId&gt;org.jxls&lt;/groupId&gt;
      &lt;artifactId&gt;jxls-poi&lt;/artifactId&gt;
      &lt;version&gt;1.0.9&lt;/version&gt;
    &lt;/dependency&gt;
    &lt;dependency&gt;
      &lt;groupId&gt;org.jxls&lt;/groupId&gt;
      &lt;artifactId&gt;jxls-jexcel&lt;/artifactId&gt;
      &lt;version&gt;1.0.6&lt;/version&gt;
    &lt;/dependency&gt;
  &lt;/dependencies&gt;
  </code></pre>
  
  <p></p>
  
  <p>I tried to add many different things to the depencies, nothing changed. I updated the project with maven > update project. It was worst. I recreated the project different times to add correctly the jar to avoid conflict. I know that other people already asked for this but I couldn't find a correct answer. </p>
  
  <p>I'm not really good at using java so maybe the error is  obvious. What is the missing file and where/how could I add it ?</p>
  
  <p>Thank you.</p>