Export list of Sitecore items as Excel (or other formats)

excel sitecore sitecore6
Stephan picture Stephan · Jul 7, 2011 · Viewed 8.4k times · Source

I noticed that sitecore has the option of exporting users in an Excel format.

screenshot of the user managers

I need to have similar functionality for exporting 'participations', (a users can enlist to take part in an 'event', and if their entry is approved via a sitecore workflow, a 'participation' item is created in the content tree)

Since mostly everything in Sitecore is in essence based on items, and I want to export items to Excel, my question is - what are some of the best ways of doing this?

Questions:

  1. Is there a way to re-use this functionality for regular items?
  2. Would it be a good idea to create a custom admin page (any tips on doing this?) which has some custom code that reads the items from the database using the API?
  3. are there sitecore plugins/shared source projects that can help me achieve this?

Or does anyone have a better idea? - would it be better to just store the participations in SQL? I'm mostly doing it this way because I want to make use of the 'free' functionality offers, for example workflow, but if that leads to me using anti-patterns please shoot me ;)

Answer

Sasha picture Sasha · Jul 24, 2015

Link is different now: https://marketplace.sitecore.net/en/Modules/Advanced_System_Reporter.aspx

P.S. Couldn't leave a comment to original answer as I don't have enough reputation. Oh well :)

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More