C#.net excel

Question

I have string value in cell with two line. I want to color the value after 1st line. Active Alert Discharge Second two line should be red color. using excel with C#.net

kumar yoga · Answer

thanks . but i want change Forecolor in Alert only. but ur code change all the line. single cell have multiline. i want color particluar line only not all cell value

kumar yoga · Answer

thanks . but i want change Forecolor in Alert only. but ur code change all the line. single cell have multiline. i want color particluar line only not all cell value

Nishant Mittal · Answer

hi try this Application excel = new Application(); Workbook wb = excel.Workbooks.Open(destPath); Worksheet ws = wb.Worksheets[1]; ws.Cells[row clmn].Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red)