Add a new row to an Excel table from within InfoPath
In this InfoPath demo video you will see how you can use an InfoPath form to add a new row or record to an Excel table in a workbook that is stored in a SharePoint document library.
In recipe 37, you'll learn how to create an InfoPath form that can add a new row to a table in an Excel workbook that is stored in a SharePoint document library.
Get more solutions from InfoPath 2010 Cookbook 5 which is available on Amazon.com
Watch next video: Perform exact and wildcard searches in an Excel table from within InfoPath
InfoPath demo video transcript:
Here I'm in SharePoint 2010, where I've got this Excel workbook that contains a table with a list of food items. The idea is that I want to use an InfoPath form to add new items to this Excel table.
I've already published an InfoPath form template to this SharePoint form library, so if I click Add document and enter the name of a new item and then click this button, the item should have been added to the table.
So I'll go back to the Excel workbook and refresh the data. And as you can see, we've got a new item here at the end of the list.
I can repeat the process and add a second item. And then again I'll refresh the data in the workbook. And as you can see here we've got the new item listed at the end of the list of items.
Related InfoPath Demo Videos:
- Submit SharePoint List form values to a new Excel workbook
- Send an entire repeating table to Excel
- Add the URL of a form as a link to an Excel workbook from within InfoPath
- Perform exact and wildcard searches in an Excel table from within InfoPath
- Update an Excel chart on an InfoPath form
- Get data from an Excel workbook attached to an InfoPath form
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.