FillPatternForeColor in version 5?

[billegge]

I have upgraded from version 4 to the current version 5 and the following code snip no longer compiles, what is the correct way to do this in version 5?

I get error
[DCC Error] XLSRWHelp.pas(62): E2010 Incompatible types: 'Cardinal' and 'TXc12IndexColor'

Code: Select all

  // Set background color for Column Headers (works in version 4)
  ASheet.Range.Items[0, FirstRow, R.Fields.Count-1, FirstRow].FillPatternForeColor:= xcPaleSky;

[Costtella]

What unit are you using to achieve using the constant "xcPaleSky"?

[larsa]

Hello

Search the source files for "xcPaleSky".