Calculate Formula while Assembling Spreadsheet Documents

Calculate Formula

The Recipe

  • Set up source document template path
  • Set up destination report path
  • Instantiate DocumentAssembler class
  • Set options, DocumentAssemblyOptions.UPDATE_FIELDS_AND_FORMULAS
  • Generate report

Download Template

Get the template from here.

The Code