Test Data Manager

  • 1.  Javelin: How can we pass Path as variable in 'ReadExcelActivity' ?

    Posted Mar 16, 2017 02:33 PM

    How can we pass FilePath and SheetName as variable in 'ReadExcelActivity' ?

     

    I want to run same javelin code for different input files



  • 2.  Re: Javelin: How can we pass Path as variable in 'ReadExcelActivity' ?

    Posted Mar 16, 2017 04:55 PM

    Hi Prince,

     

    Please refer for Dynamic file Path:

    Dynamic excel sheet in "Read rows from Excel" 

     For SheetName: It is still selecting from drop down.

     

    Thanks,

    Monika



  • 3.  Re: Javelin: How can we pass Path as variable in 'ReadExcelActivity' ?

    Broadcom Employee
    Posted Mar 17, 2017 10:53 AM

    Hi Monika,

     

    Thanks for answering this question, but unfortunately, it is not the correct answer.  This Javelin refers to Test Data Manager/Javelin/Agile Designer Requirements product.

     

    We are currently taking this question under advisement and investigating the answer.

     

    Cheers!
    Les



  • 4.  Re: Javelin: How can we pass Path as variable in 'ReadExcelActivity' ?

    Posted Mar 17, 2017 12:09 PM

    Oops!! My bad. Thanks for correcting me



  • 5.  Re: Javelin: How can we pass Path as variable in 'ReadExcelActivity' ?
    Best Answer

    Broadcom Employee
    Posted Mar 17, 2017 11:15 AM

    Hi Prince,

     

    At this time, it would appear that there is a product defect with respect to "FilePath and SheetName as variable in 'ReadExcelActivity'."

     

    You have two paths: 

     

    1. Open a Support Ticket  regarding this.
    2. Use csv files as a workaround.  There is a flow that uses csv, accessElementsOfDatarow.vwf in the examples.zip file of the ARD Tech Note Tech Tip: Javelin Example Flows.  This flow shows how to read in CSVs and access the elements within it.  If you have issues with this second option, please open a Support Ticket so an SME can be engaged to assist.

     

    Cheers!
    Les