Hi,
I have a InfoPath form which is published in the SharePoint page and I wanted to export the data of the InfoPath form to an Excel. I used that web part services and now I am able to export the data of the form to Excel.
The problem is the second time when I enter the form, it updates the previous record in the Excel. But I want to add to the next row of the Excel. When I searched through the forums, I found out if we publish as SharePoint list in InfoPath, we can append it. But the property promotions (setting the parameters of the form) can’t be seen in SharePoint list in InfoPath.
Can anybody tell me how to append to an existing Excel sheet every time the form is filled?
What I am trying to understand is why the data from the form needs to be in an Excel sheet? When an infopath form is published to a form library that data from all the promoted fields is available to view, filter, sort, etc same as if it were in an excel spreadsheet. Difference is that multiple people can be creating forms at the same time. Multiple views can be created, applying filters, grouping, etc.
Likewise if the data is entered in a list in SharePoint, multiple users can add data they just can’t edit the same row at the same time.
What function is the excel spreadsheet serving that a list or library within SharePoint could not?
I’m just trying to understand the purpose of the requirement. From my own experience the end users often want to require things to work in the way that they are accustomed to working. When that is the most efficient way to get the job done, then it makes sense to develop solutions that allow end users to work within their comfort zone. However, sometimes what they want isn’t really practical.
Other than the export to Excel option from the ribbon of a library or list, I’m not aware of a way to take data input in infopath forms into an excel sheet. That process gets every form created that is in that view of library. So if you are in the my documents view of a form library when you select export to excel, you’d only get the forms that you created ( and only the data in the fields in the view with a few exceptions).
If I’ve missed the point completely, I do apologize.
-Robin
P
Hey Robin,
Thanks for the reply. My requirement is that, If an infopath form is present in sharepoint website and for eg., if 10 people enter data in that form, I want all the 10 form’s data inside an excel sheet automatically. When we give an export to excel, only one form gets exported right? I want to populate an excel sheet with the data entered each time in the form.
Hope I explained clearly.
Hi Ijaz,
I’m not sure I understand exactly what you’re trying to do. Â InfoPath forms can be saved to a form library (or a document library I believe) and the individual form fields can be viewed in SharePoint as “columns”. Â This data can be exported to Excel (there’s an icon on the ribbon to allow this in SP2013… I’m assuming it’s there in Sharepoint online as well). Â However, the export to Excel does not LINK the Excel spreadsheet to the library, rather it gives a “single point in time” look at the data.
Can you explain what the purpose of the Excel sheet is in your process??
-Robin
