按照zgl的思路做了一遍,特此分享添加Font库,Characters库
//选取某个单元格
range = sheet.get_Cells();//先获取所有单元格
WorkRge = range.get_Item(COleVariant((long)1),COleVariant((long)1)).pdispVal;//指定单元格 charact = WorkRge.get_Characters(COleVariant((long)1), COleVariant((long)5));//获取前5个字符
font = charact.get_Font();//获取字符的字体
font.put_Color(_variant_t((long)0x0000ff));//设置颜色