Newbie Questions

Re: export to excel in infopath forms service

cali_kid — Mon, 26 Jan 2009 01:14:03 GMT

RPC call to your view in the SP list.

http://www.sharepointblogs.com/madamo/archive/2007/12/12/programmatically-create-link-to-open-sharepoint-list-in-excel-like-export-to-excel-spreasheet-list-action.aspx

http://sitecollectionurl/subweb/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&
List=ListName&View=ViewName

Re: export to excel in infopath forms service

phpasp — Sat, 24 Jan 2009 07:15:24 GMT

cali_kid yes

Re: export to excel in infopath forms service

cali_kid — Fri, 23 Jan 2009 17:26:30 GMT

If you are using Form services, are you storing your forms and promoting the columns from your form to a SharePoint Form Library?

Re: export to excel in infopath forms service

Janice Thorne — Fri, 23 Jan 2009 16:22:22 GMT

What you are probably looking for is to aggregate data from multiple forms filled out by multiple users into one Excel Spreadsheet. This can be done, but with multiple steps. You can create a SQL database to hold your information (submit to SQL using a web service), then use Excel to query the data from the SQL server (In Excel 2007, click the Data Tab --> click From Other Sources button --> select From SQL server). In this way, you can make the data easy to manipulate, since Excel is a tool that most users are familiar with. The bonus is this can be done without code, but you will have to have someone who knows how to do the queries set up the Excel spreadsheets.

export to excel in infopath forms service

phpasp — Wed, 21 Jan 2009 08:21:15 GMT

hi everyone;

I have infopath form with data in it. and i want to export datas to excel but i use infopath forms service. in a local form it it very easy (File->Export to->Excel)

but.

How can i do this with infopath forms service???

thank you