trouble in spreadsheetML

hi all..I have a problem in making a border in the excel worksheet using spreadsheetML. I have followed the Ms Office 2003 references schema, but the code still doesn't work. Can somebody help? or maybe somebody can give me some examples how to make a border in excel using spreadsheetML. thx

This is my code:
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">

<x:ExcelWorkbook >
<x:WindowHeight>9120</x:WindowHeight>
<x:WindowWidth>10005</x:WindowWidth>
<x:WindowTopX>120</x:WindowTopX>
<x:WindowTopY>135</x:WindowTopY>
</x:ExcelWorkbook>
<Worksheet ss:Name="Sheet1">
<ss:Table>
<ss:Row>
<ss:Cell><ss:Border ss:Position="Top"/>
<ss:Data ss:Type="Number">1</ss:Data>
</ss:Cell>
</ss:Row>
<ss:Row>
<ss:Cell ss:Index="2">
<ss:Data ss:Type="Number">3</ss:Data>
</ss:Cell>
</ss:Row>
<ss:Row ss:Index="5">
<ss:Cell ss:Index="4" ss:Formula="=R1C1+R2C2">
<ss:Data ss:Type="Number">4</ss:Data>
</ss:Cell>
</ss:Row>
</ss:Table>
</Worksheet>

</Workbook>
[1638 byte] By [firebolt] at [2007-11-19 10:59:20]
# 1 Re: trouble in spreadsheetML
Why don't you just ask Excel to give you an example ? , by making an example of what you want, and saving it as XML from Excel.
khp at 2007-11-10 3:27:23 >
# 2 Re: trouble in spreadsheetML
thx khp...it very helpful
firebolt at 2007-11-10 3:28:23 >