fix(EMS-1693): Application submission - XLSX - dynamic section title row indexes

[ttbarnes]

This PR updates the config/generation for the XLSX file we send to the underwriting team. This fixes an issue where certain section titles in the XLSX file would be styled incorrectly. This was because we were not accounting for different application states, depending on the submitted answers - we now get the XLSX section title row indexes dynamically depending on the submitted answers:

1. If the policy type is multiple - the "Policy and exports” section has 1 additional row.
2. If "using a broker" is true - the “About your business“ section has 3 additional rows.

If any one of these conditions is true, all the proceeding row indexes change because there are new rows.

Changes

• Update XLSX_CONFIG API constants to:
  • Extract into its own directory.
  • Accept application data.
  • Check certain application conditions (mentioned above), and depending on the answers, change the row indexes.

Other improvements

• Update "submit application" E2E test to explicitly mention that it's testing a single policy type.
• Add a new "submit application" E2E test to explicitly test a multiple policy type.
• Update completeAndSubmitBrokerForm cypress command to accept a usingBroker flag/param and then complete/submit the form appropriately.
• Update completeSignInAndSubmitAnApplication to accept a policyType flag/param and then complete/submit the "prepare application" sections appropriately.
• Extract/move ANSWERS API constants and policyType helper function.
• Update XLSX column height definitions so we have a new constant: LARGE_ADDITIONAL_COLUMN_HEIGHT.

[sonarqubecloud]

Kudos, SonarCloud Quality Gate passed!   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

No Coverage information
16.6% Duplication