Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function URLupdate(){
- var queryString = Math.random();
- var cellFunction1 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A3').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B3').setValue(cellFunction1);
- var cellFunction2 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A4').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B4').setValue(cellFunction2);
- var cellFunction3 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A5').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B5').setValue(cellFunction3);
- var cellFunction4 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A6').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B6').setValue(cellFunction4);
- var cellFunction5 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A7').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B7').setValue(cellFunction5);
- var cellFunction6 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A8').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B8').setValue(cellFunction6);
- var cellFunction7 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A9').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B9').setValue(cellFunction7);
- var cellFunction8 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A10').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B10').setValue(cellFunction8);
- var cellFunction9 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A11').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B11').setValue(cellFunction9);
- var cellFunction10 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A12').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B12').setValue(cellFunction10);
- var cellFunction11 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A13').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!A1').getValue() + '")'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!B13').setValue(cellFunction11);
- var cellFunction12 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A3').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!A16').setValue(cellFunction12);
- var cellFunction13 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A4').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!F16').setValue(cellFunction13);
- var cellFunction14 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A5').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!K16').setValue(cellFunction14);
- var cellFunction15 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A6').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!P16').setValue(cellFunction15);
- var cellFunction16 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A7').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!U16').setValue(cellFunction16);
- var cellFunction17 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A8').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!A50').setValue(cellFunction17);
- var cellFunction18 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A9').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!F50').setValue(cellFunction18);
- var cellFunction19 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A10').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!K50').setValue(cellFunction19);
- var cellFunction20 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A11').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!P50').setValue(cellFunction20);
- var cellFunction21 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A12').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!U50').setValue(cellFunction21);
- var cellFunction22 = '=IMPORTHTML("' + SpreadsheetApp.getActiveSheet().getRange('TravelStock!A13').getValue() + '?' + queryString + '",'+ SpreadsheetApp.getActiveSheet().getRange('TravelStock!B1').getValue() + ')'; SpreadsheetApp.getActiveSheet().getRange('TravelStock!A81').setValue(cellFunction22);
- }
- function onOpen() {
- var sheet = SpreadsheetApp.getActiveSpreadsheet();
- var entries = [{
- name : "Refresh Stock",
- functionName : "URLupdate"
- }];
- sheet.addMenu("Script Center Menu", entries);
- };
Advertisement
Add Comment
Please, Sign In to add comment