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
