Google电子表格列导出为CSV [英] Google Spreadsheets columns export to CSV
本文介绍了Google电子表格列导出为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屋!
查看全文