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?
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.
