首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >如何按所选列将google sheet导出为CSV

如何按所选列将google sheet导出为CSV
EN

Stack Overflow用户
提问于 2018-06-09 00:01:41
回答 1查看 5.8K关注 0票数 2

我有一个谷歌工作表要导出为CSV文件。但是工作表中有两列我不想导出。例如,在图片column中,我不想导出列"N“和"P”这里是我为导出而编写的应用程序脚本代码

代码语言:javascript
复制
function menu() {
 var ui = SpreadsheetApp.getUi();
 var menu = ui.createMenu('Menu');
 var item = menu.addItem('PICC', 'picc');
 var item2 = menu.addItem('Export to CSV', 'csv');
 item.addToUi();
 item2.addToUi()
 };

 function onOpen() {
   var ss = SpreadsheetApp.getActiveSpreadsheet();
   var csvMenuEntries = [{name: "Download Primary Time File", functionName: "saveAsCSV"}];
  //ss.addMenu("Creating a Timetable", csvMenuEntries);

  var ui = SpreadsheetApp.getUi();
  var menu = ui.createMenu('Menu');
  var item = menu.addItem('PICC', 'picc');
  var item2 = menu.addItem('Export to CSV', 'csv');
  item.addToUi();
  item2.addToUi()
  };

  function saveAsCSV() {
    var ss = SpreadsheetApp.getActiveSpreadsheet(); 
    var sheet = ss.getSheetByName("sheet1");
  // create a folder from the name of the spreadsheet
    var folder = DriveApp.createFolder(ss.getName().toLowerCase().replace(/ /g,'_') + '_csv_' + new Date().getTime());
  // append ".csv" extension to the sheet name
     fileName = sheet.getName() + ".csv";
  // convert all available sheet data to csv format
     var csvFile = convertRangeToCsvFile_(fileName, sheet);
  // create a file in the Docs List with the given name and the csv data
     var file = folder.createFile(fileName, csvFile);
  //File downlaod
    var downloadURL = file.getDownloadUrl().slice(0, -8);
    showurl(downloadURL);

   }

   function showurl(downloadURL) {
     var app = UiApp.createApplication().setHeight('60').setWidth('150');
    //Change what the popup says here
     app.setTitle("Your timetable CSV is ready!");
     var panel = app.createPopupPanel()
     //Change what the download button says here
     var link = app.createAnchor('Click here to download', downloadURL);
     panel.add(link);
     app.add(panel);
     var doc = SpreadsheetApp.getActive();
     doc.show(app);
     }

     function convertRangeToCsvFile_(csvFileName, sheet) {
     // get available data range in the spreadsheet
     var activeRange = sheet.getDataRange();
     try {
           var data = activeRange.getValues();
           var csvFile = undefined;

     // loop through the data in the range and build a string with the csv data
        if (data.length > 1) {
            var csv = "";
        for (var row = 1; 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] + "\"";
          }
         }

         // join each row's columns
         // add a carriage return to end of each row, except for the last one
        if (row < data.length-1) {
           csv += data[row].join(",") + "\r\n";
         }
            else {
               csv += data[row];
               }
         }
            csvFile = csv;
       }
       return csvFile;
      }
         catch(err) {
         Logger.log(err);
         Browser.msgBox(err);
      }
    }

正如您所看到的,我使用for循环来导出行和列,如何进行更改才能使这两列不显示在导出CSV中

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2018-06-09 07:24:18

这个修改怎么样?

修改点:

  • 修改convertRangeToCsvFile_()
    • datagetValues()检索,它删除列"N“和

为了反映这一点,请修改如下。

发自:

代码语言:javascript
复制
var data = activeRange.getValues();
var csvFile = undefined;

至:

代码语言:javascript
复制
var data = activeRange.getValues();
data = data.map(function(e){return e.filter(function(_, i){return i != 13 && i != 15})}); // Added
var csvFile = undefined;

如果我误解了你的问题,请告诉我。我想修改一下。

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/50764458

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档