We have got a requirement to analyse the forms library data in Excel. We have web browser form with repeating table rows, and how we can export all forms repeating table data in a form library to excel in Infopath form 2013.

Kindly provide your insights on the requirement.

Thanks in advance.

  • To clarify, would you require to export the data on the InfoPath form to an Excel file when the form is submitted? Also, are you able to use custom C# code on the submit action? – Ahmad Zia Mar 1 '19 at 5:29
  • Hi, the Infopath form has 2 repeating fields of check boxes (issue, acknowledge) along with some other repeating fields (issuing from one end then end user need to acknowledge), we need the report of all forms which have submitted to form library whenever we require the report (status of issued and acknowledgement need to capture on all forms whenever we require). – user399731 Mar 1 '19 at 6:32

Infopath form is effectively an xml file. If you write custom code in C# or Powershell you can just parse the nodes as you need to.

| improve this answer | |
  • kindly provide the code snippet where to start the requirement using programming. Thanks in advance. – user399731 Mar 1 '19 at 11:26
  • Have a look at this should give a good start social.technet.microsoft.com/Forums/en-US/… – Marek Sarad Mar 1 '19 at 13:21
  • In my requirement, the forms are submitted to SharePoint library and the forms are having repeating table rows & columns. I would like to get the all info which available in repeating table in all Infopath forms. – user399731 Mar 2 '19 at 4:32

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.