Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default excel generated xml doctype issues

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel generated xml doctype issues Shazif Excel Discussion (Misc queries) 0 November 12th 08 05:02 PM
Can emails be automatically generated from Excel? suek Excel Discussion (Misc queries) 2 October 20th 08 04:48 PM
excel generated polynomial equation is wrong jkeith Excel Discussion (Misc queries) 9 September 27th 06 03:45 AM
excel.exe has generated errors Mrich Excel Discussion (Misc queries) 7 December 31st 04 10:28 PM
Excel.exe has generated errors Mrich New Users to Excel 6 December 31st 04 10:28 PM


All times are GMT +1. The time now is 06:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"