That's a great help.

Now I get into the namespace issue.

When I try to output the following (all variables are declared):

<Data ss:Type="$data_type" NAME="$field_name"><xsl:value-of 
select="$field_data"/></Data>

It actaully output:


<Data
ss:Type="$data_type"
NAME="$field_name" 
xmlns="urn:schemas-microsoft-com:office:spreadsheet" 
xmlns:o="urn:schemas-microsoft-com:office:office" 
xmlns:x="urn:schemas-microsoft-com:office:excel" 
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" 
xmlns:html="http://www.w3.org/TR/REC-html40">
</Data> 	

How can I get the variable value into xml output?

And how can I get rid of the annoying lines of "xmlns:"?

Thank you very much.

		


		

Oleg Tkachenko [MVP] wrote:
> qluo wrote:
> 
>> I Think you are right. How can I address the issue then?
>>
>> The beginning of the template.xml is:
>> -------------------------------
>> <?mso-application progid="Excel.Sheet"?>
>> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
>>  xmlns:o="urn:schemas-microsoft-com:office:office"
>>  xmlns:x="urn:schemas-microsoft-com:office:excel"
>>  xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
>>  xmlns:html="http://www.w3.org/TR/REC-html40">
>> ---------------------------------
>>
>> Again, how can I make the following work?
>>
>> ------------------------------
>> <xsl:for-each select="$template_xml/Workbook/child::*">
>>    <xsl:copy-of select="."/>
>> </xsl:for-each>
> 
> 
> <xsl:stylesheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" 
> ...>
> 
> <xsl:for-each select="$template_xml/ss:Workbook/child::*">
> 
> 
>