Last active
May 18, 2017 12:55
-
-
Save gdevanla/c5aedcd7d2b7989bbbdf8345bf775a66 to your computer and use it in GitHub Desktop.
for color formatting
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from openpyxl.styles import Alignment | |
| def format_data(index, col_name): | |
| alignment = Alignment(horizontal=’right’) | |
| if col_name == ‘salary’: | |
| return dict( | |
| alignment=alignment, | |
| number_format='$0.00') |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment