Google电子表格列导出为CSV [英] Google Spreadsheets columns export to CSV

问题描述

我想从Google试算表自动建立csv档案（点击按钮后）。
但是我不想导出整个电子表格，只是几个列。
我该如何做？

I would like to create csv file from Google spreadsheet automatically (after clicking button). But I don't want to export whole spreadsheet but just few columns. How can I do this?

例如。电子表格有8列，我想导出前三个到csv与值如：column1 value; column2 value; column3 value; column1 value; column2 value; ...

eg. spreadsheets has 8 columns and I would like to export first three to csv with values like: "column1 value; column2 value; column3 value; column1 value; column2 value; ... "

谢谢

推荐答案

这里你去：（你需要发布，如果你想它工作）您正在进行的选择

here you go: (you need to publish that if you want it to work) it will export the selection that you are making

function onOpen() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var entries = [{
    name : "make CSV",
    functionName : "myFunction"
  }];
  spreadsheet.addMenu("Script Center Menu", entries);
};
function myFunction() {
  var a1 = SpreadsheetApp.getActiveRange().getA1Notation();
  var url = ScriptApp.getService().getUrl()+"?ref="+a1+"&sheet="+SpreadsheetApp.getActiveSheet().getName()+"&ssid="+SpreadsheetApp.getActive().getId();
  var vals = SpreadsheetApp.getActiveRange().getValues();
  var html = "here the download Link <a href='"+url+"' >"+url+"</a>";
  //SpreadsheetApp.getActive().show(HtmlService.createHtmlOutput(html)); // ol sheet style
  SpreadsheetApp.getUi().showModalDialog(HtmlService.createHtmlOutput(html), 'download box'); // new sheet style
}


function doGet(e){
  var ref = e.parameter.ref;
  var sheet = e.parameter.sheet;
  var ssid = e.parameter.ssid;
  var out = ContentService.createTextOutput(SpreadsheetApp.openById(ssid).getSheetByName(sheet).getRange(ref).getValues().join("\n")).downloadAsFile("out.csv");
  return out;
}

这篇关于Google电子表格列导出为CSV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！