doctype declaration issues in xml

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

Please Login or Register  to view this content.

========================================================================================

Machine acceptable code

Please Login or Register  to view this content.

========================================================================================

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.