How to add Excel cell background color file by X++ in Dynamics 365?

(0) Share

Report

Posted on by PAX_Daniel

I'm creating an Excel file by x++, in Dynamics 365 - D365, I would like to add the background color by X++.

I'm using this code

var package = new OfficeOpenXml.ExcelPackage(memoryStream)
var worksheets = package.get_Workbook().get_Worksheets();
var worksheet = worksheets.Add("SHEET");
var cells = worksheet.get_Cells();
var currentRow=1 ;

var cell = cells.get_Item(currentRow,1);
cell.set_Value("__MY__Value");

// NOT Work - compile error
//cell.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color::FromArgb(190, 0, 0));
//cell.Style.Fill.BackgroundColor.Rgb(Winapi::rgb2int(255,255,255));

How can I use the Background color property about Excel cell, by X++ in right way?

Thanks in advance.

I have the same question (0)

All responses (4)

Answers (1)

PAX_Daniel on at

Like (0)

Report

RE: How to add Excel cell background color file by X++ in Dynamics 365?

Thanks, it works.

Was this reply helpful? Yes No
PAX_Daniel on at

Like (0)

Report

RE: How to add Excel cell background color file by X++ in Dynamics 365?

Thanks for your reply @Martin Dráb. Below anothe user helped me about the question.

Was this reply helpful? Yes No
Verified answer

Florian Hopfner 2,451 on at

Like (1)

Report
RE: How to add Excel cell background color file by X++ in Dynamics 365?

This was answered here: axapta - How to add Excel cell background color file by X++ in Dynamics 365? - Stack Overflow

The compile error is Invalid token '('.

It can be resolved by splitting the chain of .NET assembly calls from

cell.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color::FromArgb(190, 0, 0));

to

ExcelColor backgroundColor = cell.Style.Fill.BackgroundColor; backgroundColor.SetColor(System.Drawing.Color::FromArgb(190, 0, 0));

Was this reply helpful? Yes No
Martin Dráb 235,876 Most Valuable Professional on at

Like (1)

Report

RE: How to add Excel cell background color file by X++ in Dynamics 365?

Because you mentioned X++, you seem to be talking about Dynamics 365 for Finance and Operations. That's why I moved your thread here.

Please tell us more about the compilation error.

Was this reply helpful? Yes No