简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > Python Tutorial > body text

How to change font in python

步履不停
Release： 2019-07-03 10:18:53
Original
13848 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
How to run python script from HTML in google chrome? I'm building a chrome extension and I want to run a python script from my PC by clicking a...
From 2023-11-02 23:34:24
0
1
400
Why do some mysql connections select old data of mysql database after delete+insert? I have a problem with sessions in my python/wsgiweb application. Each thread in the 2 wsgi...
From 2023-10-30 12:37:20
0
2
229
Using variables to execute SQL statements in Python I have the following Python code: cursor.execute("INSERTINTOtableVALUESvar1,var2,var3...
From 2023-10-12 15:06:00
0
2
258
Understanding the ternary operator in Python [duplicate] I'm currently transitioning from JavaScript to Python, and I'm wondering if Python has a t...
From 2023-09-21 18:46:04
0
1
377
How to match strings with appended parts using Python, but not match them if their appended parts are different How to match strings with appended parts, but not match them if they have different append...
From 2023-09-20 19:02:23
0
1
260
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
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！