cancel
Showing results for 
Search instead for 
Did you mean: 

Convert the Test log .mht file in to Excel

SOLVED
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!!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Hero

Re: Convert the Test log .mht file in to Excel

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
[Community Expert Group]
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
Extensions available

View solution in original post

2 REPLIES 2
Community Hero

Re: Convert the Test log .mht file in to Excel

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
[Community Expert Group]
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
Extensions available

View solution in original post

Community Hero

Re: Convert the Test log .mht file in to Excel

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.

New Here?
Join us and watch the welcome video:
Watch the new Interview