IÂ need a functionality to export search results to Excel for SharePoint. I’ve researched a lot and found many answers though no blog provides end to end solution. Best I could find is: Catch search object that’s returned and work on it. I’m not sure how to proceed on it. Also, is it possible to make a generic App which when added, will provide a button to export to excel option?
I’ve a CT which targets multiple lists. So, only managed properties will be exported.
Here is a sample of code.. This will allow you to export to csv. You can then convert csv to excel and then format it they way you want. I added the upload to sharepoint list piece as well. Do with this what you want.. BTW, this works with SP2010.. I have not done this with SP2013 yet. check this out also: https://code.msdn.microsoft.com/office/Query-Search-with-the-372139b5
