Make certain merged cells text bold.

[Tamal_007]

How do I make the text of all merged cells bold in a sheet (except merged cells with a specific text say, "Abc")?

[Brian.Li]

Hello,

Thanks for your inquiry.
Please refer to the following code to meet your requirement.

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile("test.xlsx");

            Worksheet sheet = workbook.Worksheets[0];
            CellRange[] mergeCells = sheet.MergedCells;
            foreach (CellRange mergeCell in mergeCells)
            {
                if (!mergeCell.CellList[0].Value.Contains("Abc"))
                {
                    mergeCell.Style.Font.IsBold = true;
                }
            }
            String result = "Result.xlsx";
            workbook.SaveToFile(result, ExcelVersion.Version2013);

If there are any issues, just feel free to contact us.

Sincerely,
Brian
E-iceblue support team

[Tamal_007]

Thanks for your quick answer

[Brian.Li]

You are welcome.
If you have any other questions while using our products, just feel free to contact us.

Sincerely,
Brian
E-iceblue support team