@Test
public void testIntegration() throws Exception {

    final ExternalSpreadsheetCompiler converter = new ExternalSpreadsheetCompiler();
    final String drl = converter.compile("/data/IntegrationExampleTest.xls", "/templates/test_integration.drl", 18, 3);
    KnowledgeBuilder kbuilder = KnowledgeBuilderFactory.newKnowledgeBuilder();
    kbuilder.add(ResourceFactory.newByteArrayResource(drl.getBytes()), ResourceType.DRL);
    assertFalse(kbuilder.hasErrors());
    InternalKnowledgeBase kbase = KnowledgeBaseFactory.newKnowledgeBase();
    kbase.addPackages(kbuilder.getKnowledgePackages());
    KieSession kSession = kbase.newKieSession();
    //ASSERT AND FIRE
    kSession.insert( new Cheese( "stilton", 42 ) );
    kSession.insert( new Person( "michael", "stilton", 42 ) );
    List<String> list = new ArrayList<String>();
    kSession.setGlobal( "list", list );
    kSession.fireAllRules();
    assertEquals( 1, list.size() );
}