1

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?

Update: At the moment I using REST to hit the server and parse objects. Problem is that I've to export 60,000 records and REST doesn't return more than 500 per search.

Environment: SP 2013 EE.

2
  • What exactly do you want to export? The managed properties, the binary documents? How will you choose what properties to include? Aug 31 '15 at 19:34
  • @MatthewMcDermott CT targets multiple lists. So, only managed properties will be exported.
    – vikbehal
    Sep 2 '15 at 5:55
1

Since search results are just JavaScript and HTML you could create a Control Template and Display Template that presents your results, then add your own feature to Export the data.

Look at something like this sample: http://dhtmlx.com/docs/products/dhtmlxGrid/samples/12_initialization_loading/13_pro_load_csv.html

Any JavaScript that can serialize the data will work.

4
  • We are displaying results in tabular format. Is there a way to catch the search result object in SharePoint? Exporting current page isn't the solution since search results spans across multiple pages.
    – vikbehal
    Sep 4 '15 at 6:44
  • You could re-execute the query without paging using REST and dump the whole dataset using the same CSV export code. Sep 4 '15 at 22:13
  • We've more than 60,000 records. REST doesn't return more than 500 records.
    – vikbehal
    Sep 7 '15 at 9:13
  • OK, you didn't mention that. That's a totally different scenario. Sep 8 '15 at 12:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.