+ Reply to Thread
Results 1 to 3 of 3

Create XML file from Excel

  1. #1
    Registered User
    Join Date
    06-24-2015
    Location
    Wisconsin
    MS-Off Ver
    Excel 2013
    Posts
    49

    Exclamation Create XML file from Excel

    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.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Create XML file from Excel

    Because you have Excel 2007 or later, perhaps this link may help.

    Export XML data
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    06-24-2015
    Location
    Wisconsin
    MS-Off Ver
    Excel 2013
    Posts
    49

    Re: Create XML file from Excel

    I did try this but I"m getting the following message:

    Cannot save or export XML Data. The XML maps in this workbook are not exportable.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 12-09-2014, 07:17 AM
  2. Create folder, excel file, pdf file, clear details macro
    By cemartinho in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2013, 08:52 AM
  3. Replies: 3
    Last Post: 09-30-2011, 04:35 AM
  4. Replies: 1
    Last Post: 07-14-2007, 07:25 AM
  5. Replies: 2
    Last Post: 09-18-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1