176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Refresh Excel named range with JSON data from Smartsheet
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

May 13, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, May 10, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: $100 or less
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Smartsheet (  [obscured]  ) is an on-line project management tool that I use to maintain on-line data. Smartsheet has recently released an API (  [obscured]  /developers/api-documentation) allowing developers direct access to Smartsheet data.

I would like to be able to refresh a named range in an Excel worksheet with the data that I track in Smartsheet. I would like to right-click on the named range in Excel, click refresh, and have the system send an API call to Smartsheet (see attachment) and refresh the named range in Excel with the updated data returned from the Smartsheet API call. There are many ways to do this in Excel...macro, VBA, Get External Data...I will choose the winning bidder based on the approach defined in the proposal. Please briefly describe your approach when you submit your proposal.

The attachment named "commands.txt" has two cURL commands (in order to run the commands, you need to have cURL installed on your computer.)

1. The first comma...

Sign in or Register to see more

Desired Skills
JSON
Job ID: 41382505
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
Winner
Expert programmer with multiple skills... 1. Office Automation - MS Excel Expert with deep knowledge of VBA/Macros and Formulas. Extensive...
7
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 41405776  |  Submitted: May 11, 2013 14:12 ET 
Delivery
Within 3 days
$125.00
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »