Forum Discussion

axasmgaxa's avatar
axasmgaxa
Occasional Contributor
6 years ago

Is it possible to get Data Sink to write output to excel file horizontally and not vertically?

Hi Folks,   I have soap test that is looping through a few iterations, each time, it writes output via a datasink to an excel file. The problem is, I would like the data to be written out to cells...
  • axasmgaxa's avatar
    axasmgaxa
    6 years ago

    Thanks to everyone who has responded. 

    I don't think it is possible via datasink. (it certainly maybe possible through Groovy, but I am not very proficient with that as of yet.)

     

    As a work around, I reshuffled the excel sheet so it will expect the response in vertically.

sonya_m's avatar
sonya_m
SmartBear Alumni (Retired)

Hi axasmgaxa , that is an interesting question!  

 

nmrao, jsheph01, richie , what do you think? Is there any way to implement this? 

richie's avatar
richie
Community Hero
6 years ago

Hi,

 

I went through the Data Sink function a couple of days ago trying to find an option that would translate the writing into the file from vertical to horizontal.

I went through every file type and every option I could see.  Its a looping testcase right, so I even thought about trying a condiitional goto or maybe some other overcomplicated and ridiculous way of doing it (e.g. using a DataSource grid feeding off a Properties step and the DataSink sources the values from the grid) - but I couldn't find an option.

 

Unless one of the other fellas knows how to do this, I think the option likely to solve this is groovy script (so this counts me out).  I was thinking perhaps allow the DataSink step to write out the values as normal and then use a bit of groovy to translate the values.  I did have a quick search, but I couldn't find any groovy methods that would do this.

 

Sorry I couldn't be more help,

 

rich