python做Excel表（折线）、python做Excel表（折线3d）、解决python -m pip install --upgrade pip 升级不成功问题、Python实现随机一些数

python做Excel表（折线）

from openpyxl import Workbook
from openpyxl.chart import(
    AreaChart,
    Reference,
    Series,
)

wb = Workbook()
ws = wb.active

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

for row in rows:
    ws.append(row)

chart = AreaChart()
chart.title = "Area Chart"
chart.style = 13
chart.x_axis.title = 'Test'
chart.y_axis.title = 'Percentage'

cats = Reference(ws, min_col=1, min_row=1, max_row=7)
data = Reference(ws, min_col=2, min_row=1,max_col=3, max_row=7)
chart.add_data(data,titles_from_data=True)
chart.set_categories(cats)

ws.add_chart(chart,"A10")

wb.save("area.xlsx")

python做Excel表（折线3d）

from openpyxl import Workbook
from openpyxl.chart import(
    AreaChart3D,
    Reference,
    Series,
)

wb = Workbook()
ws = wb.active

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)

chart = AreaChart3D()
chart.title = "Area Chart"
chart.style = 13
chart.x_axis.title = 'Test'
chart.y_axis.title = 'Percentage'
chart.legend = None

cats = Reference(ws, min_col=1, min_row=1, max_row=7)
data = Reference(ws, min_col=2, min_row=1,max_col=3, max_row=7)
chart.add_data(data,titles_from_data=True)
chart.set_categories(cats)

ws.add_chart(chart,"A10")

wb.save("area3D.xlsx")

1、解决python -m pip install --upgrade pip 升级不成功问题

亲测有用哦

2、问题解决，这是因为服务器连接超时，使用一下代码即可解决

python -m pip install --upgrade pip -i https://pypi.douban.com/simple

Python实现随机一些数，并且重现

出现false的全部可能bool（）

python运算