Replace custom CSV file with another CSV file in Google drive using Google scripts

Question

I would like to replace a csv file that contains one value at cell A1 with a new csv file that contains again one value at cell A1, but a different value. The following code successfuly creates what I want, but it does not replace the current csv file, it just creates new ones and I end up with many files in the google drive. What can I do to just replace it? Thanks a lot

function replace() {
      var str = "test";
      var folder = DriveApp.getFolderById("folderID");
      var fileName = "add-list.csv";
      var csvFile = str;
      var file = folder.getFilesByName(fileName)
      
     folder.createFile(fileName, csvFile);

}

Marios · Accepted Answer · 2020-08-16 07:49:13Z

1

You are very close. Before you replace the target csv file, you need to see whether it exists or not.

function replace() {
      var str = "test";
      var folder = DriveApp.getFolderById("folderId");
      var fileName = "add-list.csv";
      var csvFile = str;
      var file = folder.getFilesByName(fileName)
      
      if (file.hasNext()){
     file.next().setTrashed(true) }
     folder.createFile(fileName, csvFile);
    
    }

Explanation:

if (file.hasNext()){
         file.next().setTrashed(true) }
         folder.createFile(fileName, csvFile);

This will check if the file exists. If it does, then it will replace it, otherwise it will create a new one.

answered Aug 16, 2020 at 7:49

Marios

27.5k9 gold badges40 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tanaike Over a year ago

As another method, how about adding the modification from folder.createFile(fileName, csvFile) to if (file.hasNext()) file.next().setContent(str), if OP needs the revisions?

Collectives™ on Stack Overflow

Replace custom CSV file with another CSV file in Google drive using Google scripts

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related