web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Change excel cell back...

Finance | Project Operations, Human Resources, ...

Answered

Change excel cell background color using x++ in D365

(0) Share

Report

Report

Posted on by Samkit

51

Hi Experts,

I have a requirement to generate excel in which background color is required.

I have tried following code:

cell = null;
cell = cells.get_Item(currentRow, 1);
style = cell.style;

var fill = style.Fill;
var patternType = fill.PatternType;
patternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;

var backgroundColor = fill.BackgroundColor;
backgroundColor.SetColor(System.Drawing.Color::FromArgb(190, 0, 0));

I am using OfficeOpenXml;

But am getting bellow error:

Can't set color when patterntype is not set.

I have also tried using patternType = ExcelFillStyle::Solid but received same error.

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Sergei Minozhenko 23,093 on at

Like (1)

Report
Hi Samkit,

Try to use set method for PatterType on fill variable.

fill.set_PatternType(OfficeOpenXml.Style.ExcelFillStyle::Solid);

Was this reply helpful? Yes No
Samkit 51 on at

Like (0)

Report

Hi @Sergei Minozhenko,

Thanks for the quick response. It worked like a charm.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 551 Most Valuable Professional

#2

André Arnaud de Cal... 450 Super User 2025 Season 2

#3

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans