I have bene trying to generate a customized xml code with excel.
I want to have output in exact format our machine responds to. Excel generates xml but there is a problem with the top 4 lines. So I have to manually copy those lines. The xml genearted by excel is as follows
========================================================================================
Excel generated xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<SIS_EventImport_1_0 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<EventSchedule sService="401" tStart="2008.10.24-0:00:00" tEnd="2008.11.01-00:00:00">
<Event uId="1" tBoxStart="2008.11.03-23:30:00" dBoxDur="0:30:0" sTitle="Telebrands">
<ShortDescriptor sLang="eng" sName="Telebrands">Family Entertainment</ShortDescriptor>
<ExtendedDescriptor sLang="eng">Not Available</ExtendedDescriptor>
</Event>
</EventSchedule>
</SIS_EventImport_1_0>
========================================================================================
Machine acceptable code
<?xml version="1.0" encoding="ISO-8859-15"?>
<!DOCTYPE SIS_EventImport_1_0 SYSTEM "SIS_EventImport_1_0.dtd">
<SIS_EventImport_1_0>
<?comvenient.parser CharCoding="ISO8859_15" TimeZone="LOCAL"?>
<EventSchedule sService="401" tStart="2008.10.24-0:00:00" tEnd="2008.11.01-00:00:00">
<Event uId="1" tBoxStart="2008.10.25-00:00:00" dBoxDur="0:30:0" sTitle="Teleshopping">
<ShortDescriptor sLang="eng" sName="Teleshopping">Family Entertainment</ShortDescriptor>
<ExtendedDescriptor sLang="eng">Not Available</ExtendedDescriptor>
</Event>
</EventSchedule>
</SIS_EventImport_1_0>
========================================================================================
see the top four lines are different.
Is there a way to customize namespace and add doctype declaration at the top via excel in the format our machine accepts it.
Please help.
Bookmarks