Update an Excel spreadsheet when submitting an InfoPath form to SharePoint 2013
In this InfoPath video you'll see how you can write data to an Excel workbook that is stored in a SharePoint document library while submitting an InfoPath form to a SharePoint form library.
In recipe 112 of InfoPath 2013 Cookbook 2, you'll learn how to update an Excel file that is stored in a SharePoint 2013 document library with data from an InfoPath form that is being submitted to a SharePoint form library.
Get more solutions from InfoPath 2013 Cookbook 2 which is available on Amazon.com
Watch next video: Submit SharePoint list item to Excel workbook via InfoPath 2013
InfoPath demo video transcript:
Here I'm in SharePoint 2013 where I've got this Excel workbook, which as you can see is currently empty. The idea is that I would like to submit an InfoPath form to a SharePoint form library, and while submitting the InfoPath form, write data from the form to cell A1 on Sheet1, and to cell A1 on Sheet2.
I've already published an InfoPath form template to this SharePoint form library, so I'll add a new form, enter some data, and then submit the InfoPath form back to the SharePoint form library.
Once the form has been submitted, I'll go check on the Excel workbook to see whether the data has been written to it. So here we have Jane in cell A1 on Sheet1, and Doe in cell A1 on Sheet2.
Related InfoPath Demo Videos:
- Create InfoPath 2013 forms through SharePoint Designer workflows
- Auto-fill InfoPath fields with Excel data in SharePoint 2013
- Bulk export selected InfoPath forms to Word documents
- SharePoint Designer workflow loop through people picker
- Autonumber InfoPath forms submitted to a SharePoint 2013 form library
- Basic SharePoint user profile info using a people picker
- SharePoint Designer 2013 workflow to loop through InfoPath repeating table
- Add validation rules to a people picker in InfoPath 2013
- Cascading multi-select list boxes with validation in InfoPath 2013
- Submit SharePoint list item to Excel workbook via InfoPath 2013
Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.