Excel Formula Generator in Ruby
In this guide you will learn how to use the excel formula generator that can repeat an excel formula given an array.
Guide Tasks
  • Read Tutorial
  • Complete the Exercise

Summary

Build out an excel formula generator.

Exercise Description

"Generate a formula that can repeat an excel formula given an array."

Example Data

'names = [
      'kristine',
      'tiffany',
      'jon'
    ] '
-> formulas = <<~EOL
      =SOMEFORMULA("FORMULA-PARAM", "user", "kristine")

      =SOMEFORMULA("FORMULA-PARAM", "user", "tiffany")

      =SOMEFORMULA("FORMULA-PARAM", "user", "jon")
    EOL

    expect(formula_generator(names)).to eq(formulas)

Real World Usage

This exercise will help you populate data into an excel spread sheet.

Test Cases

Code File