Creating excel sheet using ClosedXML

Question

_{Tuesday, August 18, 2020 4:03 AM}

Hi All,

I am using below code to create excel sheet and fill the data from data table. But the excel sheet first row (not header) is different colour and rest of the rows colour is no colour.

using (XLWorkbook xlWorkbook = new XLWorkbook())
            {
                xlWorkbook.Worksheets.Add(dataTable, "RQ_List");
                xlWorkbook.Style.Fill.BackgroundColor = XLColor.NoColor;
                MemoryStream memoryStream = GetStream(xlWorkbook);
                Stream file = File.Create(fileName);
                memoryStream.WriteTo(file);
                memoryStream.Close();
                
                file.Close();
            }

I am using ClosedXML to create excel. Can anyone let me know how to create excel sheet with uniform colour?

Kindly waiting for your response.

Thanks,

Santosh

All replies (1)

_{Tuesday, August 18, 2020 2:07 PM}

We do not provide support for third party libraries in the MSDN forums. Questions related to third party libraries should be posted in their support forums.

If you want to use OpenSDK then they do have support forums here. Alternatively we also provide support for using the Excel COM objects directly.

Michael Taylor http://www.michaeltaylorp3.net