使用pygsheets add_chart()创建直方图

Question

我正在尝试使用pygsheets .add_chart()函数创建直方图。为此，我只想传递一个domain参数，因为我只需要直方图的一列数据。但是，当我省略range参数时，如下所示：

output_ws.add_chart(domain=('A1', 'A17'), ranges=None, title='Histogram Chart')

我得到以下错误：

Traceback (most recent call last):
  File "cloud_functions/sheets_functions/main.py", line 327, in <module>
    get_field_growth_stage_sheet()
  File "cloud_functions/sheets_functions/main.py", line 321, in get_field_growth_stage_sheet
    output_ws.add_chart(domain=('A1', 'A17'), ranges=None, title='Histogram Chart')
  File "/usr/local/lib/python3.7/site-packages/pygsheets/worksheet.py", line 1518, in add_chart
    return Chart(self, domain, ranges, chart_type, title, anchor_cell)
  File "/usr/local/lib/python3.7/site-packages/pygsheets/chart.py", line 36, in __init__
    self._create_chart()
  File "/usr/local/lib/python3.7/site-packages/pygsheets/chart.py", line 282, in _create_chart
    response = self._worksheet.client.sheet.batch_update(self._worksheet.spreadsheet.id, request)
  File "/usr/local/lib/python3.7/site-packages/pygsheets/sheet.py", line 101, in batch_update
    return self._execute_requests(request)
  File "/usr/local/lib/python3.7/site-packages/pygsheets/sheet.py", line 359, in _execute_requests
    response = request.execute(num_retries=self.retries)
  File "/usr/local/lib/python3.7/site-packages/googleapiclient/_helpers.py", line 134, in positional_wrapper
    return wrapped(*args, **kwargs)
  File "/usr/local/lib/python3.7/site-packages/googleapiclient/http.py", line 898, in execute
    raise HttpError(resp, content, uri=self.uri)
googleapiclient.errors.HttpError: <HttpError 500 when requesting https://sheets.googleapis.com/v4/spreadsheets/1xvTqpxGN7voIAEv03fXAlY85EUsY0yehMdiP__3QnOg:batchUpdate?fields=%2A&alt=json returned "Internal error encountered.">

Answer 1

如果您需要一列数据，那么您需要的是单个范围和空域。因为range是指定数据的。

从暂存安装pygsheet

pip install --no-cache-dir https://github.com/nithinmurali/pygsheets/archive/staging.zip

然后试试这个：

output_ws.add_chart(domain=None, ranges=[('A1', 'A17')], title='Histogram Chart')