function convertRangeToCsvFile(sheet) {
var activeRange=sheet.getDataRange();
var data=activeRange.getValues();
if (data.length>1) {
var csv="";
for(var row=0;row<data.length;row++) {
for (var col=0;col<data[row].length; col++) {
if (data[row][col].toString().indexOf(",") != -1) {
data[row][col]="\"" + data[row][col] + "\"";
}
}
if (row<data.length-1){csv += data[row].join(",") + "\r\n";
}else {csv += data[row];}
}
var testfiles = DriveApp.getFilesByName('testfile.csv');
while (testfiles.hasNext()) {
var testfile = testfiles.next();
}
testfile.setContent(csv);
}
return testfile.getId();
}