Updating old formatted spreadsheets using a reformatted spreadsheet that takes the old values and duplicates...





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















CODE IS DONE thx @TheMaster ✔



I'm an absolute novice in the google drive sdk, excuse me.



I'm trying to write a script, which allows many sheets that are identical to updated. Through a Source spreadsheet (with new formatting). Problem is that in the old sheets, values ​​are in there, which must be in the new sheet "Source spreadsheet" (with new formatting) in there. And then again and again with an old sheet reiterate.



Procedure in my mind for the script:





  • go to folder where many sheets are ✔


  • open the first sheet and then always the next ✔


  • take the data from area (A1:A2;C1:C2) ✔


  • take the name of the sheets ✔


  • Copy them into the data in the source spreadsheet in the same place ✔


  • Make a copy of the source spreadsheet ✔


  • Name the source spreadsheet as the old sheet ✔


  • rename it and put it in another folder ✔


I will help, where I can.



current code:






function UPDATE() {

  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSreadSheet, s=Sheet, n=Name//



  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//

  

  //replace it with Folder ID where the old spreadsheets are in

  var folder=DriveApp.getFolderById('Folder ID')

  //takes all files in the folder and sets the variable file

  var files=folder.getFiles();

    while (files.hasNext()) 

    {

  var file = files.next();



  //---TAKE DATA---//



  //replace with source ID

  var o_ss=SpreadsheetApp.open(file); 

  //replace with source Sheet tab name 1 to as much as you want

  var o_s_n1=o_ss.getSheetByName('tab name1');

  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional

  //assign one ore more ranges you want to copy

  var o_range1=o_s_n1.getRange('A1:A2'); 

  var o_range2=o_s_n1.getRange('C1:C2'); //optional

  //Copy the values

  var o_data1=o_range1.getValues();

  var o_data2=o_range2.getValues(); //optional



  //---COPY DATA---//



  //replace with destination ID

  var sss_ss=SpreadsheetApp.openById('destination ID');

  //replace with destination Sheet tab name

  var sss_s=sss_ss.getSheetByName('tab name1');

  //Area where to copy in the new sheet

    sss_s.getRange('A1:A2').setValues(o_data1); 

    sss_s.getRange('C1:C2').setValues(o_data2); //optional



  //closes the code until here first

  SpreadsheetApp.flush();

          

  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//

  

  //gets the sheet name from the old sheet

  var o_ss_n=o_ss.getName();

  //replace with destination Folder ID

  var folder=DriveApp.getFolderById('Folder ID')

  

  //Copy the destination sheet and name it like the old sheet

    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);

    }

}








google-apps-script google-sheets google-drive-sdk







share|improve this question

























  • Try what you dreamt of and if you run into a specific problem, provide Minimal, Complete, and Verifiable example

    – TheMaster
    Nov 24 '18 at 21:41











  • @TheMaster I have updated my code, I do not get the repeat function, do you still have an idea? Would it be nice to work here with flush ()?

    – KillBill_158
    Nov 28 '18 at 16:49











  • You'll get the folder first > then execute this function you wrote for all the files in the folder inside the while loop. See the first example here

    – TheMaster
    Nov 28 '18 at 19:30













  • @TheMaster Now he takes all the files in a folder and copies them but he does not take the areas from the spreadsheets. what's wrong here? do you have to do that with an array?

    – KillBill_158
    Dec 5 '18 at 18:52











  • @TheMaster The code works, but it does not take the Ranges from the old tables and copies them to the new spreadsheet. where exactly is the error?

    – KillBill_158
    Dec 5 '18 at 20:54


















0















CODE IS DONE thx @TheMaster ✔



I'm an absolute novice in the google drive sdk, excuse me.



I'm trying to write a script, which allows many sheets that are identical to updated. Through a Source spreadsheet (with new formatting). Problem is that in the old sheets, values ​​are in there, which must be in the new sheet "Source spreadsheet" (with new formatting) in there. And then again and again with an old sheet reiterate.



Procedure in my mind for the script:





  • go to folder where many sheets are ✔


  • open the first sheet and then always the next ✔


  • take the data from area (A1:A2;C1:C2) ✔


  • take the name of the sheets ✔


  • Copy them into the data in the source spreadsheet in the same place ✔


  • Make a copy of the source spreadsheet ✔


  • Name the source spreadsheet as the old sheet ✔


  • rename it and put it in another folder ✔


I will help, where I can.



current code:






function UPDATE() {

  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSreadSheet, s=Sheet, n=Name//



  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//

  

  //replace it with Folder ID where the old spreadsheets are in

  var folder=DriveApp.getFolderById('Folder ID')

  //takes all files in the folder and sets the variable file

  var files=folder.getFiles();

    while (files.hasNext()) 

    {

  var file = files.next();



  //---TAKE DATA---//



  //replace with source ID

  var o_ss=SpreadsheetApp.open(file); 

  //replace with source Sheet tab name 1 to as much as you want

  var o_s_n1=o_ss.getSheetByName('tab name1');

  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional

  //assign one ore more ranges you want to copy

  var o_range1=o_s_n1.getRange('A1:A2'); 

  var o_range2=o_s_n1.getRange('C1:C2'); //optional

  //Copy the values

  var o_data1=o_range1.getValues();

  var o_data2=o_range2.getValues(); //optional



  //---COPY DATA---//



  //replace with destination ID

  var sss_ss=SpreadsheetApp.openById('destination ID');

  //replace with destination Sheet tab name

  var sss_s=sss_ss.getSheetByName('tab name1');

  //Area where to copy in the new sheet

    sss_s.getRange('A1:A2').setValues(o_data1); 

    sss_s.getRange('C1:C2').setValues(o_data2); //optional



  //closes the code until here first

  SpreadsheetApp.flush();

          

  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//

  

  //gets the sheet name from the old sheet

  var o_ss_n=o_ss.getName();

  //replace with destination Folder ID

  var folder=DriveApp.getFolderById('Folder ID')

  

  //Copy the destination sheet and name it like the old sheet

    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);

    }

}








google-apps-script google-sheets google-drive-sdk







share|improve this question

























  • Try what you dreamt of and if you run into a specific problem, provide Minimal, Complete, and Verifiable example

    – TheMaster
    Nov 24 '18 at 21:41











  • @TheMaster I have updated my code, I do not get the repeat function, do you still have an idea? Would it be nice to work here with flush ()?

    – KillBill_158
    Nov 28 '18 at 16:49











  • You'll get the folder first > then execute this function you wrote for all the files in the folder inside the while loop. See the first example here

    – TheMaster
    Nov 28 '18 at 19:30













  • @TheMaster Now he takes all the files in a folder and copies them but he does not take the areas from the spreadsheets. what's wrong here? do you have to do that with an array?

    – KillBill_158
    Dec 5 '18 at 18:52











  • @TheMaster The code works, but it does not take the Ranges from the old tables and copies them to the new spreadsheet. where exactly is the error?

    – KillBill_158
    Dec 5 '18 at 20:54














0












0








0








CODE IS DONE thx @TheMaster ✔



I'm an absolute novice in the google drive sdk, excuse me.



I'm trying to write a script, which allows many sheets that are identical to updated. Through a Source spreadsheet (with new formatting). Problem is that in the old sheets, values ​​are in there, which must be in the new sheet "Source spreadsheet" (with new formatting) in there. And then again and again with an old sheet reiterate.



Procedure in my mind for the script:





  • go to folder where many sheets are ✔


  • open the first sheet and then always the next ✔


  • take the data from area (A1:A2;C1:C2) ✔


  • take the name of the sheets ✔


  • Copy them into the data in the source spreadsheet in the same place ✔


  • Make a copy of the source spreadsheet ✔


  • Name the source spreadsheet as the old sheet ✔


  • rename it and put it in another folder ✔


I will help, where I can.



current code:






function UPDATE() {

  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSreadSheet, s=Sheet, n=Name//



  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//

  

  //replace it with Folder ID where the old spreadsheets are in

  var folder=DriveApp.getFolderById('Folder ID')

  //takes all files in the folder and sets the variable file

  var files=folder.getFiles();

    while (files.hasNext()) 

    {

  var file = files.next();



  //---TAKE DATA---//



  //replace with source ID

  var o_ss=SpreadsheetApp.open(file); 

  //replace with source Sheet tab name 1 to as much as you want

  var o_s_n1=o_ss.getSheetByName('tab name1');

  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional

  //assign one ore more ranges you want to copy

  var o_range1=o_s_n1.getRange('A1:A2'); 

  var o_range2=o_s_n1.getRange('C1:C2'); //optional

  //Copy the values

  var o_data1=o_range1.getValues();

  var o_data2=o_range2.getValues(); //optional



  //---COPY DATA---//



  //replace with destination ID

  var sss_ss=SpreadsheetApp.openById('destination ID');

  //replace with destination Sheet tab name

  var sss_s=sss_ss.getSheetByName('tab name1');

  //Area where to copy in the new sheet

    sss_s.getRange('A1:A2').setValues(o_data1); 

    sss_s.getRange('C1:C2').setValues(o_data2); //optional



  //closes the code until here first

  SpreadsheetApp.flush();

          

  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//

  

  //gets the sheet name from the old sheet

  var o_ss_n=o_ss.getName();

  //replace with destination Folder ID

  var folder=DriveApp.getFolderById('Folder ID')

  

  //Copy the destination sheet and name it like the old sheet

    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);

    }

}








google-apps-script google-sheets google-drive-sdk







share|improve this question
















CODE IS DONE thx @TheMaster ✔



I'm an absolute novice in the google drive sdk, excuse me.



I'm trying to write a script, which allows many sheets that are identical to updated. Through a Source spreadsheet (with new formatting). Problem is that in the old sheets, values ​​are in there, which must be in the new sheet "Source spreadsheet" (with new formatting) in there. And then again and again with an old sheet reiterate.



Procedure in my mind for the script:





  • go to folder where many sheets are ✔


  • open the first sheet and then always the next ✔


  • take the data from area (A1:A2;C1:C2) ✔


  • take the name of the sheets ✔


  • Copy them into the data in the source spreadsheet in the same place ✔


  • Make a copy of the source spreadsheet ✔


  • Name the source spreadsheet as the old sheet ✔


  • rename it and put it in another folder ✔


I will help, where I can.



current code:






function UPDATE() {

  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSreadSheet, s=Sheet, n=Name//



  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//

  

  //replace it with Folder ID where the old spreadsheets are in

  var folder=DriveApp.getFolderById('Folder ID')

  //takes all files in the folder and sets the variable file

  var files=folder.getFiles();

    while (files.hasNext()) 

    {

  var file = files.next();



  //---TAKE DATA---//



  //replace with source ID

  var o_ss=SpreadsheetApp.open(file); 

  //replace with source Sheet tab name 1 to as much as you want

  var o_s_n1=o_ss.getSheetByName('tab name1');

  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional

  //assign one ore more ranges you want to copy

  var o_range1=o_s_n1.getRange('A1:A2'); 

  var o_range2=o_s_n1.getRange('C1:C2'); //optional

  //Copy the values

  var o_data1=o_range1.getValues();

  var o_data2=o_range2.getValues(); //optional



  //---COPY DATA---//



  //replace with destination ID

  var sss_ss=SpreadsheetApp.openById('destination ID');

  //replace with destination Sheet tab name

  var sss_s=sss_ss.getSheetByName('tab name1');

  //Area where to copy in the new sheet

    sss_s.getRange('A1:A2').setValues(o_data1); 

    sss_s.getRange('C1:C2').setValues(o_data2); //optional



  //closes the code until here first

  SpreadsheetApp.flush();

          

  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//

  

  //gets the sheet name from the old sheet

  var o_ss_n=o_ss.getName();

  //replace with destination Folder ID

  var folder=DriveApp.getFolderById('Folder ID')

  

  //Copy the destination sheet and name it like the old sheet

    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);

    }

}








function UPDATE() {

  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSreadSheet, s=Sheet, n=Name//



  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//

  

  //replace it with Folder ID where the old spreadsheets are in

  var folder=DriveApp.getFolderById('Folder ID')

  //takes all files in the folder and sets the variable file

  var files=folder.getFiles();

    while (files.hasNext()) 

    {

  var file = files.next();



  //---TAKE DATA---//



  //replace with source ID

  var o_ss=SpreadsheetApp.open(file); 

  //replace with source Sheet tab name 1 to as much as you want

  var o_s_n1=o_ss.getSheetByName('tab name1');

  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional

  //assign one ore more ranges you want to copy

  var o_range1=o_s_n1.getRange('A1:A2'); 

  var o_range2=o_s_n1.getRange('C1:C2'); //optional

  //Copy the values

  var o_data1=o_range1.getValues();

  var o_data2=o_range2.getValues(); //optional



  //---COPY DATA---//



  //replace with destination ID

  var sss_ss=SpreadsheetApp.openById('destination ID');

  //replace with destination Sheet tab name

  var sss_s=sss_ss.getSheetByName('tab name1');

  //Area where to copy in the new sheet

    sss_s.getRange('A1:A2').setValues(o_data1); 

    sss_s.getRange('C1:C2').setValues(o_data2); //optional



  //closes the code until here first

  SpreadsheetApp.flush();

          

  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//

  

  //gets the sheet name from the old sheet

  var o_ss_n=o_ss.getName();

  //replace with destination Folder ID

  var folder=DriveApp.getFolderById('Folder ID')

  

  //Copy the destination sheet and name it like the old sheet

    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);

    }

}





function UPDATE() {

  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSreadSheet, s=Sheet, n=Name//



  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//

  

  //replace it with Folder ID where the old spreadsheets are in

  var folder=DriveApp.getFolderById('Folder ID')

  //takes all files in the folder and sets the variable file

  var files=folder.getFiles();

    while (files.hasNext()) 

    {

  var file = files.next();



  //---TAKE DATA---//



  //replace with source ID

  var o_ss=SpreadsheetApp.open(file); 

  //replace with source Sheet tab name 1 to as much as you want

  var o_s_n1=o_ss.getSheetByName('tab name1');

  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional

  //assign one ore more ranges you want to copy

  var o_range1=o_s_n1.getRange('A1:A2'); 

  var o_range2=o_s_n1.getRange('C1:C2'); //optional

  //Copy the values

  var o_data1=o_range1.getValues();

  var o_data2=o_range2.getValues(); //optional



  //---COPY DATA---//



  //replace with destination ID

  var sss_ss=SpreadsheetApp.openById('destination ID');

  //replace with destination Sheet tab name

  var sss_s=sss_ss.getSheetByName('tab name1');

  //Area where to copy in the new sheet

    sss_s.getRange('A1:A2').setValues(o_data1); 

    sss_s.getRange('C1:C2').setValues(o_data2); //optional



  //closes the code until here first

  SpreadsheetApp.flush();

          

  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//

  

  //gets the sheet name from the old sheet

  var o_ss_n=o_ss.getName();

  //replace with destination Folder ID

  var folder=DriveApp.getFolderById('Folder ID')

  

  //Copy the destination sheet and name it like the old sheet

    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);

    }

}





google-apps-script google-sheets google-drive-sdk




google-apps-script google-sheets google-drive-sdk






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Dec 9 '18 at 9:38









Cœur

19.4k10116155




19.4k10116155










asked Nov 24 '18 at 20:46









KillBill_158KillBill_158

114




114













  • Try what you dreamt of and if you run into a specific problem, provide Minimal, Complete, and Verifiable example

    – TheMaster
    Nov 24 '18 at 21:41











  • @TheMaster I have updated my code, I do not get the repeat function, do you still have an idea? Would it be nice to work here with flush ()?

    – KillBill_158
    Nov 28 '18 at 16:49











  • You'll get the folder first > then execute this function you wrote for all the files in the folder inside the while loop. See the first example here

    – TheMaster
    Nov 28 '18 at 19:30













  • @TheMaster Now he takes all the files in a folder and copies them but he does not take the areas from the spreadsheets. what's wrong here? do you have to do that with an array?

    – KillBill_158
    Dec 5 '18 at 18:52











  • @TheMaster The code works, but it does not take the Ranges from the old tables and copies them to the new spreadsheet. where exactly is the error?

    – KillBill_158
    Dec 5 '18 at 20:54



















  • Try what you dreamt of and if you run into a specific problem, provide Minimal, Complete, and Verifiable example

    – TheMaster
    Nov 24 '18 at 21:41











  • @TheMaster I have updated my code, I do not get the repeat function, do you still have an idea? Would it be nice to work here with flush ()?

    – KillBill_158
    Nov 28 '18 at 16:49











  • You'll get the folder first > then execute this function you wrote for all the files in the folder inside the while loop. See the first example here

    – TheMaster
    Nov 28 '18 at 19:30













  • @TheMaster Now he takes all the files in a folder and copies them but he does not take the areas from the spreadsheets. what's wrong here? do you have to do that with an array?

    – KillBill_158
    Dec 5 '18 at 18:52











  • @TheMaster The code works, but it does not take the Ranges from the old tables and copies them to the new spreadsheet. where exactly is the error?

    – KillBill_158
    Dec 5 '18 at 20:54

















Try what you dreamt of and if you run into a specific problem, provide Minimal, Complete, and Verifiable example

– TheMaster
Nov 24 '18 at 21:41





Try what you dreamt of and if you run into a specific problem, provide Minimal, Complete, and Verifiable example

– TheMaster
Nov 24 '18 at 21:41













@TheMaster I have updated my code, I do not get the repeat function, do you still have an idea? Would it be nice to work here with flush ()?

– KillBill_158
Nov 28 '18 at 16:49





@TheMaster I have updated my code, I do not get the repeat function, do you still have an idea? Would it be nice to work here with flush ()?

– KillBill_158
Nov 28 '18 at 16:49













You'll get the folder first > then execute this function you wrote for all the files in the folder inside the while loop. See the first example here

– TheMaster
Nov 28 '18 at 19:30







You'll get the folder first > then execute this function you wrote for all the files in the folder inside the while loop. See the first example here

– TheMaster
Nov 28 '18 at 19:30















@TheMaster Now he takes all the files in a folder and copies them but he does not take the areas from the spreadsheets. what's wrong here? do you have to do that with an array?

– KillBill_158
Dec 5 '18 at 18:52





@TheMaster Now he takes all the files in a folder and copies them but he does not take the areas from the spreadsheets. what's wrong here? do you have to do that with an array?

– KillBill_158
Dec 5 '18 at 18:52













@TheMaster The code works, but it does not take the Ranges from the old tables and copies them to the new spreadsheet. where exactly is the error?

– KillBill_158
Dec 5 '18 at 20:54





@TheMaster The code works, but it does not take the Ranges from the old tables and copies them to the new spreadsheet. where exactly is the error?

– KillBill_158
Dec 5 '18 at 20:54












1 Answer
1






active

oldest

votes


















1














Finally Done thx @TheMaster






function UPDATE() {

  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSpreadSheet, s=Sheet, n=Name//



  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//

  

  //replace it with Folder ID where the old spreadsheets are in

  var folder=DriveApp.getFolderById('Folder ID')

  //takes all files in the folder and sets the variable file

  var files=folder.getFiles();

    while (files.hasNext()) 

    {

  var file = files.next();



  //---TAKE DATA---//



  //replace with source ID

  var o_ss=SpreadsheetApp.open(file); 

  //replace with source Sheet tab name 1 to as much as you want

  var o_s_n1=o_ss.getSheetByName('tab name1');

  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional

  //assign one ore more ranges you want to copy

  var o_range1=o_s_n1.getRange('A1:A2'); 

  var o_range2=o_s_n1.getRange('C1:C2'); //optional

  //Copy the values

  var o_data1=o_range1.getValues();

  var o_data2=o_range2.getValues(); //optional



  //---COPY DATA---//



  //replace with destination ID

  var sss_ss=SpreadsheetApp.openById('destination ID');

  //replace with destination Sheet tab name

  var sss_s=sss_ss.getSheetByName('tab name1');

  //Area where to copy in the new sheet

    sss_s.getRange('A1:A2').setValues(o_data1); 

    sss_s.getRange('C1:C2').setValues(o_data2); //optional



  //closes the code until here first

  SpreadsheetApp.flush();

          

  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//

  

  //gets the sheet name from the old sheet

  var o_ss_n=o_ss.getName();

  //replace with destination Folder ID

  var folder=DriveApp.getFolderById('Folder ID')

  

  //Copy the destination sheet and name it like the old sheet

    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);

    }

}








share|improve this answer


























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53462225%2fupdating-old-formatted-spreadsheets-using-a-reformatted-spreadsheet-that-takes-t%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    1














    Finally Done thx @TheMaster






    function UPDATE() {
    
  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSpreadSheet, s=Sheet, n=Name//
    

    
  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//
    
  
    
  //replace it with Folder ID where the old spreadsheets are in
    
  var folder=DriveApp.getFolderById('Folder ID')
    
  //takes all files in the folder and sets the variable file
    
  var files=folder.getFiles();
    
    while (files.hasNext()) 
    
    {
    
  var file = files.next();
    

    
  //---TAKE DATA---//
    

    
  //replace with source ID
    
  var o_ss=SpreadsheetApp.open(file); 
    
  //replace with source Sheet tab name 1 to as much as you want
    
  var o_s_n1=o_ss.getSheetByName('tab name1');
    
  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional
    
  //assign one ore more ranges you want to copy
    
  var o_range1=o_s_n1.getRange('A1:A2'); 
    
  var o_range2=o_s_n1.getRange('C1:C2'); //optional
    
  //Copy the values
    
  var o_data1=o_range1.getValues();
    
  var o_data2=o_range2.getValues(); //optional
    

    
  //---COPY DATA---//
    

    
  //replace with destination ID
    
  var sss_ss=SpreadsheetApp.openById('destination ID');
    
  //replace with destination Sheet tab name
    
  var sss_s=sss_ss.getSheetByName('tab name1');
    
  //Area where to copy in the new sheet
    
    sss_s.getRange('A1:A2').setValues(o_data1); 
    
    sss_s.getRange('C1:C2').setValues(o_data2); //optional
    

    
  //closes the code until here first
    
  SpreadsheetApp.flush();
    
          
    
  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//
    
  
    
  //gets the sheet name from the old sheet
    
  var o_ss_n=o_ss.getName();
    
  //replace with destination Folder ID
    
  var folder=DriveApp.getFolderById('Folder ID')
    
  
    
  //Copy the destination sheet and name it like the old sheet
    
    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);
    
    }
    
}








    share|improve this answer






























      1














      Finally Done thx @TheMaster






      function UPDATE() {
      
  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSpreadSheet, s=Sheet, n=Name//
      

      
  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//
      
  
      
  //replace it with Folder ID where the old spreadsheets are in
      
  var folder=DriveApp.getFolderById('Folder ID')
      
  //takes all files in the folder and sets the variable file
      
  var files=folder.getFiles();
      
    while (files.hasNext()) 
      
    {
      
  var file = files.next();
      

      
  //---TAKE DATA---//
      

      
  //replace with source ID
      
  var o_ss=SpreadsheetApp.open(file); 
      
  //replace with source Sheet tab name 1 to as much as you want
      
  var o_s_n1=o_ss.getSheetByName('tab name1');
      
  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional
      
  //assign one ore more ranges you want to copy
      
  var o_range1=o_s_n1.getRange('A1:A2'); 
      
  var o_range2=o_s_n1.getRange('C1:C2'); //optional
      
  //Copy the values
      
  var o_data1=o_range1.getValues();
      
  var o_data2=o_range2.getValues(); //optional
      

      
  //---COPY DATA---//
      

      
  //replace with destination ID
      
  var sss_ss=SpreadsheetApp.openById('destination ID');
      
  //replace with destination Sheet tab name
      
  var sss_s=sss_ss.getSheetByName('tab name1');
      
  //Area where to copy in the new sheet
      
    sss_s.getRange('A1:A2').setValues(o_data1); 
      
    sss_s.getRange('C1:C2').setValues(o_data2); //optional
      

      
  //closes the code until here first
      
  SpreadsheetApp.flush();
      
          
      
  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//
      
  
      
  //gets the sheet name from the old sheet
      
  var o_ss_n=o_ss.getName();
      
  //replace with destination Folder ID
      
  var folder=DriveApp.getFolderById('Folder ID')
      
  
      
  //Copy the destination sheet and name it like the old sheet
      
    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);
      
    }
      
}








      share|improve this answer




























        1












        1








        1







        Finally Done thx @TheMaster






        function UPDATE() {
        
  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSpreadSheet, s=Sheet, n=Name//
        

        
  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//
        
  
        
  //replace it with Folder ID where the old spreadsheets are in
        
  var folder=DriveApp.getFolderById('Folder ID')
        
  //takes all files in the folder and sets the variable file
        
  var files=folder.getFiles();
        
    while (files.hasNext()) 
        
    {
        
  var file = files.next();
        

        
  //---TAKE DATA---//
        

        
  //replace with source ID
        
  var o_ss=SpreadsheetApp.open(file); 
        
  //replace with source Sheet tab name 1 to as much as you want
        
  var o_s_n1=o_ss.getSheetByName('tab name1');
        
  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional
        
  //assign one ore more ranges you want to copy
        
  var o_range1=o_s_n1.getRange('A1:A2'); 
        
  var o_range2=o_s_n1.getRange('C1:C2'); //optional
        
  //Copy the values
        
  var o_data1=o_range1.getValues();
        
  var o_data2=o_range2.getValues(); //optional
        

        
  //---COPY DATA---//
        

        
  //replace with destination ID
        
  var sss_ss=SpreadsheetApp.openById('destination ID');
        
  //replace with destination Sheet tab name
        
  var sss_s=sss_ss.getSheetByName('tab name1');
        
  //Area where to copy in the new sheet
        
    sss_s.getRange('A1:A2').setValues(o_data1); 
        
    sss_s.getRange('C1:C2').setValues(o_data2); //optional
        

        
  //closes the code until here first
        
  SpreadsheetApp.flush();
        
          
        
  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//
        
  
        
  //gets the sheet name from the old sheet
        
  var o_ss_n=o_ss.getName();
        
  //replace with destination Folder ID
        
  var folder=DriveApp.getFolderById('Folder ID')
        
  
        
  //Copy the destination sheet and name it like the old sheet
        
    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);
        
    }
        
}








        share|improve this answer















        Finally Done thx @TheMaster






        function UPDATE() {
        
  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSpreadSheet, s=Sheet, n=Name//
        

        
  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//
        
  
        
  //replace it with Folder ID where the old spreadsheets are in
        
  var folder=DriveApp.getFolderById('Folder ID')
        
  //takes all files in the folder and sets the variable file
        
  var files=folder.getFiles();
        
    while (files.hasNext()) 
        
    {
        
  var file = files.next();
        

        
  //---TAKE DATA---//
        

        
  //replace with source ID
        
  var o_ss=SpreadsheetApp.open(file); 
        
  //replace with source Sheet tab name 1 to as much as you want
        
  var o_s_n1=o_ss.getSheetByName('tab name1');
        
  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional
        
  //assign one ore more ranges you want to copy
        
  var o_range1=o_s_n1.getRange('A1:A2'); 
        
  var o_range2=o_s_n1.getRange('C1:C2'); //optional
        
  //Copy the values
        
  var o_data1=o_range1.getValues();
        
  var o_data2=o_range2.getValues(); //optional
        

        
  //---COPY DATA---//
        

        
  //replace with destination ID
        
  var sss_ss=SpreadsheetApp.openById('destination ID');
        
  //replace with destination Sheet tab name
        
  var sss_s=sss_ss.getSheetByName('tab name1');
        
  //Area where to copy in the new sheet
        
    sss_s.getRange('A1:A2').setValues(o_data1); 
        
    sss_s.getRange('C1:C2').setValues(o_data2); //optional
        

        
  //closes the code until here first
        
  SpreadsheetApp.flush();
        
          
        
  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//
        
  
        
  //gets the sheet name from the old sheet
        
  var o_ss_n=o_ss.getName();
        
  //replace with destination Folder ID
        
  var folder=DriveApp.getFolderById('Folder ID')
        
  
        
  //Copy the destination sheet and name it like the old sheet
        
    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);
        
    }
        
}








        function UPDATE() {
        
  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSpreadSheet, s=Sheet, n=Name//
        

        
  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//
        
  
        
  //replace it with Folder ID where the old spreadsheets are in
        
  var folder=DriveApp.getFolderById('Folder ID')
        
  //takes all files in the folder and sets the variable file
        
  var files=folder.getFiles();
        
    while (files.hasNext()) 
        
    {
        
  var file = files.next();
        

        
  //---TAKE DATA---//
        

        
  //replace with source ID
        
  var o_ss=SpreadsheetApp.open(file); 
        
  //replace with source Sheet tab name 1 to as much as you want
        
  var o_s_n1=o_ss.getSheetByName('tab name1');
        
  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional
        
  //assign one ore more ranges you want to copy
        
  var o_range1=o_s_n1.getRange('A1:A2'); 
        
  var o_range2=o_s_n1.getRange('C1:C2'); //optional
        
  //Copy the values
        
  var o_data1=o_range1.getValues();
        
  var o_data2=o_range2.getValues(); //optional
        

        
  //---COPY DATA---//
        

        
  //replace with destination ID
        
  var sss_ss=SpreadsheetApp.openById('destination ID');
        
  //replace with destination Sheet tab name
        
  var sss_s=sss_ss.getSheetByName('tab name1');
        
  //Area where to copy in the new sheet
        
    sss_s.getRange('A1:A2').setValues(o_data1); 
        
    sss_s.getRange('C1:C2').setValues(o_data2); //optional
        

        
  //closes the code until here first
        
  SpreadsheetApp.flush();
        
          
        
  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//
        
  
        
  //gets the sheet name from the old sheet
        
  var o_ss_n=o_ss.getName();
        
  //replace with destination Folder ID
        
  var folder=DriveApp.getFolderById('Folder ID')
        
  
        
  //Copy the destination sheet and name it like the old sheet
        
    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);
        
    }
        
}





        function UPDATE() {
        
  //LEGEND: o=Old, ss=SpreadSheet, sss=SourceSpreadSheet, s=Sheet, n=Name//
        

        
  //---TAKE ALL OLD SPREADSHEEDS FROM FOLDER ---//
        
  
        
  //replace it with Folder ID where the old spreadsheets are in
        
  var folder=DriveApp.getFolderById('Folder ID')
        
  //takes all files in the folder and sets the variable file
        
  var files=folder.getFiles();
        
    while (files.hasNext()) 
        
    {
        
  var file = files.next();
        

        
  //---TAKE DATA---//
        

        
  //replace with source ID
        
  var o_ss=SpreadsheetApp.open(file); 
        
  //replace with source Sheet tab name 1 to as much as you want
        
  var o_s_n1=o_ss.getSheetByName('tab name1');
        
  var o_s_n2=o_ss.getSheetByName('tab name2'); //optional
        
  //assign one ore more ranges you want to copy
        
  var o_range1=o_s_n1.getRange('A1:A2'); 
        
  var o_range2=o_s_n1.getRange('C1:C2'); //optional
        
  //Copy the values
        
  var o_data1=o_range1.getValues();
        
  var o_data2=o_range2.getValues(); //optional
        

        
  //---COPY DATA---//
        

        
  //replace with destination ID
        
  var sss_ss=SpreadsheetApp.openById('destination ID');
        
  //replace with destination Sheet tab name
        
  var sss_s=sss_ss.getSheetByName('tab name1');
        
  //Area where to copy in the new sheet
        
    sss_s.getRange('A1:A2').setValues(o_data1); 
        
    sss_s.getRange('C1:C2').setValues(o_data2); //optional
        

        
  //closes the code until here first
        
  SpreadsheetApp.flush();
        
          
        
  //---DUPLIKATE SOURCE SHEET AND RENAME IT AND PUT IT IN THE DESTINATION FOLDER---//
        
  
        
  //gets the sheet name from the old sheet
        
  var o_ss_n=o_ss.getName();
        
  //replace with destination Folder ID
        
  var folder=DriveApp.getFolderById('Folder ID')
        
  
        
  //Copy the destination sheet and name it like the old sheet
        
    DriveApp.getFileById('destination ID').makeCopy(o_ss_n,folder);
        
    }
        
}






        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited Dec 6 '18 at 15:28

























        answered Dec 6 '18 at 12:06









        KillBill_158KillBill_158

        114




        114
































            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53462225%2fupdating-old-formatted-spreadsheets-using-a-reformatted-spreadsheet-that-takes-t%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            這個網誌中的熱門文章

            Xamarin.form Move up view when keyboard appear

            圖片
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 I'm trying to build a Chat app UI, the idea of the Layout was pretty simple: When the input bar is focused, keyboard show up and "push" up the chat bar, as it's a grid, the ListView will resize to fit the screen: I update the input bar's margin to "push" it up: NSValue result = (NSValue)args.Notification.UserInfo.ObjectForKey(new NSString(UIKeyboard.FrameEndUserInfoKey)); CGSize keyboardSize = result.RectangleFValue.Size; if (Element != null){ Element.Margin = new Thickness(0, 0, 0,keyboardSize.Height); //push the entry up to keyboard height when keyboard is activated } And this is ...
            閱讀完整內容

            Post-Redirect-Get with Spring WebFlux and Thymeleaf

            圖片
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 2 Can someone explain to me how to implement the post-redirect-get pattern in Spring WebFlux and Thymeleaf? What subscribes on the database save method? @GetMapping("/register") public String showRegisterForm(Model model) { model.addAttribute("user", new User()); return "register"; } @PostMapping public String processRegisterForm(@Valid User user, BindingResult bindingResult) { if (bindingResult.hasErrors()) { return "register"; } else { userRepository.save(user); //what subscribes on this? //how to redirect on e.g. "/login"? ...
            閱讀完整內容

            Anylogic : not able to use stopDelay()

            圖片
            -2 I am building a railway station model. I want a train to depart when I click a button. I want to call stopDelay() for that but I am not sure how to do that and from which place. anylogic share | improve this question asked Nov 23 '18 at 10:12 Anupam Singh Anupam Singh 1 Hi Anupam, welcome to SOF. Please check how to ask good questions, see link below. Your question is...
            閱讀完整內容