You can try implementing a TableTransformer which reads the XLS input and transforms each sheet to CSV.
You can try using Apache POI. > On 12 Mar 2014, at 05:12, farheen khan <[email protected]> wrote: > > Hi mauro, > > Our application is very complex and reading from multiple csv files will not > be user-friendly. Hence, I wanted to read from a single excel sheet which > contains multiple sheets and each sheet contains tables for testcases. > > > Scenario should run as many times as there are number of rows in the table of > excel sheet. > > I'm preferring excel because before I run my testcases , I need to run macro > on excel ,which will fill in the details into excel from db. > > Can this be done using jbehave. > > >> On Tue, Mar 11, 2014 at 5:46 AM, Mauro Talevi <[email protected]> >> wrote: >> http://jbehave.org/reference/stable/parametrised-scenarios.html >> >> >>> On 11/03/2014 01:15, Mauro Talevi wrote: >>> The parametrised scenario does allow to repeat the scenario for each row of >>> the Examples table. The table can be read from an external CSV file. >>> >>> Was this the question? If not, can you rephrase it please? >>> >>>> On 10/03/2014 16:35, farheen khan wrote: >>>> Thanks everyone specially Mauro for the reply.Your inputs helped me, >>>> >>>> Yes, I'm planning to host the results as well as store it in the db. >>>> >>>> Few more questions: >>>> >>>> For every scenario,can i iterate over the scenario as many times as number >>>> of rows in the data table ,which is read from excel sheet,like it >>>> happens with Examples ? If yes, how can i accomplish that. >>>> >>>> Thanks in advance. >>>> >>>> >>>> >>>> >>>> On Mon, Mar 3, 2014 at 2:29 PM, Mauro Talevi <[email protected]> >>>> wrote: >>>>> 1. You can implement your own ViewGenerator to store to DB >>>>> 2. It's possible, but you need to pass it to the ViewGenerator via the >>>>> ViewProperties, then modify the ViewGenerator (or the FTL template if >>>>> writing to file) >>>>> 3. WebRunner can run any kind of story >>>>> 4. WebRunner is not meant as a replacement for a Continuous Integration >>>>> build engine. It's an on demand run tool. >>>>> >>>>> As already noted, it would seem that your requirements would be best met >>>>> by a CI tool. Is this what you're trying to do? >>>>> >>>>> >>>>> On 03/03/2014 06:07, farheen khan wrote: >>>>>> I recently have implemented JBehave with webdriver for automation. I >>>>>> have few queries. >>>>>> >>>>>> 1. can JBehave store the results in DB after the suite is completed? >>>>>> 2. Can we modify the Jbehave report to display the buildnumber? >>>>>> 3. can we run webdriver tests to run from jbehave web runber.Example of >>>>>> etsy.com doesn't actually run the webdriver stories. >>>>>> 4. Can we integrate the results with web-runner. i.e instead of opening >>>>>> target/view.index.html , can we host it on any webserver along with >>>>>> web-runner. >>>>>> >>>>>> -- >>>>>> Thanks and regards >>>>>> Farheen Khan >>>> >>>> >>>> >>>> -- >>>> Thanks and regards >>>> Farheen Khan > > > > -- > Thanks and regards > Farheen Khan > >
