Excel Datasource enhancement.

[alibaba82]

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

[omatzura]

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

[alibaba82]

No I haven't. I will give this a try.

Thanks

[omatzura]

Hi Ali,

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

regards!

/Ole
eviware.com

[alibaba82]

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]

Great! That's how it was intended :-)

regards,

/Ole
eviware.com