ExcelService.asmx in Infopath form using SetCellA1 method to submit data to Original Workbook

Question

I have an Infopath form, that uses ExcelService.asmx , SetCellA1 method to submit Infopath form data to Excel. I noticed this method submits data to a temporary workbook and it doesnt update the original workbook residing in the Sharepoint Document Library. I found some notes on this behaviour saying that update to temporary work gets lost when the session times out. One solution I found is to use GetWorkBook and then Save the Workbook(Using Code). Is there any other way of saving workbook without code ?

I am not allowed to write code using VSTA in Infopath to save this workbook changes. Is there any other way I can apply those changes in Original workbook without writting code ? By using other webservice or any other method ? Any help will be appreciated.

---

Dhaval Raval

Answer 1

Hi Dhaval - I'm trying to find an answer to the same problem. Did you ever find an answer to your question?

Answer 2

Using the ExcelService.asmx the code opens an instance of the form and all data is lost after the session is ended. You can set and get data but not update the actual workbook.

As you are using InfoPath you can get the data and export it to Excel
http://office.microsoft.com/en-us/infopath-help/export-form-data-to-excel-HA010074222.aspx

Or submit the data to a SQL database and use excel services to display the data.