Python sample application that loads a sheet, updates selected cells, and saves the results
Switch branches/tags
Nothing to show
Clone or download
Latest commit d68d492 Jun 20, 2018
Permalink
Failed to load latest commit information.
.vscode Improve docs and logging Dec 11, 2017
.gitignore Initial commit Mar 8, 2017
LICENSE Initial commit Mar 8, 2017
README.md modify sample to use import Jun 19, 2018
Sample Sheet.xlsx Initial commit Mar 8, 2017
python-read-write-sheet.py fixed typo Jun 19, 2018

README.md

python-read-write-sheet

A Python sample application that loads a sheet, updates selected cells, and saves the results

This is a minimal Smartsheet sample that demonstrates how to

  • Import an XLSX file
  • Load a sheet
  • Loop through the rows
  • Check for rows that meet a criteria
  • Update cell values
  • Write the results back to the original sheet

This sample scans a sheet for rows where the value of the "Status" column is "Complete" and sets the "Remaining" column to zero. This is implemented in the evaluate_row_and_build_updates() method which you should modify to meet your needs.

Setup

Install the smartsheet Python SDK from pypi

  • pip install smartsheet --upgrade

Configure

  • Update the python-read-write-sheet.py file with an API access token, obtained from the Smartsheet Account button, under Personal settings (Alternatively, set a system environment variable SMARTSHEET_ACCESS_TOKEN to the value of your token)

Build and run the application.

  • python python-read-write-sheet.py

The rows marked "Complete" will have the "Remaining" value set to 0. (Note that you will have to refresh in the desktop application to see the changes.)

A log file named rwsheet.log will accumulate information about API calls.

See also