【转载】Excel中 ColorIndex 属性值和颜色对照表及设置单元格背景色

无色 = -4142,
   自动 = -4105,
   黑色 = 1,
   褐色 = 53,
   橄榄 = 52,
   深绿 = 51,
   深青 = 49,
   深蓝 = 11,
   靛蓝 = 55,
   灰色80 = 56,
   深红 = 9,
   橙色 = 46,
   深黄 = 12,
   绿色 = 10,
   青色 = 14,
   蓝色 = 5,
   蓝灰 = 47,
   灰色50 = 16,
   红色 = 3,
   浅橙色 = 45,
   酸橙色 = 43,
   海绿 = 50,
   水绿色 = 42,
   浅蓝 = 41,   
   紫罗兰 = 13,
   灰色40 = 48,
   粉红 = 7,
   金色 = 44,
   黄色 = 6,
   鲜绿 = 4,
   青绿 = 8,
   天蓝 = 33,
   梅红 = 54,
   灰色25 = 15,
   玫瑰红 = 38,
   茶色 = 40,
   浅黄 = 36,
   浅绿 = 35,
   浅青绿 = 34,
   淡蓝 = 37,
   淡紫 = 39,
   白色 = 2

/////设置背景色

rng = (Excel.Range)SourceSheet.Cells[行, 列];

rng.Cells.Interior.ColorIndex = 3;      //红色

版权归原作者

posted @ 2012-10-15 09:57  戴眼镜的乌龟  阅读(2383)  评论(0编辑  收藏  举报