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?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
I created a view
First Name