Community Learn Tools Library Leisure
search
English
Home > Backend Development > Python Tutorial > How to change font in python

How to change font in python

步履不停
Release： 2019-07-03 10:18:53
Original
13939 people have browsed it

How to change font in python

# 1. First import the classes that can specify the cell font, color, and alignment. 

from openpyxl.styles import Font, colors, Alignment
Copy after login

# 2. Configure the font format as: style (Times New Roman), size (11), italic (flase), color (black), bold (flase), you can modify it according to your needs 

font_style = Font(name='Times New Roman', size=11, italic=False, color='FF000000', bold=False)
Copy after login
#=====常用字体颜色配置数值===========
# BLACK = 'FF000000'
# WHITE = 'FFFFFFFF'
# RED = 'FFFF0000'
# DARKRED = 'FF800000'
# BLUE = 'FF0000FF'
# DARKBLUE = 'FF000080'
# GREEN = 'FF00FF00'
# DARKGREEN = 'FF008000'
# YELLOW = 'FFFFFF00'
# DARKYELLOW = 'FF808000'
#====================================
Copy after login

# Set the font format

sheet1.cell(row=i,column=1).font=font_style
Copy after login

# Set the font alignment. Here are vertical centering and horizontal centering. In addition to center, you can also use parameters such as right and left. 

sheet1.cell(row=i,column=1).alignment = Alignment(horizontal='center', vertical='center')
Copy after login

Recommended related tutorials: Python video tutorial

The above is the detailed content of How to change font in python. For more information, please follow other related articles on the PHP Chinese website!

Related labels：
python
source：php.cn
Previous article：What language is python written in? Next article：How to read txt in python
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Python/MySQL cannot persist integer data correctly No code is required here. I want to save a very long number because I'm making a game and ...
From 2024-04-04 19:09:44
0
1
367
Using selenium want to click and define URL in class I need another tip today. I'm trying to build Python/Selenium code and the idea is to clic...
From 2024-04-04 14:14:44
0
1
3492
Selenium + Python - inspect image via execute_script I need to verify that an image is displayed on the page using selenium in python. For exam...
From 2024-04-03 09:32:15
0
1
375
How to keep the first X rows and delete table rows I have a big table with millions of records in MySQLincident_archive, I want to sort the r...
From 2024-04-01 18:32:54
0
1
347
How to scrape specific Google Weather text using BeautifulSoup? How to find the course text "New York City, USA" in Python using BeautifulSoup? ...
From 2024-04-01 14:06:14
0
1
308
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template