Export to Excel Please Help!

C

crashoverride

When I attempt to use the Export to Excel wizard to export data from a
repeating table, I find that the option "Form fields only (no tables or
lists)" is the only one available (the other option which allows me to export
my repeating table data is grayed out). I cannot figure out why the other
option is not available and I really need to be able to export data from the
repeating table. Please help if you know why this might be happening!
 
C

crashoverride

Yes the table is present in the view. It is from a secondary data source
though.
 
P

Patrick Halstead [InfoPath MVP]

Sure there is:

You can write code to automate Excel,
Or, import the XML from within Excel,
Or, make the secondary data part of your main DOM!

Excel has some good XML support in 2003. You can specify a binding and load
the xml saved by InfoPath into Excel separately (from Excel). There are some
limitations - for example, Excel won't deal with rich text nodes nor will it
grok xsd:any, but outside of that, you should be fine importing from Excel

The InfoPath export to Excel option is rather limited. I was the dev lead on
the feature and I still understand it pretty well. We had great plans for it
but Excel ended up limiting some functionality that made it hard to export
everything. The transformation is also limited to single tables or all leaf
nodes, but I think you already figure that out.

My suggestion would be to create the "map" in Excel and then import the
InfoPath-generated XML. If this is too clunky, try changing the secondary
data to include in your main DOM (or import it into a separate InfoPath
solution that uses it as a main DOM). Finally, there is always the
do-it-yourself coding option.

Hope this helps,
Patrick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export BPMN Visio Chart to Excel 0
Remove Save Export Steps Pop-up 1
Outlook 2021 export question 0
How to make repeating drop-down lists? 2
VBA concatenate ranges into a new document 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
S.Y.M. Wong-A-Ton .... PLEASE HELP, I Need your INFOPATH 2013 COOKBOOK 2 1
How to Submit rows of a repeating table to a SharePoint list 1

Top