C# 设置excel单元格颜色

Question

Microsoft.Office.Interop.Excel.Range titleRange = worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[2, 2]);
titleRange.Interior.Color = Color.FromArgb(220, 20, 60);//设置颜色
抛异常

System . Color参数或返回值的型在内的方法叫出IDispatch中不能

Answer 1

把你的颜色用System.Drawing.ColorTranslator.ToOle封一下
例如：titleRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(Color.FromArgb(220, 20, 60));