How to format field from XLS file (1 Viewer)

desmond

Registered User.
Local time
Today, 23:31
Joined
Dec 8, 2009
Messages
28
I have a process that writes an XML file, and when I open this file in Excel, it opens as expected. However, I cannot get the font to format. Can anyone help?

This works:

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<ss:Workbook xmlns:ss="urn:schemas-microsoft-com: office:spreadsheet">
xmlns: 0="urn:schemas-microsoft-com: office: office"
xmlns:x="urn:schemas-microsoft-com: office:excel"
xmlns:ss="urn:schemas-microsoft-com: office:spreadsheet"
<ss:Styles>
<ss:Style ss:ID="1">
<ss:Font ss:Size="8" ss:Bold="1"/>
<ss:Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
<ss:Interior ss:Color="#C0C0C0" ss:pattern="Solid"/>
</ss:Style>
</ss:Styles>
<ss:Worksheet ss:Name="SheetName">
<ss:Table>
<ss:Column ss:Width="74"/>
<ss:Column ss:Width="193"/>
<ss:Column ss:Width="144"/>
<ss:Row>
<ss:Cell ss:StyleID="1"><ss: Data ss:Type="String">Rec_No</ss: Data></ss:Cell>
<ss:Cell ss:StyleID="1"><ss: Data ss:Type="String">Field_1</ss: Data></ss:Cell>
<ss:Cell ss:StyleID="1"><ss: Data ss:Type="String">Field_2</ss: Data></ss:Cell>
</ss:Row>
</ss:Table>
</ss:Worksheet>
</ss:Workbook>


This doesn't work:

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<ss:Workbook xmlns:ss="urn:schemas-microsoft-com: office:spreadsheet">
xmlns: 0="urn:schemas-microsoft-com: office: office"
xmlns:x="urn:schemas-microsoft-com: office:excel"
xmlns:ss="urn:schemas-microsoft-com: office:spreadsheet"
<ss:Styles>
<ss:Style ss:ID="1">
<ss:Font ss:FontName="Courier New" x:Family="Modern" ss:Size="8" ss:Bold="1"/>
<ss:Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
<ss:Interior ss:Color="#C0C0C0" ss:pattern="Solid"/>
</ss:Style>
</ss:Styles>
<ss:Worksheet ss:Name="SheetName">
<ss:Table>
<ss:Column ss:Width="74"/>
<ss:Column ss:Width="193"/>
<ss:Column ss:Width="144"/>
<ss:Row>
<ss:Cell ss:StyleID="1"><ss: Data ss:Type="String">Rec_No</ss: Data></ss:Cell>
<ss:Cell ss:StyleID="1"><ss: Data ss:Type="String">Field_1</ss: Data></ss:Cell>
<ss:Cell ss:StyleID="1"><ss: Data ss:Type="String">Field_2</ss: Data></ss:Cell>
</ss:Row>
</ss:Table>
</ss:Worksheet>
</ss:Workbook>
 

Users who are viewing this thread

Top Bottom