Excel spreadsheets with XML

Question

I create Excel spreadsheets for reports using the XML method, in which you export the correct XML XML format and then export it to Excel.

So far, everything is working as it should, but I have problems with colors.

I created one style, for example:

<Style ss:ID="s64" ss:Parent="s25">
      <Font ss:FontName="Tahoma" x:Family="Swiss" ss:Size="14" ss:Color="#4579B9" ss:Bold="1"/>
      <Interior/>
</Style>

The colors he should use should look like this, but at the top of this image:

alt text http://img535.imageshack.us/img535/431/righty.jpg

However, the color he uses is the one below.

When I create a report, it is generated with the color code: # 4579B9, which I want, but when I open it, it displays the color as the one at the bottom of the image.

If I then save the document, it will automatically change color to # 666699, which is exactly what has the color below (wrong color).

, # 4579B9, .

, , " ", " ".

- ? - ?

Answer 1

, Excel 2007 - , , . Excel 2003, , SpreadsheetXML (XMLSS).

Excel 2003 . , . , .

. №1, , (255, 253, 253).

 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <RelyOnVML/>
  <AllowPNG/>
  <Colors>
   <Color>
    <Index>1</Index>
    <RGB>#FFFDFD</RGB>
   </Color>
  </Colors>
 </OfficeDocumentSettings>