自动化办公excel_t_pdf

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>import requests

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>#import xlwt

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>import pdfkit

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>import openpyxl

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>workbook = openpyxl.load_workbook('2020经销商目标.xlsx')

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>sheet1 = workbook['Sheet1']

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>print(sheet1)

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>html = """

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>><!doctype html>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>><html lang="en">

----------->>>>>>>>>>>>>>>>>>>>>>>>>>><head>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>><meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>><title>Document</title>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>><style>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> table {

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> font-size : 22px;

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> width: 850px;

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> }

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> .blod {

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> font_weight: bolder;

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> }

----------->>>>>>>>>>>>>>>>>>>>>>>>>>></style>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>></head>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>><body>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>><table border = "1" align = "center">

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <tr>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td colspan ="6" align = "center" >2020年广东经销商预算目标</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> </tr>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <tr>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td>经销商代码</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td>经销商名称</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td>成交数量</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td>成交金额</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td>商品金额</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td>客户签字</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> </tr>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <tr class = "blod">

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td>code</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td>name</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td>number</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td>money</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td>total</td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> <td></td>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> </tr>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>></table>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>></body>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>></html>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>"""

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>for row in list(sheet1.rows)[3:]:

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> for col in row:

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> print(col.value,end='\t')

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> print()

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> code = row[0].value

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> name = row[1].value

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> number = row[2].value

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> money = row[3].value

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> total = row[4].value

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> print(code,name)

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> html = html.replace('code',f'{code}')

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> html = html.replace('name',f'{name}')

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> html = html.replace('number',f'{number}')

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> html = html.replace('money',f'{money}')

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> html = html.replace('total',f'{total}')

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> #print(html)

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> with open('example.html',encoding='utf-8',mode = 'w') as f:

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> f.write(html)

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> #with open('example.html',encoding='utf-8',mode = 'r') as f:

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> # html = f.read()

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> ##--#配置pdf的转化

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> config = pdfkit.configuration(wkhtmltopdf=r'E:\青青教育\前程无忧\wkhtmltopdf\wkhtmltopdf\bin\wkhtmltopdf.exe')

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> #from_file

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

----------->>>>>>>>>>>>>>>>>>>>>>>>>>>

----------->>>>>>>>>>>>>>>>>>>>>>>>>>> break

-----<Worksheet "Sheet1">

-----2020年广东经销商预算目标 None None None None None

-----None None None None None None

-----经销商代码经销商名称成交数量成交金额商品金额客户签字

-----AA111 一一一 156 123123 123123 None

-----<Worksheet "Sheet1">

-----None None None None None

-----经销商名称成交数量成交金额商品金额客户签字

-----一一一 156 123123 123123 None

def func(money):
#print(money)
str_number = f'{money}'

str_list = list(str_number[::-1])  ##### 顺序反转
#print(str_list)
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]

if name == 'main':

#func('24578.13')   24,578,.13
#func('224578') #24,578  224,578
#func('224578')  ,224,578

https://pdf2000.com/converter/exceltopdf/?utm_source=baidunbz02&utm_medium=gj-PDFzh-Excel&utm_campaign=PDFzh-Excel-zh&utm_term=pythonexcelzpdf&e_keywordid=416335210836&e_keywordid2=416335210836&bd_vid=7870719357992339623

https://pdf2000.com/converter/exceltopdf/

https://www.bilibili.com/video/BV1SL411c7oX/?spm_id_from=pageDriver

求助使用python将excel转换成PDF的方法

千次阅读

2020-12-03 11:11:23

我用的是win32com的三方库，转换没有问题，只是excel的内容比较多，

最终转换完成后的样式不是自己需要的，请问ExportAsFixedFormat()方法中有没有

什么属性是可以将整个sheet页的内容转换成一张PDF，求大佬救命。

Import Module

from win32com import client

Open Microsoft Excel

excel = client.Dispatch("Excel.Application")

Read Excel File

sheets = excel.Workbooks.Open('2020经销商目标.xlsx')
work_sheets = sheets.Worksheets[0]

Convert into PDF File

work_sheets.ExportAsFixedFormat(0, '2020经销商目标.pdf')

https://www.bilibili.com/video/BV1rr4y187px/?spm_id_from=pageDriver

https://www.bilibili.com/video/BV1Kq4y1C7EJ/?spm_id_from=333.788

python实战案例教学：使用 flask 打造视频搜索网站

https://www.bilibili.com/video/BV1yP4y177ZV/?spm_id_from=333.788

Python爬虫实战教程：突破某点中文网字体反爬技术，获取网站数据

https://www.bilibili.com/video/BV1Vb4y1C7Bo/?spm_id_from=333.788

人面猴
序言：七十年代末，一起剥皮案震惊了整个滨河市，随后出现的几起案子，更是在滨河造成了极大的恐慌，老刑警刘岩，带你破解...
沈念sama阅读 219,753评论 6赞 508
死咒
序言：滨河连续发生了三起死亡事件，死亡现场离奇诡异，居然都是意外死亡，警方通过查阅死者的电脑和手机，发现死者居然都...
沈念sama阅读 93,668评论 3赞 396
救了他两次的神仙让他今天三更去死
文/潘晓璐我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
开封第一讲书人阅读 166,090评论 0赞 356
道士缉凶录：失踪的卖姜人
文/不坏的土叔我叫张陵，是天一观的道长。经常有香客问我，道长，这世上最难降的妖魔是什么？我笑而不...
开封第一讲书人阅读 59,010评论 1赞 295
港岛之恋（遗憾婚礼）
正文为了忘掉前任，我火速办了婚礼，结果婚礼上，老公的妹妹穿的比我还像新娘。我一直安慰自己，他们只是感情好，可当我...
茶点故事阅读 68,054评论 6赞 395
恶毒庶女顶嫁案：这布局不是一般人想出来的
文/花漫我一把揭开白布。她就那样静静地躺着，像睡着了一般。火红的嫁衣衬着肌肤如雪。梳的纹丝不乱的头发上，一...
开封第一讲书人阅读 51,806评论 1赞 308
城市分裂传说
那天，我揣着相机与录音，去河边找鬼。笑死，一个胖子当着我的面吹牛，可吹牛的内容都是我干的。我是一名探鬼主播，决...
沈念sama阅读 40,484评论 3赞 420
双鸳鸯连环套：你想象不到人心有多黑
文/苍兰香墨我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
开封第一讲书人阅读 39,380评论 0赞 276
万荣杀人案实录
序言：老挝万荣一对情侣失踪，失踪者是张志新（化名）和其女友刘颖，没想到半个月后，有当地人在树林里发现了一具尸体，经...
沈念sama阅读 45,873评论 1赞 319
护林员之死
正文独居荒郊野岭守林人离奇死亡，尸身上长有42处带血的脓包…… 初始之章·张勋以下内容为张勋视角年9月15日...
茶点故事阅读 38,021评论 3赞 338
白月光启示录
正文我和宋清朗相恋三年，在试婚纱的时候发现自己被绿了。大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
茶点故事阅读 40,158评论 1赞 352
活死人
序言：一个原本活蹦乱跳的男人离奇死亡，死状恐怖，灵堂内的尸体忽然破棺而出，到底是诈尸还是另有隐情，我是刑警宁泽，带...
沈念sama阅读 35,838评论 5赞 346
日本核电站爆炸内幕
正文年R本政府宣布，位于F岛的核电站，受9级特大地震影响，放射性物质发生泄漏。R本人自食恶果不足惜，却给世界环境...
茶点故事阅读 41,499评论 3赞 331
男人毒药：我在死后第九天来索命
文/蒙蒙一、第九天我趴在偏房一处隐蔽的房顶上张望。院中可真热闹，春花似锦、人声如沸。这庄子的主人今日做“春日...
开封第一讲书人阅读 32,044评论 0赞 22
一桩弑父案，背后竟有这般阴谋
文/苍兰香墨我抬头看了看天上的太阳。三九已至，却和暖如春，着一层夹袄步出监牢的瞬间，已是汗流浃背。一阵脚步声响...
开封第一讲书人阅读 33,159评论 1赞 272
情欲美人皮
我被黑心中介骗来泰国打工，没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留，地道东北人。一个月前我还...
沈念sama阅读 48,449评论 3赞 374
代替公主和亲
正文我出身青楼，却偏偏与公主长得像，于是被迫代替她去往敌国和亲。传闻我的和亲对象是个残疾皇子，可洞房花烛夜当晚...
茶点故事阅读 45,136评论 2赞 356