Package net.firstpartners.spreadsheet

Examples of net.firstpartners.spreadsheet.RangeHolder

94
95
96
97
98
99
100
101
102
103
104
    // Convert this into a (POI) Workbook
    HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inputFromExcel));

    // Convert the cell
    RangeHolder ranges = RangeConvertor.convertExcelToCells(wb);

    //Call the overloaded method to actually run the rules
    callRules(ranges,ruleSource,nameOfLogSheet,spreadsheetLogger);

    // update the excel spreadsheet with the result of our rules
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
    // Convert this into a (POI) Workbook
    HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inputFromExcel));

    // Convert the cell
    RangeHolder ranges = RangeConvertor.convertExcelToCells(wb);
    HashMap<String, Object> globals = new HashMap<String, Object>();

    // Create a new Excel Logging object
    SpreadSheetLogger excelLogger = new SpreadSheetLogger();

    // Log the cell contents
    log.debug("============ Excel Cell Contents In =========");
    for (Range r : ranges) {
      log.debug(r);
    }

    // Set Paramaters
    RuleSource ruleSource = new RuleSource();
    ruleSource.setDslFileLocation(DSL_FILE);
    ruleSource.setRulesLocation(RULES_FILES);
    ruleSource.setFacts(ranges.getAllRangesAndCells());
    ruleSource.setGlobals(globals);

    // Load and fire our rules files against the data
    new RuleRunner(new FileRuleLoader()).runStatelessRules(ruleSource,excelLogger);
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
    // Convert this into a (POI) Workbook
    HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inputFromExcel));

    // Convert the cell
    RangeHolder ranges = RangeConvertor.convertExcelToCells(wb);
    HashMap<String, Object> globals = new HashMap<String, Object>();

    // Create a new Excel Logging object
    SpreadSheetLogger excelLogger = new SpreadSheetLogger();

    // Set Paramaters
    RuleSource ruleSource = new RuleSource();
    ruleSource.setRulesLocation(RULES_FILES);
    ruleSource.setFacts(ranges.getAllRangesAndCells());
    ruleSource.setGlobals(globals);


    // Load and fire our rules files against the data
    new RuleRunner(new FileRuleLoader()).runStatelessRules(ruleSource,excelLogger);
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
    // Convert this into a (POI) Workbook
    HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inputFromExcel));

    // Convert the cell
    RangeHolder ranges = RangeConvertor.convertExcelToCells(wb);
    HashMap<String, Object> globals = new HashMap<String, Object>();

    // Create a new Excel Logging object
    SpreadSheetLogger excelLogger = new SpreadSheetLogger();

    // Log the cell contents
    log.debug("============ Excel Cell Contents In =========");
    for (Range r : ranges) {
      log.debug(r);
    }

    //Setup our parameters
    RuleSource ruleSource = new RuleSource();
    ruleSource.setRulesLocation(RULES_FILES);
    ruleSource.setFacts(ranges.getAllRangesAndCells());
    ruleSource.setGlobals(globals);

    // Load and fire our rules files against the data
    new RuleRunner(new FileRuleLoader()).runStatelessRules(ruleSource,excelLogger);
View Full Code Here
TOP

Related Classes of net.firstpartners.spreadsheet.RangeHolder

  • net.firstpartners.drools.RuleRunnerExcelTest
  • net.firstpartners.drools.SpreadSheetRuleRunner
  • net.firstpartners.sample.DslRuleflow.DslChocolateTradingExample
  • net.firstpartners.sample.DslRuleflow.NoRuleflowExample
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.