Send an entire repeating table to Excel

In this InfoPath demo video you will see how you can send data from rows of a repeating table control on an InfoPath form to an Excel workbook that is stored in a SharePoint document library.

In recipe 29, you'll learn how to use formulas in both InfoPath and Excel to send data from an entire repeating table control on an InfoPath form to an Excel workbook for storage.

Get more solutions from InfoPath 2010 Cookbook 5 which is available on Amazon.com
OR
Watch next video: Add the URL of a form as a link to an Excel workbook from within InfoPath

InfoPath demo video transcript:

Here I'm in SharePoint 2010 where I've got this Excel workbook stored in this DocLib document library. This Excel workbook is currently completely empty; it doesn't contain any data. I can refresh the data just to be sure. So as you can see, there is no data on Sheet1. What I would like to do is send data from a repeating table control on an InfoPath form to this Excel workbook for storage.

So I've already published an InfoPath form template to this SharePoint form library. So if I click Add document to add a new form, you'll see that as soon as the form opens it displays a simple repeating table control here.

So I'll just enter a couple of rows of data. And then when I click this Send to Excel button, the data from this repeating table should be sent to the Excel workbook. I'll just save this form just if we need to redo the send.

And then I'll go to the DocLib document library again and then open the Excel workbook and then refresh the data. And as you can see, the data from the repeating table control has been stored here in the Excel workbook.

 

Related InfoPath Demo Videos:

 

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

 
InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services