How to create Excel file with the XML code metrics result file

Question

Hello,

I generated a XML code metrics result file with program metrics.exe provided by the Code Metrics Power tools.

How to create a Excel file to read information in the code metrics result file, as in Visual Studio 2010 when we choose to export calculated code metrics in an Excel file ?

Thank you

Answer 1

Hi ShadoFil,

 

Thanks for your post.

 

As this issue relate to Code Metrics in VS 2010, I moved this post to VS Code Analysis and Code Metrics forum for the better response.   

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

I'm afraid that we have to convert the xml or export the data form xml to a Excel file manually, there's no build in option support this function.

You can use ADO.NET way like this: http://support.microsoft.com/kb/307029

Or you can create the Excel file after you analysis a template like this article said: http://www.ksaelen.be/wordpress/2009/08/using-c-xml-xslt-to-create-excel-spreadsheet/

---

Mike Zhang[MSFT]
MSDN Community Support | Feedback to us

Answer 3

Ok, Thank you.

Answer 4

You're welcome.

---

Mike Zhang[MSFT]
MSDN Community Support | Feedback to us