I'm having trouble importing an XML file into Excel 2003.
After importing, the data is "stepped", for example, the first "record" or row goes into A1, B2, C3, D4, etc....but I need it to go into a normal row (A1, B1, C1, D1, etc.) Below is a sample of my XML file. (Note that there will be a variable number of Servers, Groups and Users per App):
<?xml version="1.0"?>
<Applications>
<App>
<AppName>AppA</AppName>
<DistinguishedName>Applications/Production/AppA</DistinguishedName>
<AppVersion>1</AppVersion>
<Description>Application A</Description>
<ParentFolderDN>Applications/Production</ParentFolderDN>
<EnableApp>1</EnableApp>
<DefaultEncryption>MFWinEncryptionBasic</DefaultEncryption>
<DefaultInitProg>K:\apps\all.bat 1</DefaultInitProg>
<DefaultWorkDir>K:\apps</DefaultWorkDir>
<DefaultSoundType>MFWinSoundNone</DefaultSoundType>
<DefaultWindowColor>MFWinColor64K</DefaultWindowColor>
<DefaultWindowType>MFWinWindow640X480</DefaultWindowType>
<DefaultWindowWidth>640</DefaultWindowWidth>
<DefaultWindowHeight>480</DefaultWindowHeight>
<DefaultWindowScale>75</DefaultWindowScale>
<DesktopIntegrate>MFWinAppIntegrateNone</DesktopIntegrate>
<MFAttributes>MFWinAppMFAttrNone</MFAttributes>
<PublishingFlags>MFWinAppEnumMaskNone</PublishingFlags>
<PNAttributes>MFWinAppPNAttrNone</PNAttributes>
<PNFolder />
<ReadOnly>0</ReadOnly>
<CPUPriority>MFWinAppCPUPriorityNormal</CPUPriority>
<InstanceLimit>-1</InstanceLimit>
<AllowMultiInstancePerUser>1</AllowMultiInstancePerUser>
<EnableSSLConnections>0</EnableSSLConnections>
<FileTypes>System.__ComObject</FileTypes>
<AppID>MetaFrameCOM.MetaFrameIDClass</AppID>
<BrowserName>AppA</BrowserName>
<PlaceUnderProgramsFolder>0</PlaceUnderProgramsFolder>
<WaitOnPrinterCreation>0</WaitOnPrinterCreation>
<HideFromBrowserEnum>1</HideFromBrowserEnum>
<HideFromPNEnum>1</HideFromPNEnum>
<AddToClientStartMenu>0</AddToClientStartMenu>
<AddShortcutToClientDesktop>0</AddShortcutToClientDesktop>
<IconFileName>1.ico</IconFileName>
<ServerName>ServerD</ServerName>
<ServerName>ServerA</ServerName>
<ServerName>ServerC</ServerName>
<ServerName>ServerE</ServerName>
<GroupName>MFAccountAuthorityADS,DName,MFAccountGlobalGroup,Admins</GroupName>
<GroupName>MFAccountAuthorityADS,DName,MFAccountGlobalGroup,Finance</GroupName>
<GroupName>MFAccountAuthorityADS,DName,MFAccountGlobalGroup,AllApps</GroupName>
<GroupName>MFAccountAuthorityADS,DName,MFAccountGlobalGroup,Users</GroupName>
<UserName>MFAccountAuthorityADS,DName2,MFAccountDomainUser,doe1jb</UserName>
<UserName>MFAccountAuthorityADS,DName2,MFAccountDomainUser,smitma</UserName>
</App>
</Applications>
Bookmarks