Re: Excel Color Palette

[Courage]

Here is my one-liner to get an idea:

# ЭКСЕЛ -- ГАД И
+ ОКРУГЛЯЕТ &#10
+62;ВЕТ!!!!!!!!!!!!!!!!
perl -MOLE -we "e->Selection->{Interior}->{Color}=245*256*256+255*256+
+255;print e->Selection->{Interior}->{Color}"

Unreadable comment is my untranslatable from Russian comments on how excel rounds color numbers.

Helper OLE.pm module is trivial:

#simple helper for oneliner to get active word, excel
#package OLE;

use Win32::OLE qw(CP_UTF8);
Win32::OLE->Option(CP=>CP_UTF8);


sub e {
  return Win32::OLE->GetActiveObject('Excel.Application');
}
sub w {
  return Win32::OLE->GetActiveObject('Word.Application');
}
sub ao {
  return Win32::OLE->GetActiveObject(shift);
}

1;

[jmcnamara]

That sets the cell colour.

However, the OP wishes to change the palette colour, i.e. the definition of the colour associated with a workbook colour index.

--
John.

[bretteux]

John and Courage, Thanks for the replies. Yes, correct John I was hoping to change the definition of the colour palette itself. Your code example does seem to prove that it it will probably never work. Oh well, monochrome it is then. :-( Cheers! Brett