Browser Forms

Re: Import Excel data in a browser-enabled infopath form

victoria13 — Mon, 09 Mar 2009 12:31:17 GMT

Thanks Clay..

Re: Import Excel data in a browser-enabled infopath form

Clay Fox — Thu, 05 Mar 2009 15:59:15 GMT

I am not sure your exact requirments but here are some thoughts.

Excel can connect to SQL data directly too. I would flag records and then launch a spreadsheet which queries those records.

Otherwise you could dump an XML file as a subset of your data which then could then be consumed by Excel.

It is pretty dificult. I am not sure why they want Excel but I would look at an alternative to using Excel which is easier to work with and streamline into the process.

Re: Import Excel data in a browser-enabled infopath form

victoria13 — Thu, 05 Mar 2009 08:20:33 GMT

I have a repeating table which gets data dynamically from an SQL database/webservice.

On click of button, I need to transfer data from repeating table to an excel sheet. This has to be done on button click (programatically) and not via the export wizard. Is this possible?

Please help!!

Re: Import Excel data in a browser-enabled infopath form

Clay Fox — Fri, 15 Feb 2008 16:44:03 GMT

Ok.

Why don't you send me an email and I can see what I can do.

Re: Import Excel data in a browser-enabled infopath form

txc-- — Fri, 15 Feb 2008 16:34:07 GMT

Its not only to view information, users must be able to change the information.

Is it ok that i add you on msn? I have to fix this solution asap.

Thanks for all your help!

Re: Import Excel data in a browser-enabled infopath form

Clay Fox — Fri, 15 Feb 2008 16:24:02 GMT

Ok just checking.

What I would recommend is put the information in SQL. Then have Excel file access the information from there. Once it is setup they will not be able to tell the difference.

Then yes the InfoPath form can have a data connection to the SQl table too.

Is it just to view in InfoPath or will InfoPath users update the information? You may want to use webservices for increased functionality in InfoPath.

Re: Import Excel data in a browser-enabled infopath form

txc-- — Fri, 15 Feb 2008 15:43:17 GMT

I don't want to creat a new form for every row in Excel. All the information needs to be in one form.

I have to develope something for a company so they get everything structured. There idea is that ther is a button in the InfoPath form with Import Excel. Then all the information in the fields from Excel must going to the InfoPath form.

I had another idea about this. To make a macro in Excel to put all the information directly in the SQL database. Then view it with InfoPath in the right fields. Is this a good way to do it or do you prefer the way you said?

Thanks for your reaction.

Re: Import Excel data in a browser-enabled infopath form

Clay Fox — Fri, 15 Feb 2008 15:31:52 GMT

You want to take data rows from Excel and put them in InfoPath? Or do you want to create an InfoPath form for each row of data in a spreadsheet?

Typically what works best is to use a common data source such as a SQL database that both Excel and InfoPath can then access. Then the Excel users can view and update and InfoPath can view and update.

Yes if you are dealling with multiple rows the only way to handle it in InfoPath is to have a repeating group.

Import Excel data in a browser-enabled infopath form

txc-- — Fri, 15 Feb 2008 15:16:49 GMT

Hi all,

I have a question about importing data from Excel to a browser-enabled infopath form.

Is this possible? If it's possible what would be the best way to get this done?

I'm also working with a repeating table. If ther are more rows then one in the excel sheet he should add more rows in the repeating table too.

I hope you guys can help me with this issue.

Cheers.