@Test public void testLoadBasicWithMergedCells() { final ExternalSpreadsheetCompiler converter = new ExternalSpreadsheetCompiler(); final String drl = converter.compile( "/data/BasicWorkbook.xls", "/templates/test_template3.drl", InputType.XLS, 10, 2 ); final String drl1 = converter.compile( "/data/BasicWorkbook.xls", "/templates/test_template3.drl", InputType.XLS, 21, 2 ); assertNotNull( drl ); Pattern p = Pattern.compile( ".*setIsValid\\(Y\\).*setIsValid\\(Y\\).*setIsValid\\(Y\\).*", Pattern.DOTALL | Pattern.MULTILINE ); Matcher m = p.matcher( drl ); assertTrue( m.matches() ); assertTrue( drl.indexOf( "This is a function block" ) > -1 ); assertTrue( drl.indexOf( "global Class1 obj1;" ) > -1 ); assertTrue( drl1.indexOf( "myObject.setIsValid(10-Jul-1974)" ) > -1 ); assertTrue( drl.indexOf( "myObject.getColour().equals(blue)" ) > -1 ); assertTrue( drl.indexOf( "Foo(myObject.getColour().equals(red), myObject.size() > 12\")" ) > -1 ); assertTrue( drl.indexOf( "b: Bar()\n eval(myObject.size() < 3)" ) > -1 ); assertTrue( drl.indexOf( "b: Bar()\n eval(myObject.size() < 9)" ) > -1 ); assertTrue( drl.indexOf( "Foo(myObject.getColour().equals(red), myObject.size() > 1)" ) < drl.indexOf( "b: Bar()\n eval(myObject.size() < 3)" ) ); }
public String compile(final String xls, final String template, int startRow, int startCol) { return compile( xls, template, InputType.XLS, startRow, startCol ); }
ExternalSpreadsheetCompiler { public String compile(final String xls, final String template, int startRow, int startCol) { return compile( xls, template, InputType.XLS, startRow, startCol ); } }
ExternalSpreadsheetCompiler { public String compile(final String xls, final String template, int startRow, int startCol) { return compile( xls, template, InputType.XLS, startRow, startCol ); }  }
ExternalSpreadsheetCompiler { public String compile(final String xls, final String template, int startRow, int startCol) { return compile( xls, template, InputType.XLS, startRow, startCol ); }  String compile(final String xls,
                          final String template,
                          int startRow,
                          int startCol); String compile(final String xls,
                          final String template,
                          InputType type,
                          int startRow,
                          int startCol); String compile(final String xls,
                          final String worksheetName,
                          final String template,
                          int startRow,
                          int startCol); String compile(final InputStream xlsStream,
                          final InputStream templateStream,
                          int startRow,
                          int startCol); String compile(final InputStream xlsStream,
                          final InputStream templateStream,
                          InputType type,
                          int startRow,
                          int startCol); String compile(final InputStream xlsStream,
                          final String worksheetName,
                          final InputStream templateStream,
                          int startRow,
                          int startCol); void compile(final String xls,
                        InputType type,
                        final List<DataListener> listeners); void compile(final String xls,
                        final Map<String, List<DataListener>> listeners); void compile(final InputStream xlsStream,
                        InputType type,
                        final List<DataListener> listeners); void compile(final InputStream xlsStream,
                        final Map<String, List<DataListener>> listeners); String compile(final InputStream xlsStream,
                          final InputType type,
                          final TemplateDataListener listener); String compile(final InputStream xlsStream,
                          final String worksheetName,
                          final TemplateDataListener listener); }
ExternalSpreadsheetCompiler { public String compile(final String xls, final String template, int startRow, int startCol) { return compile( xls, template, InputType.XLS, startRow, startCol ); }  String compile(final String xls,
                          final String template,
                          int startRow,
                          int startCol); String compile(final String xls,
                          final String template,
                          InputType type,
                          int startRow,
                          int startCol); String compile(final String xls,
                          final String worksheetName,
                          final String template,
                          int startRow,
                          int startCol); String compile(final InputStream xlsStream,
                          final InputStream templateStream,
                          int startRow,
                          int startCol); String compile(final InputStream xlsStream,
                          final InputStream templateStream,
                          InputType type,
                          int startRow,
                          int startCol); String compile(final InputStream xlsStream,
                          final String worksheetName,
                          final InputStream templateStream,
                          int startRow,
                          int startCol); void compile(final String xls,
                        InputType type,
                        final List<DataListener> listeners); void compile(final String xls,
                        final Map<String, List<DataListener>> listeners); void compile(final InputStream xlsStream,
                        InputType type,
                        final List<DataListener> listeners); void compile(final InputStream xlsStream,
                        final Map<String, List<DataListener>> listeners); String compile(final InputStream xlsStream,
                          final InputType type,
                          final TemplateDataListener listener); String compile(final InputStream xlsStream,
                          final String worksheetName,
                          final TemplateDataListener listener);  }