Ask a Question

Convert the Test log .mht file in to Excel

SOLVED
Piyush_77
Occasional Contributor

Convert the Test log .mht file in to Excel

Hello,

 

I have test complete results in .mht file and I want to convert it into Excel file. can you suggest me How can I do it best and proper format? Is there any direct conversion tool available or Should I write a script for that? If I have to write a script can you give me some basic idea how can I do it?

 

Thanks in Advance!!

 

2 REPLIES 2
tristaanogre
Esteemed Contributor

The MHT file is a specific kind of file for archving and packaging web pages for easy transport (see https://whatis.techtarget.com/fileformat/MHT-MHTML-document-Microsoft).  So... there's not an easy way to "convert" this to an Excel file.

 

If you prefer your report output to be in an Excel format, this will have to be custom code.  Basically, every where your automation writes to the TestComplete log, you would have to add code to out put to your desired Excel format.  Alternatively, you could export the log to XML and then write custom code to parse the XML into your Excel file after the fact.  But, natively, there's no built in function or tool in TestComplete to write the log out to Excel.


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available

Evidently some versions of Excel will open an .mht file

https://support.office.com/en-us/article/file-formats-that-are-supported-in-excel-0943ff2c-6014-4e8d...

 

Try it and see what happens.


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
cancel
Showing results for 
Search instead for 
Did you mean: