Pasting Parameter Values from Excel into Microsoft Test Manager

Pasting multiple columns into your parameters does not work as you would expect when you use the CTRL + V shortcut

For example let’s take this table in Excel

Amount

Name

Department

$200

Bob

Engineering

$300

Jane

Sales

$400

Paul

IT

 
 

When you try to use the CTRL + V shortcut keys you will most likely get this result


The work around is to Right click and then select paste. But make sure the cursor is not located in any of the fields


And the results are what you would expect, each cell copied is pasted in the same manner

Advertisements
  1. #1 by Dave Diehl on August 3, 2011 - 3:39 pm

    Nice catch. I was banging my head on the desk trying to figure this one out when I found your post. Thanks.

    HOWEVER — one gotcha. If you have a blank Excel column, the paste skips it and shifts the other columns to the right. Ick.

  2. #2 by Brian Megilligan on January 13, 2016 - 2:39 pm

    Thank you for this! Frustrated the microsoft’s documentation isn’t a little clearer on this point. This is functionality that could definitely be improved!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: