openpyxl图表错误栏样式

openpyxl图表错误栏样式

看来

NumVal

，

NumData

并且

NumDataSource

需要

ErrorBars

从头开始创建：

# References for X and Yxvalues = Reference(<worksheet>, min_col=<xcol>, min_row=<min>, max_row=<max>)yvalues = Reference(<worksheet>, min_col=<ycol>, min_row=<min>, max_row=<max>) plus = [<list of error values for plus>]minus = [<list of error values for minus>]# Convert lists of error values to ErrorBars objecterrorbars = list2errorbars(plus, minus, errDir='y')# Create series data and set error barseries = SeriesFactory(yvalues, xvalues, title="y direction error")series.errBars = errorbarsdef list2errorbars(plus, minus, errDir='y', errValType='cust'):    "Returns ErrorBar from lists of error values"    #Convert to list of NumVal    numvals_plus = [NumVal(i, None, v=x) for i,x in enumerate(plus)]    numvals_minus = [NumVal(i, None, v=x) for i,x in enumerate(minus)]    # Convert to NumData    nd_plus = NumData(pt=numvals_plus)    nd_minus = NumData(pt=numvals_minus)    # Convert to NumDataSource    nds_plus = NumDataSource(numLit=nd_plus)    nds_minus = NumDataSource(numLit=nd_minus)    return ErrorBars(plus=nds_plus, minus=nds_minus, errDir=errDir, errValType=errValType)

完整的示例代码：https :
//github.com/uskysd/openpyxl-errorbar

由于我也找不到好的文档，因此我从源代码中找出来。让我知道是否有更简单的方法可以做到这一点。