How to get the color value of cell background and text in ex

[Thanhdev98]

Hi support team. I have a problem to solve with your lib. When we upload this sample file and save it under a folder with the file name XXX. It keeps the original file. This is ok. But when I need to read the XXX file again under folder. I don't know a way to read properties like the color of the text and the corresponding backgound of each cell and col. I need those colors to properly display this original excel file as HTML. Tks

[Andy.Zhou]

Hello,

Thanks for your inquiry.
You can refer to the following code to get text color and background color of cells. If you have any other questions about our products, just feel free to contact us.

Code: Select all

                   
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("DataSample.xlsx");
            Worksheet sheet = workbook.Worksheets[0];
            //Traverse all used cells
            foreach (CellRange range in sheet.Cells)
            {
                //Get background color of this cell
                Color backgroundColor = range.Style.Color;
                //Get text color of this cell
                Color textColor = range.Style.Font.Color;
            }


[Andy.Zhou]

Hello,

Hope you are doing well.
Has your issue been resolved now? Could you please give us some feedback at your convenience. Thanks in advance.