unknown_routine
asked on
Infopath Export to Excel does not work
Infopath Export to Excel does not work.
I have a infopath form with 2 tesxnbox on it. They data is ABC and FGT.
When I use export to Excel I see an excel file opens and data are:
ns1:field1 ns1:field2 ns1:field3 ns1:field4 ns1:field5 ns1:field6 ns1:field7 ..
Am I missing something?
I have a infopath form with 2 tesxnbox on it. They data is ABC and FGT.
When I use export to Excel I see an excel file opens and data are:
ns1:field1 ns1:field2 ns1:field3 ns1:field4 ns1:field5 ns1:field6 ns1:field7 ..
Am I missing something?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Above "Almost" works.
I created a simple view :
First Name Last Name
Joe Smith
In Excel it shows as :
Nam (my:myFields/my:Nam) LNam (my:myFields/my:LNam)
Joe Nash
Do you know how to get rid of addtional entires: my:myFields/my:Nam ??
I created a simple view :
First Name Last Name
Joe Smith
In Excel it shows as :
Nam (my:myFields/my:Nam) LNam (my:myFields/my:LNam)
Joe Nash
Do you know how to get rid of addtional entires: my:myFields/my:Nam ??
Is there no option to just show the simple header names in the export wizard? Hang on and I'll try to connect to my computer that has infopath and see if I can find it.
Ah. It's pulling the names from the XML so you really can't change that. The headers will look like that unless you change them in Excel after exporting.
(You could probably write a complex macro to do this for you, but I'm guessing it's not worth it).
(You could probably write a complex macro to do this for you, but I'm guessing it's not worth it).
ASKER
Ok Thanks.
ASKER
Curious to know where did you see the XML.
On the right side in Excel it opened up the XML dataviewer thing.
ASKER
I created a view
First Name