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:
TestType
- In the Value edit type:
Manual Test
- Click Add
- In the Name edit box type:
TestID
- In the Value edit type some unique guid (you can use guidgen.exe tool that comes with VS), like:
D1253494-3D11-4c92-A04E-1A03355D36CC
- 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:CustomDocumentProperties>
<o:TestType dt:dt=3D"string">Manual Test</o:TestType>
<o:TestID dt:dt=3D"string">D1253494-3D11-4c92-A04E-1A03355D36CC</o:TestID>
</o:CustomDocumentProperties>
</xml><![endif]-->
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.