What is wrong with my StyleID assignment?

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
In the spreadsheet xml code below, there is an error when the Rows StyleID is set to "s63" (as shown) but not when it is set to "1". What do I need to do to get the Row to be formatted per Style "s63"?
<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <?<span style="color:#A31515; xml <span style="color:Red; version<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 1.0<span style="color:Black; "<span style="color:Blue; ?>
<span style="color:Blue; <?<span style="color:#A31515; mso-application <span style="color:Red; progid<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Excel.Sheet<span style="color:Black; "<span style="color:Blue; ?>
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Workbook <span style="color:Red; xmlns:ss<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; urn:schemas-microsoft-com:office:spreadsheet<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Styles<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Style <span style="color:Red; ss:ID<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 1<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Font <span style="color:Red; ss:Bold<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 1<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; </<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Style<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Style <span style="color:Red; ss:ID<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; s63<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Alignment <span style="color:Red; ss:Horizontal<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Center<span style="color:Black; " <span style="color:Red; ss:Vertical<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Bottom<span style="color:Black; " <span style="color:Red; ss:WrapText<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 1<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; Borders<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; Font <span style="color:Red; ss:FontName<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Arial<span style="color:Black; " <span style="color:Red; ss:Bold<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 1<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; Interior<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; NumberFormat<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; Protection<span style="color:Blue; />
<span style="color:Blue; </<span style="color:#A31515; Style<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Styles<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Worksheet <span style="color:Red; ss:Name<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; View 48<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Table<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Column <span style="color:Red; ss:Width<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 55<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Column <span style="color:Red; ss:Width<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 155<span style="color:Black; "<span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Row <span style="color:Red; ss:StyleID<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; s63<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Cell<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Data <span style="color:Red; ss:Type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; String<span style="color:Black; "<span style="color:Blue; >Site<span style="color:Blue; </<span style="color:#A31515; Data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Cell<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Cell<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Data <span style="color:Red; ss:Type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; String<span style="color:Black; "<span style="color:Blue; >Site Time<span style="color:Blue; </<span style="color:#A31515; Data<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Cell<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Row<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Table<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; ss<span style="color:Blue; :<span style="color:#A31515; Worksheet<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Workbook<span style="color:Blue; >

[/code]

View the full article
 
Back
Top