4MeqWRxj

1function exceltoSheets() {
2  var SOURCE_XLS_FOLDER = '1Sxwt58gv4P4oy6D9g7VMed5RpM3HAH1W';
3  var SHEET_FOLDER = "1jQXYqjwWPyrDOD26H_FrE1gFeg1MF66O";
4  var CSV_TEST = '1caG4vpINez9Weffz1K4fQXqPWV9hURUf';
5
6  var oauthToken = ScriptApp.getOAuthToken(),
7      sourceFolderID = DriveApp.getFolderById(SOURCE_XLS_FOLDER),
8      targetFolderID = DriveApp.getFolderById(SHEET_FOLDER),
9      mimes = [MimeType.MICROSOFT_EXCEL, MimeType.MICROSOFT_EXCEL_LEGACY];
10
11  for (var m = 0; m < mimes.length; m++) {
12    var sourceFiles = sourceFolderID.getFilesByType(mimes[m]);
13
14    while (sourceFiles.hasNext()) {
15       try {
16         var sourceFile = sourceFiles.next();
17         var sourceName = sourceFile.getName().replace(".xlsx","");
18         var sourceNameTC = sourceName + ".csv"
19         var sourceNameDS = "ds_data_import_" + sourceName;
20
21         var fileId = sourceFile.getId(); 
22         var blob = sourceFile.getBlob();
23         var resourceDS = {
24           title: sourceNameDS,
25           mimeType: MimeType.GOOGLE_SHEETS,
26           convert: true,
27           parents: [{id: SHEET_FOLDER}]
28         };
29         var resourceTC = {
30           title: sourceNameTC,
31           mimeType: MimeType.CSV, 
32           convert: true,
33           parents: [{id: CSV_TEST}],
34         };
35
36         Drive.Files.insert(resourceDS, blob);
37         Drive.Files.insert(resourceTC, blob);
38
39       } catch (f) {
40         Logger.log(f.toString());
41       }
42      sourceFile.setTrashed(true);
43    }
44  }
45}