JavaScript How can I output the contents of a scripted array in a google sheets?

I'm a totally new to coding and Google App script, so I humbly ask my question.

I have look all over the place for an answer to this problem and can't seem to find a way to solve it.

Below is my code that gets data from Google Sheets based on their IDs. I can bring the data in and add for 4 sheets and from a particular range.

The script successfully stores the data in an array(arr).

The script sends the data the size of the original import range to the active sheet.

But, how can I output all of the data I can see logged in the array (arr)? I've tried changing the range size of the output, but to no avail, it just causes and error.

   function GetData() {
        var classes = ["1XN9NPs_irdpVBEuy0saY-m_PjMW8BxIOgvLkaekdMXo",     
        "1XN9NPs_irdpVBEuy0saY-m_PjMW8BxIOgvLkaekdMXo", 
        "11Pdsixi17YjtePg4L780mtGkElWU7TUmshYtJnzxbMU", 
        "11y8ILVN3lTCWaQYr0nhLdDdLsDDoRqcR2BHz42leUbI"];
        var ui = SpreadsheetApp.getUi();

    for (var j = 0; j < classes.length; j++) {
        var exSs = SpreadsheetApp.openById(classes[j]);        
        var exSheet = exSs.getSheetByName("tastodolist");
        var range = "A4:F10"
        var exRange = exSheet.getRange(range);
        var values = exRange.getValues();
        var arr = [];
        arr.push(values);

        for (var i = 0; i < arr.length; i++) {

         //The log contains all the data that is needed. 
            Logger.log(arr[i]);

        }
        //I'm struggling to get all of the logged data into the active            
        sheet - my code can only output 7 rows of data. 

       SpreadsheetApp.getActiveSheet().getRange(1,1,7,6).setValues(arr[i]);


    }
}
Answer:1

i am trying to check if an url is online. I use the $new_url for the url that the user gives. The problem that i face is that i always take a 404 either the url is online either not... <?php ...

i am trying to check if an url is online. I use the $new_url for the url that the user gives. The problem that i face is that i always take a 404 either the url is online either not... <?php ...

  1. ajax check username exists
  2. ajax check file exists
  3. ajax check url exists
  4. ajax check image exists
  5. ajax check user exists
  6. ajax check if file exists
  7. ajax check if username exists
  8. ajax check if data exists
  9. ajax check if url exists
  10. ajax check if email exists in database
  11. ajax check if value exists in database
  12. ajax check if element exists
  13. ajax check if file exists on server
  14. ajax check if image exists
  15. ajax check if id exists
  16. ajax check if class exists
  17. ajax check if record exists
  18. ajax check if page exists
  19. ajax check if session exists
  20. ajax check if div exists

I am trying to limit the number of checkboxes a user can select. These checkboxes are DOM input objects generated for each item in an array. I'm having no luck with this currently, so any help is ...

I am trying to limit the number of checkboxes a user can select. These checkboxes are DOM input objects generated for each item in an array. I'm having no luck with this currently, so any help is ...

I'm working on a web app which implements a wizard-like behavior. it uses an API to get the "wizard" steps. the API works in a way where you send a request with the current step and all previous ...

I'm working on a web app which implements a wizard-like behavior. it uses an API to get the "wizard" steps. the API works in a way where you send a request with the current step and all previous ...

  1. angular router dynamic path
  2. angular router dynamic routes
  3. angular router dynamic data
  4. angular router dynamic component
  5. angular router dynamic redirect
  6. angular router dynamic
  7. angular router dynamic parameters
  8. angular router dynamic redirectto
  9. angular router dynamic url
  10. angular router dynamic link
  11. angular routing dynamic url
  12. angular routing dynamic
  13. angular routing dynamic path
  14. angular routing dynamic component
  15. angular routing dynamic data
  16. angular routing dynamic parameter
  17. angular routing dynamic template
  18. angular dynamic router outlet
  19. angular dynamic router outlet name
  20. angular dynamic router module

I am using modal window for the upload of images. But when click on upload I want to upload the images and then close the modal window. When I used data-dismiss="modal" as attribute in button it just ...

I am using modal window for the upload of images. But when click on upload I want to upload the images and then close the modal window. When I used data-dismiss="modal" as attribute in button it just ...

  1. close bootstrap modal with javascript
  2. close bootstrap modal jquery
  3. close bootstrap modal programmatically
  4. close bootstrap modal on submit
  5. close bootstrap modal on button click
  6. close bootstrap modal angular
  7. close bootstrap modal without jquery
  8. close bootstrap modal typescript
  9. close bootstrap modal on click outside
  10. close bootstrap modal in angular 7
  11. close bootstrap modal on click
  12. close bootstrap modal vuejs
  13. close bootstrap modal in react
  14. close bootstrap modal escape key
  15. close bootstrap modal angular 8
  16. close bootstrap modal on ajax success
  17. close bootstrap modal after ajax success
  18. close bootstrap modal automatically
  19. close bootstrap modal after save
  20. close bootstrap modal from angular component