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)

Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report

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
Verified answer

Florian Hopfner 2,461 on at

Like (1)

Report
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
PAX_Daniel on at

Like (0)

Report

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

Was this reply helpful? Yes No
PAX_Daniel on at

Like (0)

Report

Thanks, it works.

Was this reply helpful? Yes No