V7.x customize export to excel option of form responses

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?

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.

Regards,
Ivan D. Dimitrov
Telerik