Guest User

Untitled

a guest
Feb 16th, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. > var Sheet = 'https://spreadsheets.google.com/feeds/list/SheetKey/od6/public/values?alt=json';
  2. >
  3. > function callback(data){
  4. > var cells = data.feed.entry;
  5. > .
  6. > .
  7. > .
  8.  
  9. function GETURL(input) {
  10. var range = SpreadsheetApp.getActiveSheet().getRange(input);
  11. var url = /"(.*?)"/.exec(range.getFormulaR1C1())[1];
  12. return url;
  13. }
Add Comment
Please, Sign In to add comment