ruby on rails - Importing a large amount of data for testing only. -

here background:

i have client wants me test rails app against large number of potential inputs in form page. has excel spreadsheet 200 potential input combinations entered form.

the client want's app able "read" spreadsheet , execute couple hundred form submissions.

my solution import spreadsheet database table, client doesn't want database table in application.

so here question:

is possible/not exceptionally complicated read/crawl spreadsheet or csv file above, or import data test database?

i haven't been able find resources aren't importing spreadsheet.

thanks!

use spreadsheet gem read , parse data excel.

use capybara automate form submission. initial learning curve steep, once hang of it, comes handy automate web interactions.