Shulou(Shulou.com)06/01 Report--

This article is about how Python converts excel content into pdf content in batches. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Project name:

Batch conversion of excel content to pdf

Knowledge points:

Python operation excel

Python operation pdf

Html

Development environment:

Interpreter: Python 3.6.5 | Anaconda, Inc.

Editor: pycharm Community Edition

Code

Import tool

Import openpyxlimport pdfkit

Load a local file

Workbook = openpyxl.load_workbook ('2020 dealer target .xlsx') def func (money): # print (money) str_number = f'{money} 'str_list = list (str_number [::-1]) str_ = "" I = 1 for no, char in enumerate (str_list): str_ + = char # print (no Char) if I% 3 = 0 and len (str_list)! = I: str_ + =','I + = 1 # print (str_ [::-1]) return str_ [::-1] sheet1 = workbook ['Sheet1'] print (sheet1) for row in list (sheet1.rows) [3:]: for col in row [1:]: print (col.value) End='\ t') code = row [1] .value name = row [2] .value number = row [3] .value money = row [4] .value total = row [5] .value print (code, name, number, money) str_number = func (number) str_money = func (money) str_total = func (total) html = html.replace ('code', code) html = html.replace (' name') Name) html = html.replace ('number', f' {str_number} .00') html = html.replace (' money', f' {str_money:} .00') html = html.replace ('total', f' {str_total} .00') # print (html) with open (' example.html', mode='w', encoding='utf-8') as f: f.write (html)

Configure the conversion software for pdf

Config = pdfkit.configuration (wkhtmltopdf='C:\\ Program Files\\ wkhtmltopdf\ bin\\ wkhtmltopdf.exe')

The name of the from_file file saves the name of the file and the configuration of the conversion software

Pdfkit.from_file ('example.html', f' {name} .pdf', configuration=config)

Convert to PDF

Html = "" Document table {font-size: 22px; width: 850px;} .blod {font-weight: bolder 2020 Guangdong dealer budget target dealer code dealer name car quantity amount of goods customer signature code name number money total

Finally, run the code, and the effect is as follows

Thank you for reading! This is the end of this article on "how Python converts excel content into pdf in batches". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.