Guest User

Untitled

a guest
Mar 24th, 2017
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.79 KB | None | 0 0
  1. function URLupdate(){
  2. var queryString = Math.random();
  3.  
  4. var cellFunction1 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A3').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B3').setValue(cellFunction1);
  5. var cellFunction2 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A4').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B4').setValue(cellFunction2);
  6. var cellFunction3 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A5').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B5').setValue(cellFunction3);
  7. var cellFunction4 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A6').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B6').setValue(cellFunction4);
  8. var cellFunction5 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A7').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B7').setValue(cellFunction5);
  9. var cellFunction6 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A8').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B8').setValue(cellFunction6);
  10. var cellFunction7 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A9').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B9').setValue(cellFunction7);
  11. var cellFunction8 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A10').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B10').setValue(cellFunction8);
  12. var cellFunction9 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A11').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B11').setValue(cellFunction9);
  13. var cellFunction10 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A12').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B12').setValue(cellFunction10);
  14. var cellFunction11 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A13').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B13').setValue(cellFunction11);
  15. var cellFunction12 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A3').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!A16').setValue(cellFunction12);
  16. var cellFunction13 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A4').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!F16').setValue(cellFunction13);
  17. var cellFunction14 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A5').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!K16').setValue(cellFunction14);
  18. var cellFunction15 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A6').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!P16').setValue(cellFunction15);
  19. var cellFunction16 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A7').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!U16').setValue(cellFunction16);
  20. var cellFunction17 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A8').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!A50').setValue(cellFunction17);
  21. var cellFunction18 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A9').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!F50').setValue(cellFunction18);
  22. var cellFunction19 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A10').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!K50').setValue(cellFunction19);
  23. var cellFunction20 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A11').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!P50').setValue(cellFunction20);
  24. var cellFunction21 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A12').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!U50').setValue(cellFunction21);
  25. var cellFunction22 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A13').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!A81').setValue(cellFunction22);
  26. }
  27. function onOpen() {
  28. var sheet = SpreadsheetApp.getActiveSpreadsheet();
  29. var entries = [{
  30. name : "Refresh Stock",
  31. functionName : "URLupdate"
  32. }];
  33. sheet.addMenu("Script Center Menu", entries);
  34. };
Advertisement
Add Comment
Please, Sign In to add comment