Try Now
More in this section

Forums / Developing with Sitefinity / V7.x customize export to excel option of form responses

V7.x customize export to excel option of form responses

2 posts, 0 answered
  1. Jack
    Jack avatar
    1 posts
    08 Jul 2013
    07 Nov 2014
    Link to this post

    Hi, guys 

    I have some questions on form responses export

    1. Is it a way to set only the fields in the form be exported to excel?Normally, there are some extra fields in the exported excel, such as "IpAddress","StartedOn", etc
    2. How to set the fields name of the excel header row. it's the label's text of the field in your demo project, but it's the field name for developers in my project, such as FormTextBox_C001. What should I change in my project.
    3. How can I implement the export function by myself, instead of the build-in export function?
  2. Ivan D. Dimitrov
    Ivan D. Dimitrov avatar
    310 posts
    26 Mar 2015
    11 Nov 2014
    Link to this post
    Hello Jack,

    There is no way to remove columns from the generated excel file - it exports all columns from the column table. The field names displayed in the excel file are the form field's name for developers. This is the value that is persisted in the DB as well. In order to have this behavior altered, select the name for developers of your Form control (from the designer) and alter the FormTextBox_C001 entry to something you will later recognize.

    Adding custom export is possible. I can recommend you use the approach described in this blog post. However instead of getting the form subscribers you will need to trigger an export. The way to get all form entries for a form is described in our documentation. Regarding the export itself - there are abundant resources on the web on how to export a collection to the format you require.

    Ivan D. Dimitrov
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
2 posts, 0 answered