docx4j - xlsx4j to evaluate excel formulas -


provided xlsx4j satisfies spreadsheetml specs, can following scenario/requirement implemented using library?

  1. xlsx4j can read named ranges
  2. xlsx4j can evaluate formula defined in spreadsheetml specs
  3. xlsx4j can performs following loop: update named range var_a(let's variable in excel),evaluate formula-cells form_cell_a in uses named range var_a, read named range associated form_cell_a.

regards i

xlsx4j doesn't include code evaluating formulas. try apache poi that. if jaxb support important (thus making xlsx4j attractive you), port relevant poi code. (both projects aslv2 licensed)


Comments