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