在openpyxl中的ScatterChart中添加标签 [英] Adding labels to ScatterChart in openpyxl

问题描述

我已经编写了这个简单的代码来测试更复杂的代码:

I have wrote this simple code to test things out for a more complicated one:

import sys

from openpyxl import load_workbook
from openpyxl.chart import Reference, ScatterChart, Series
from openpyxl.chart.label import DataLabel, DataLabelList
from openpyxl.chart.marker import Marker
from openpyxl.chart.shapes import GraphicalProperties
from openpyxl.drawing.colors import ColorChoice

wb = load_workbook(sys.argv[1])
for ws in wb:
    chart = ScatterChart(scatterStyle='smoothMarker')
    for x in range(2, 192):
        labels = Reference(ws, min_col=1, max_col=1, min_row=x, max_row=x)
        xaxis = Reference(ws, min_col=2, max_col=2, min_row=x, max_row=x)
        data = Reference(ws, min_col=3, max_col=3, min_row=x, max_row=x)
        s = Series(xaxis, data, title=ws['A' + str(x)].value)
        sp_color = ColorChoice(prstClr=(str(ws['A' + str(x)].value)))
        sp_sppr = GraphicalProperties(solidFill=sp_color)
        s.marker = Marker(symbol=('circle'), size=20, spPr=sp_sppr)
        s.marker.spPr.ln.noFill = True
        s.spPr.ln.noFill = True
        slabel = list()  #EDITED
        for x in labels.cells:  #EDITED
             slabel.append(ws[x].value)  #EDITED
        s.labels = DataLabelList(dLbl=slabel, dLblPos='bestFit')
        chart.series.append(s)
    chart.dataLabels = (DataLabelList(showLegendKey=True))
    ws.add_chart(chart, 'D1')
wb.save(sys.argv[1])

用作sys.argv[1]的文件就是这样的(技术上它只是

the file use as sys.argv[1] is like that (technically it's just the color list for prstClr of ColorChoice with x += 10 and y = x):

Color   x   y
beige   0   0
forestGreen 10  10
dkGoldenrod 20  20
lightPink   30  30
slateGrey   40  40

行s.labels = DataLabelList(dLbl=slabel, dLblPos='bestFit')输出错误:

Traceback (most recent call last):
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/descriptors/base.py", line 57, in _convert
    value = expected_type(value)
ValueError: invalid literal for int() with base 10: 'beige'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/descriptors/base.py", line 57, in _convert
    value = expected_type(value)
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/chart/label.py", line 100, in __init__
    self.idx = idx
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/descriptors/nested.py", line 36, in __set__
    super(Nested, self).__set__(instance, value)
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/descriptors/base.py", line 69, in __set__
    value = _convert(self.expected_type, value)
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/descriptors/base.py", line 59, in _convert
    raise TypeError('expected ' + str(expected_type))
TypeError: expected <class 'int'>

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "csv/test.py", line 37, in <module>
    s.labels = DataLabelList(dLbl=slabel, dLblPos='bestFit')
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/chart/label.py", line 128, in __init__
    self.dLbl = dLbl
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/descriptors/sequence.py", line 27, in __set__
    seq = [_convert(self.expected_type, value) for value in seq]
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/descriptors/sequence.py", line 27, in <listcomp>
    seq = [_convert(self.expected_type, value) for value in seq]
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/descriptors/base.py", line 59, in _convert
    raise TypeError('expected ' + str(expected_type))
TypeError: expected <class 'openpyxl.chart.label.DataLabel'>

我使用了一个列表，正如查理(Charlie)指出的那样，没有获得更多的成功，该列表应该包含相同数量的项目，每个项目的标签名称.
slabel.append(ws[x].value)或slabel.append(x)输出相同的错误，该列表应包含什么内容?

I used a list as Charlie pointed it out without more success, this list should contains the same amount of items with the label names of each.
Either slabel.append(ws[x].value) or slabel.append(x) output the same error, what should that list contains?

版本:
-openpyxl 2.4.8
-python 3.6
-macOS Siera 10.12.6

Versions:
- openpyxl 2.4.8
- python 3.6
- macOS Siera 10.12.6

致谢

推荐答案

Sequence是在编写不正确使用的类时使用的描述符.您需要提供一个Python序列(列表，元组等)

Sequence is a descriptor used when writing classes you're using it incorrectly. You need to provide a Python sequence (list, tuple, etc.)

这篇关于在openpyxl中的ScatterChart中添加标签的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！