function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
PandeiswariPandeiswari 

Copy code coverage of All apex class to Excel sheet

Hi,

I have executed "Run all test" to get code coverage of all apex classes. Is there way to get all apex classes code coverage with percentage copy to excel sheet. I am able to see all classes with percentage in Developer console. But not able to copy all those. Please provide some suggestion.
Beer NutthawanBeer Nutthawan
Hi Pandeiswari

Please check this out:  http://blog.adityanaag.com/23/Export+Apex+Code+Coverage+to+Excel

Good luck!! 
shashi lad 4shashi lad 4
Hi 

You can simply run this query in Workbench and copy/paste in Excel.

select id,apexClassorTrigger.Name,numLinescovered, numlinesuncovered from apexcodecoverageAggregate

Thanks
shashi
Navee RahulNavee Rahul
The apexcodecoverageAggregate is not an Sobject  and so it will not be supported or will not execute.

Thanks
D Naveen Rahul.
Amit Chaudhary 8Amit Chaudhary 8
Please try to use below App Exchange product. I hope this will hel you
https://appexchange.salesforce.com/listingDetail?listingId=a0N3000000DXzlpEAD

Please let us know if this will help you

Thanks
Amit Chaudhary
vijayabakarareddy yarrabothulavijayabakarareddy yarrabothula
Add this extension for your crome   it will help you defenetly
------------------------------------------------------------------------------------------
https://www.youtube.com/watch?v=ZSGqjPrcYsM               


https://chrome.google.com/webstore/search/salesforce%20code%20coverage%20monitor?utm_source=chrome-ntp-icon

 
AJAYAJAY
Hi @vijayabakarreddy yarrabothula

Thanks for the  extension,it is working fine, but is there any inbuilt component with the extension so that we can directly export the results to excel?
Amit Chaudhary 8Amit Chaudhary 8
Hi AJAY,

You Can try below appExchange product for same
https://appexchange.salesforce.com/listingDetail?listingId=a0N3000000DXzlpEAD
Amarjeet Puri 19Amarjeet Puri 19
https://developer.salesforce.com/forums/?id=906F0000000BVBuIAO
 
Amarjeet Puri 19Amarjeet Puri 19
Please try to use below App Exchange product. I hope this will hel you

https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000FKAQ2UAP

Please let us know if this will help you

Thanks
Amarjeet
Prince_sfdcPrince_sfdc

Please follow the below steps: 

  1. Download the  (SFDC Dev Console Data Exportor Chrome Extension (https://chrome.google.com/webstore/detail/sdfc-dev-console-data-exp/mfcddagpdnfokfnbnoeephmfoifgdbid)
  2.  Execute this SOQL in dev console with "Use Tooling API" Checked
  3. Press the button on the Chrome extension downloaded above and it will ask you the format (excel/CSV) 
  4. It gets downloaded in the excel/CSV
Please like the answer to promote. 
Prince_sfdcPrince_sfdc
Select id,apexClassorTrigger.Name,numLinescovered, numlinesuncovered from apexcodecoverageAggregate

 
Subitha S 1Subitha S 1
Please try the below AppExchange product which shows the Overall Code Coverage and many more details which can be exported/ downloaded.

https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000GCUo1UAH