Skip to main content

I want to know how to change Excel cell color using the Excel advanced package.
I found similar topics, but the information was from 2 years ago, so it seems outdated.

If the Excel advance package can’t be used,I’d like to know an alternative method.

Best regards

Hi ​@TKD-M,

I think it is not possible with the Excel Advanced package right now!

Python would work.

 

import openpyxl
from openpyxl.styles import Font, Alignment, Border, Side, PatternFill

data_fill = PatternFill(start_color='AED6F1', end_color='AED6F1', fill_type='solid')

 

Another way here:

 

Cheers

Marc

Very simple, just click on the color and change the cell

Hi ​@TKD-M ,

 

Please make use of the below mentioned package from Bot store to achieve this.

 

Excel Formating Operations

 

 

Remember that there are other alternatives. Things like conditional formatting, built into Excel. You can also use pre-formatted template files.

The best alternative is to create a simple VBA Macro inside Excel and use the "Run Macro" action from the Excel Advanced package to change cell colors.

Reply


Terms & ConditionsCookie settings