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.

Comments (0)