Forum Discussion

alibaba82's avatar
alibaba82
Super Contributor
17 years ago

Excel Datasource enhancement.

Hello,
While running a thread strategy load test I use multiple files with varying data. So I will have file0.txt, file1.txt, file2.txt and then using a file datasource I specify something like C:\${threadIndex}.txt so that each thread0 gets file0.txt.

Managing these files can get cumbersome and I would rather use one excel,csv file to manage the data. Would it to enhance Excel Datasource so that we can use ${threadIndex} to specify what column of values to use for what thread.

Thanks

Ali

5 Replies

  • omatzura's avatar
    omatzura
    Super Contributor
    Hi Ali,

    hmm.. property-expansion should already be possible in all fields of the Excel Datasource.. ie you could have one sheet per thread, or a different startcell per thread.. have you tried this already?

    regards!

    /Ole
    eviware.com
  • omatzura's avatar
    omatzura
    Super Contributor
    Hi Ali,

    did you try this out.. was it working ok?

    regards!

    /Ole
    eviware.com
  • alibaba82's avatar
    alibaba82
    Super Contributor
    Yes.. this actually work better than I expected
    I used 1 sheet for each tthread to sheet= Sheet${threadIndex} and then used start column A0. This way i used one excel file to manage all my data.
  • omatzura's avatar
    omatzura
    Super Contributor
    Great! That's how it was intended :-)

    regards,

    /Ole
    eviware.com