Add MS-Excel Plugin - as data source and custom assertions

[GoogleCodeExporter]

I use Apache POI to do MS Excel integration. 

This work is probably not in Spock Core, but more likely a plugin. 

I'd like easier integration with Excel. In data driven tests, maybe a 
convenient way to reference Excel worksheets and rows. And then some way to 
make assertions against the rows or use a row as the expected value in an 
assertion. 

Just thinking ahead for possible plugin ideas at the next Hackergarten. 

Original issue reported on code.google.com by HamletDRC on 22 Jul 2010 at 6:31

[GoogleCodeExporter]

The main work here is to create a Groovy API/DSL for accessing Excel 
spreadsheets. Once we have that, we are more or less done. I've once tried 
Scriptom, but couldn't get it to work.

Original comment by pnied...@gmail.com on 22 Jul 2010 at 11:21

[GoogleCodeExporter]

A groovy API around Apache POI is the best best. It is rather straightforward. 

Original comment by HamletDRC on 22 Jul 2010 at 11:57

[GoogleCodeExporter]

gsheets (which is based on POI) might be the solution. Currently it can only 
create spread sheets though, not read them.

Original comment by pnied...@gmail.com on 26 Feb 2012 at 2:12

[GoogleCodeExporter]

There is a fork of gsheets that supports data extraction from spreadsheets and 
a spock spec showing how to use it. See https://github.com/kktec/gsheets

Original comment by kkt...@gmail.com on 7 Jan 2014 at 2:38