Newbie Questions

Re: Export to excel question??

Clay Fox — Wed, 26 Mar 2008 15:46:08 GMT

Your images do not show up. It may be better to attach them in the options tab.

Export to Excel does not have a lot of practical uses. Since it requires a manual export by the user, typically you also need to switch to a view that shows the data you need, and there is no control over the data layout or format in Excel.

You can show some data in a repeating table within InfoPath which resembles a spreadsheet but if you really want to be able to get the form data into Excel then you need a backend data repository both InfoPath and Excel share.

InfoPath information is saved in it, across all forms, and then a spreadsheet is created which permanently links to the database and displays the information in real-time.

That makes the InfoPath users and the Excel users very happy and they can share the data and play nicely together.

Re: Export to excel question??

sfairley — Wed, 26 Mar 2008 15:17:30 GMT

Yes where it will convert to a spreadsheet view.

Re: Export to excel question??

Clay Fox — Fri, 21 Mar 2008 20:16:34 GMT

Can you give some more details, attach a screen shot or something?

This is an export to excel within InfoPath, where it will convert the view to a spreadsheet? Or is this some excel view in SharePoint?

What are you hoping to accomplish?

Export to excel question??

sfairley — Fri, 21 Mar 2008 18:55:35 GMT

When I do an export to excel all my fields show this fieldname (my:MFF/my:fieldname)

Any clue???????????????????