I need to create an XML file that looks like this:
<?xml version="1.0" encoding="UTF-8"?>
-<students xmlns="<url>" sblCreatedDate="2015-06-15T14:31:54.400" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
-<student active="1" externalSiteId="001" externalCampusId="Sandbox" firstName="Betty" lastName="Richards" socialSecurityNumber="111221203" birthDate="1989-01-27" externalStudentId1="SIS210007">
<demographic disabilityStatus="No" veteranStatus="Blank" admittedDate="2012-01-01" driversLicense="RK0986542" residencyDate="1994-01-01" stateOfLegalResidence="MD" residencyStatus="InState" citizenshipStatus="USCitizen" externalHousingStatusId="OffCampus" maritalStatus="Single" gender="Female" race="White" ethnicity="Other"/>
<highschool graduationDate="2012-05-30" stateProvince="MD" classRank="25" diplomaType="HighSchoolDiploma" highSchoolGPA="3.20" acgEligibility="HighSchoolProgram01" highSchool="Hoover High School"/>
<address stateProvince="MD" country="US" postalCode="21701" city="Frederick" line1="12 West Church Street" type="Original"/>
<phone type="Home" number="3023429873"/>
<email type="Home" email="[email protected]"/>
</student>
I was hoping to create a spreadsheet in Excel and then capture all the data and then export to XML. Is this possible within Excel? Otherwise I will have to manually enter the data into the fields in the XML file one by one.
Bookmarks