Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Excel to xml
0 views
Skip to first unread message
Anand
Jun 9, 2009, 9:10:01 AM6/9/09
to
1. I wish to export some data to xml based on some condition (value of some
field). e.g. - filed "Marital Status". If the value is "Married" the
subsequent fields "Name of Spouse", "No. of children" should be exported in
xml. However, if the value is "Unmarried", the rest of the fields should not
be exported at all. How do I control this with some predefined schema?
2. Similarly, there are some lists in the excel file that should be exported
to the xml data file. However, the condition is that if there are no entries
in the list, data should not be exported in the xml for that list. I have
mapped the schema elements to list and there is no data in the list. But,
when I export to xml, it does contain all the fields in the list with no data.
field). e.g. - filed "Marital Status". If the value is "Married" the
subsequent fields "Name of Spouse", "No. of children" should be exported in
xml. However, if the value is "Unmarried", the rest of the fields should not
be exported at all. How do I control this with some predefined schema?
2. Similarly, there are some lists in the excel file that should be exported
to the xml data file. However, the condition is that if there are no entries
in the list, data should not be exported in the xml for that list. I have
mapped the schema elements to list and there is no data in the list. But,
when I export to xml, it does contain all the fields in the list with no data.
Please help.
Regards,
Anand
0 new messages