Test Data Manager

  • 1.  Javelin : EditExcelCellValueActivity

    Posted Jan 03, 2018 02:31 PM

    Hello,

     

    I'm looking for documentation on : EditExcelCellValueActivity.

     

    I need to change value on multiple fields at the same time in a excel document and I can't find a way to do it beside doing it in multiple steps.

     

    Thanks,

     

    Francois



  • 2.  Re: Javelin : EditExcelCellValueActivity
    Best Answer

    Posted Jan 04, 2018 03:17 PM

    Hi Francois, 

     

    We do not have documentation on this yet, but I have reached out to the doc team to see if some can be created. This may take some time.

     

    Maybe some of my colleagues in the field have some suggestions for this implementation. Shweta_Karan, dovma02, MarkBraemer, Kenneth_Avery, RoyGur



  • 3.  Re: Javelin : EditExcelCellValueActivity

    Posted Jan 05, 2018 07:59 AM

    Hi Taylor,

     

    In EditExcelCellValueActivity there is a field called CallAddress and here is the description : Provide cell path like A1, B1 etc.

     

    How do I provide multiple NewValue?

     

    If I could get an example, it could work.

     

    Thanks,

     

    Francois



  • 4.  Re: Javelin : EditExcelCellValueActivity

    Posted Jan 29, 2018 11:11 PM

    Hello Taylor,

     

    Any new on this?

     

    Thanks

     

    Francois



  • 5.  Re: Javelin : EditExcelCellValueActivity

    Posted Jan 30, 2018 08:51 AM

    Hi Francois, 

     

    I do not have any updates for this. 

     

    Anil_Kumar_Appukuttan or johbe07 , do you have any suggestions? 



  • 6.  Re: Javelin : EditExcelCellValueActivity

    Broadcom Employee
    Posted Jan 30, 2018 09:43 AM

    I believe the EditExcelCellValueActivity allows you to edit only a single cell at at time and not multiple cells. You will need to create a loop to cover the number of cells you want to update.