Sheets - Script - Limit number of rows imported from a CSV using a script?

user_12181850 0
Viewed 264

I've got a script that's importing a CSV from a location on G-Drive - I just need it to import the first 300 rows, as opposed to all 2000 rows. What am I missing?

function importCSVFromGoogleDrive() {

  var fSource = DriveApp.getFolderById('xxxxxxxxxxxx'); // reports_folder_id = id of folder where csv is saved
  var file = DriveApp.getFilesByName("content.csv").next();
  var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);

}
google-apps-script google-sheets
1 Answers

First 300 lines of csv file

function importCSVFromGoogleDrive() {
  var folder = DriveApp.getFolderById('xxxxxxxxxxxx'); 
  var files = folder.getFilesByName("content.csv");
  var n=0;
  while(files.hasNext()) {
    var file=files.next();
    n++;
  }
  if(n==1) {
    var csvData = Utilities.parseCsv(file.getBlob().getDataAsString()).slice(0,300);
    SpreadsheetApp.getActiveSheet().getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
  }else{
    SpreadsheetApp.getUi().alert("More Than One File with that name");
  }
}

Array.slice()

I tested with a csv file of my own.

user_72150910
Related