python图片转txt、python做Excel表（显示时间）、python做Excel表（柱状）

学习微站公众平台

已于 2022-09-25 11:52:55 修改

阅读量717

点赞数 2

分类专栏： Python SpringCloud 文章标签： python pycharm 开发语言

于 2020-02-06 20:21:53 首次发布

本网站刊载的所有内容，包括文字、图片、音频、视频、软件、程序、以及网页版式设计等在网上搜集或者是自己原创的。访问者可将本网站提供的内容或服务用于时应遵守著作权法及其他相关法律的规定，不得侵犯本网站及相关权利人的合法权利。除此以外，将本网站任何内容或服务用于其他用途时，须征得本网站及相关权利人的书面许可，并支付报酬。不得以任何形式侵犯作者权益，最终解释权归本人所有。

本文链接：https://blog.csdn.net/weixin_43206161/article/details/104201607

版权

SpringCloud 同时被 2 个专栏收录

72 篇文章 2 订阅

订阅专栏

Python

10 篇文章 1 订阅

订阅专栏

python图片转txt

在这里插入图片描述
图片前后比较，因为图片是晚上拍的，效果可能欠佳

from PIL import Image
img = Image.open("D:\PyCharm实例\zihuaxiang\IMG_20190513_215846-.png")
out = img.convert("L")
out.size
width, height = out.size
out = out.resize((int(width * 0.5),int(height * 0.5)))
width, height = out.size
print(width,height)
print(out.getpixel((100,100)))
print(out.getpixel((200,200)))
asciis = "@%#+=-. "
texts = " "
for row in range(height):
    for col in range(width):
        gray = out.getpixel((col,row))
        texts += asciis[int(gray / 255 * 2)]
    texts += "\n"
with open("D:/PyCharm实例/zihuaxiang/new2.txt","w") as file:
    file.write(texts)

python做Excel表（显示时间）

在这里插入图片描述

import openpyxl
import datetime
wb = openpyxl.Workbook()
ws = wb.active
ws.title
ws['A1'] = 520
ws.append([1,2,3])
ws['A3'] = datetime.datetime.now()
wb.save('time.xlsx')

python做Excel表（柱状）

在这里插入图片描述

from openpyxl import Workbook
from openpyxl.chart import BarChart,Series,Reference

wb = Workbook(write_only=True)
ws = wb.create_sheet()

rows = [
    ['Number','Batch 1','Batch 2'],
    [2, 30, 40],
    [3, 25, 40],
    [4, 30, 50],
    [5, 10, 30],
    [6, 5, 25],
    [7, 10, 50],
]

for row in rows:
    ws.append(row)

chart1 = BarChart()
chart1.type = "col"
chart1.style = 10
chart1.title = "Bar Chart"
chart1.y_axis.title = 'Test number'
chart1.x_axis.title = 'Sample length (mm)'

data = Reference(ws, min_col=2, min_row=1,max_col=7, max_row=3)
cats = Reference(ws, min_col=1, min_row=2, max_row=7)
chart1.add_data(data,titles_from_data=True)
chart1.set_categories(cats)
chart1.shape = 4
ws.add_chart(chart1,"A10")

from copy import deepcopy

chart2 = deepcopy(chart1)
chart2.style = 11
chart2.type = "bar"
chart2.title = "Horizontal Bar Chart"

ws.add_chart(chart2,"J10")

chart3 = deepcopy(chart1)
chart3.type = "col"
chart3.stype = 12
chart3.grouping = "stacked"
chart3.overlap = 100
chart3.title = 'Stacked Chart'

ws.add_chart(chart3,"A27")


chart4 = deepcopy(chart1)
chart4.type = "bar"
chart4.style = 13
chart4.grouping = "percentStacked"
chart4.overlap = 100
chart4.title = 'Percent Stacked Chart'

ws.add_chart(chart4,"J27")

wb.save("bar.xlsx")