Using Excel as a source for manual Tests in VSTT

We get asked for this a lot and we are looking to address it in the future, for now Michael has a workaround that I have copied below.


1) In Excel:

– Create new file in excel
– File->Properties
– Go to the Custom page
– In the Name edit box type:
– In the Value edit type:
  Manual Test
– Click Add
– In the Name edit box type:
– In the Value edit type some unique guid (you can use guidgen.exe tool that comes with VS), like:
– Click Add
– Click OK
– File->Save as…
– Save as MHT file

2) In VS

– Right click test project node in solution explorer
– Select Add existing item from context menu
– Browse to your created .MHT file and double click on it

3) Alternatively, you can save your excel file as .MHT, open it in notepad and add the following lines:
<!–[if gte mso 9]><xml>
  <o:TestType dt:dt=3D”string”>Manual Test</o:TestType>
  <o:TestID dt:dt=3D”string”>D1253494-3D11-4c92-A04E-1A03355D36CC</o:TestID>

 The “Save As” type you would see in “Save As” dialog in Excel is “Single File Web Page (*.mht, *.mhtml)”. Sometimes Windows Explorer hides some files, you can configure that by using Tools->Folder Options->View. If you use command line prompt and do “dir” you would see all files.

It seems that “Save As” *.mht is broken in Office 2007 in the sense that it does not save custom properties; if you use Office 2007 you would probably have to manually add these properties. But if you are using Office 2003 everything should be fine.

Comments (0)