使用Smartsheet API从模板新建表格时单元格内容未复制的问题

Your current code only copies the template's column structure because the create_sheet_from_template method defaults to excluding data and formatting. To replicate the full template content (cell values, indentation, background colors, etc.), you need to explicitly specify which elements to include using the include property in the Sheet model.

Modified Code #

response = smart.Home.create_sheet_from_template(
  smartsheet.models.Sheet({
    'name': 'newsheet',
    'from_id': temp_id,    # template_id
    'include': ['data', 'format']  # Include data and formatting
  })
)
new_sheet = response.result

Key Details #

• The include parameter accepts an array of values that define what to copy from the template. The critical values for your use case are:
  • 'data': Copies all cell values from the template.
  • 'format': Copies cell formatting (background color, text style, indentation, etc.).
• If you need additional elements like attachments or discussions, you can add them to the array (e.g., ['data', 'format', 'attachments', 'discussions']).

This change will ensure your new sheet fully mirrors the template's content and formatting.

内容的提问来源于stack exchange，提问作者Colin