python - 传递工作表名称的workbook.add_chartsheet([sheetname])无法正常工作

Question

Closed. This question needs details or clarity。它当前不接受答案。
                            
                        
                    
                
                            
                                
                
                        
                            
                        
                    
                        
                            想改善这个问题吗？添加详细信息并通过 editing this post阐明问题。
                        
                        去年关闭。
                                                                                            
                
        
传递工作表名称的workbook.add_chartsheet（[sheetname]）无法正常工作

查看参考网站： https://xlsxwriter.readthedocs.io/workbook.html?highlight=add_chartsheet

"workbook.add_chartsheet()

add_chartsheet([sheetname])

Add a new add_chartsheet to a workbook.

Parameters: sheetname (string) – Optional chartsheet name, defaults to Chart1, etc.

Return type:    A chartsheet object.

The add_chartsheet() method adds a new chartsheet to a workbook."

传递任何字符串变量或字符串作为add.chartsheet（['Data1Chart']）都会返回KeyError'Data1Chart'。

输出应具有一个带有自定义名称的图表，而不是默认的“图表”。

最佳答案

传递任何字符串变量或字符串均无效。


它应为documented。这是更改图表表名称的示例：

import xlsxwriter

workbook = xlsxwriter.Workbook('chartsheet.xlsx')

# Add a worksheet to hold the data.
worksheet = workbook.add_worksheet()

# Add a chartsheet. A worksheet that only holds a chart.
chartsheet = workbook.add_chartsheet('My Chart')

# Add the worksheet data that the charts will refer to.
worksheet.write_column('A1', [2, 3, 4, 5, 6, 7])
worksheet.write_column('B1', [2, 3, 4, 5, 6, 7])

# Create a new bar chart.
chart1 = workbook.add_chart({'type': 'bar'})

# Configure the first series.
chart1.add_series({
    'categories': '=Sheet1!$A$2:$A$7',
    'values':     '=Sheet1!$B$2:$B$7',
})

# Add the chart to the chartsheet.
chartsheet.set_chart(chart1)

# Display the chartsheet as the active sheet when the workbook is opened.
chartsheet.activate();

workbook.close()

输出：

关于python - 传递工作表名称的workbook.add_chartsheet([sheetname])无法正常工作，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/54226154/

上一篇：python - scipy.optimize_curvefit 给出不好的结果

下一篇：Python 不带参数的 setter 方法名称的命名约定

相关文章：

python - 将相同的函数与不同的参数组合起来 - Python

python - 如何从 Microsoft Powerpoint 打开嵌入的 '.py' 文件？

html - 将交互式 Excel 电子表格嵌入网站

python - 如何在 xlsxwriter 中将值放置在堆积条形图之外

python - XlsxWriter 和 Python 继承

python - Pandas:计算每月收集的房屋销售额的半年平均值

Python 在对相同对象执行相同操作两次时给出了两个不同的结果

vba - Excel 2016 VBA 自动时间插入

正则表达式从带有回车数据 VBA 的单元格中删除数字+空格

python - xlsxwriter:如何将 "inf"值取消着色？

Answer 1

传递任何字符串变量或字符串均无效。


它应为documented。这是更改图表表名称的示例：

import xlsxwriter

workbook = xlsxwriter.Workbook('chartsheet.xlsx')

# Add a worksheet to hold the data.
worksheet = workbook.add_worksheet()

# Add a chartsheet. A worksheet that only holds a chart.
chartsheet = workbook.add_chartsheet('My Chart')

# Add the worksheet data that the charts will refer to.
worksheet.write_column('A1', [2, 3, 4, 5, 6, 7])
worksheet.write_column('B1', [2, 3, 4, 5, 6, 7])

# Create a new bar chart.
chart1 = workbook.add_chart({'type': 'bar'})

# Configure the first series.
chart1.add_series({
    'categories': '=Sheet1!$A$2:$A$7',
    'values':     '=Sheet1!$B$2:$B$7',
})

# Add the chart to the chartsheet.
chartsheet.set_chart(chart1)

# Display the chartsheet as the active sheet when the workbook is opened.
chartsheet.activate();

workbook.close()

输出：