General

Re: Insert data to Microsoft Excel from Infopath form

RaYvA — Fri, 14 Mar 2014 15:45:45 GMT

You will need to have your InfoPath form submit to a list(maybe the same document library but I wouldn't suggest that), each time you submit a form to that list it will be inserted row by row, that is then the list that you can use in excel using the data connection which will get all the new rows from the list for analysis

Re: Insert data to Microsoft Excel from Infopath form

Benny — Fri, 14 Mar 2014 08:25:40 GMT

Thank you for your answer. If I make the data connection, is it able to insert data row by row? I have tried to insert excel file as web part but I have problem when I want to edit it back because I only can save Infopath form, but not the Excel file in the same document library with Infopath form.

Re: Insert data to Microsoft Excel from Infopath form

RaYvA — Fri, 14 Mar 2014 07:40:13 GMT

Why wouldn't you submit the data from the infopath form into a SharePoint list, then you can export the SharePoint list as a data connection to Excel. This will allow your to use excel to report on the data in the list. You can also have the excel file in the Excel Web App Web Part and have it perform async refresh.

Insert data to Microsoft Excel from Infopath form

Benny — Thu, 13 Mar 2014 09:28:35 GMT

Hi. I have a problem to insert data from Infopath form into Excel. I had try to use web part, which is, I insert Infopath form and Excel as webpart in one page and make data connections between them. By using this way the data has inserted into Excel web part, however, I have problem when I want to edit it back. I only can save the Infopath form, but not the Excel file. It is difficult for the user to edit the data back. Thus, my question is, how to insert data into Excel using Infopath form, according to row by row? and also, is there any other ways for me to insert data into Excel using Infopath form? Maybe using any programming language but I need step by step to do it. I have to insert it into Excel because my client want the report of the data will be print out in Excel table view. Thank you for your feedback and I really appreciate it.