Export Code Coverage metrics from SonarQube to Excel

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
    SonarQube

  • what are you trying to achieve
    Export Sonarqube code coverage metrics to Excel

  • what have you tried so far to achieve this

  1. Open an excel sheet and go to Data -->select From Web from Get External Data section.
  2. paste URL in Address section and click on GO button, here you can see your sonar report on the wizard.
  3. click on Import then you will get a wizard to set properties , set properties as you wish to set and hit OK .

Hi,

Welcome to the community!

I don’t know how it works, but we haven’t done anything to facilitate this kind of import into Excel. If you want reports, you’re going to need to build them manually. In the SonarQube page footer you’ll find a link to the Web API, which will allow you to pull data from your instance. It will be JSON formatted & it will be up to you to morph that into a form acceptable to Excel. You’re interested in the api/measures/component or api/measures/component_tree service.

 
Good luck,
Ann