Link to home
Start Free TrialLog in
Avatar of unknown_routine
unknown_routineFlag for United States of America

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?

ASKER CERTIFIED SOLUTION
Avatar of TommySzalapski
TommySzalapski
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of unknown_routine

ASKER

Above "Almost" works.

I created a view

First Name  
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   ??




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).
Ok Thanks.
Curious to know where did you see the XML.
On the right side in Excel it opened up the XML dataviewer thing.