Ruby sample application that loads a sheet, updates selected cells, and saves the results
Switch branches/tags
Nothing to show
Clone or download
kfansler Merge pull request #1 from smartsheet-samples/feature/import-sample-s…
…heet

Import sample sheet directly from file
Latest commit 7b127be Jul 10, 2018

README.md

ruby-read-write-sheet

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

This is a minimal Smartsheet sample that demonstrates how to

  • 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_update method which you could modify to meet your needs.

Setup

  • Install the smartsheet library with gem install smartsheet or bundle at the command line

  • Import the sample data from "Sample Sheet.xlsx" into a new sheet

  • Update the config.json file with these two settings:

    • An API access token, obtained from the Smartsheet Account button, under Personal settings
    • The Sheet Id, obtained from sheet properties
  • Run the application using your preferred IDE or at the command line with ruby read_write_sheet.rb

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)

See also