ultraGrid 单元格内部分字体红色,导出部分字体红色

ultraGrid1_InitializeLayout()
 Infragistics.Win.FormattedLinkLabel.UltraFormattedLinkLabel lb = new Infragistics.Win.FormattedLinkLabel.UltraFormattedLinkLabel();
 gridColumns["cln"].EditorComponent = lb;

ultraGrid1_InitializeRow()
 e.Row.Cells["cln"].Value = "<span style=\"color:Red;\">XXXX</span> AAAA";

导出处理:

Excel.Application appt = new Excel.ApplicationClass();

appt.Visible = false;
Excel.Worksheet sheet = (Excel.Worksheet)appt.Workbooks.Open(_FilePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing).Worksheets["Sheet1"];
//读取已打开的Excel
Excel.Range range = null;

range = (Excel.Range)sheet.Cells[ 4, 4];

//查看获取单元格的值

 range.Value2.ToString();

//设置红色字体

range.get_Characters(2, 2).Font.Color = -16776961;

//设置黑色字体

range.get_Characters(2, 2).Font.ColorIndex = 0;

Excel.Workbook wbk = appt.Workbooks[1];
wbk.Close(true, Type.Missing, Type.Missing);
wbk = null;
appt.Quit();
appt = null;
GC.Collect();

 

posted on 2018-03-23 10:48  ningmou  阅读(582)  评论(0)    收藏  举报