Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 <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. -------------------------------------------------------------------------------- Khan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel generated xml doctype issues | Excel Discussion (Misc queries) | |||
Can emails be automatically generated from Excel? | Excel Discussion (Misc queries) | |||
excel generated polynomial equation is wrong | Excel Discussion (Misc queries) | |||
excel.exe has generated errors | Excel Discussion (Misc queries) | |||
Excel.exe has generated errors | New Users to Excel |