Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function ConvertToTSV(sheet) {
- var ws = sheet.getDataRange();
- try {
- var data = ws.getValues();
- // Loop through the data in the range and build a string with the TSV data
- var csv = "";
- for (var row = 0; row < data.length; row++) {
- // Join each row's columns
- // Add a carriage return to end of each row
- csv += data[row].join("\t") + "\r\n";
- }
- return csv;
- }
- catch(err) {
- Logger.log(err);
- Browser.msgBox(err);
- }
- }
- function BulkTSVExport() {
- var myFolder = DriveApp.createFolder(SpreadsheetApp.getActiveSpreadsheet().getName());
- var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
- for (var i = 0; i < sheets.length; i++) {
- var csv = ConvertToTSV(sheets[i]);
- myFolder.createFile(sheets[i].getName() + ".tsv", csv);
- }
- }
- function TSVExport() {
- var sheet = SpreadsheetApp.getActiveSheet();
- var csv = ConvertToTSV(sheet);
- DriveApp.createFile(sheet.getName() + ".tsv", csv);
- }
- function onOpen() {
- var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
- var entries = [
- {name : "Export Current Sheet to TSV", functionName : "TSVExport"},
- {name : "Export All Sheets to TSV", functionName : "BulkTSVExport"}
- ];
- spreadsheet.addMenu("TSV", entries);
- }
Add Comment
Please, Sign In to add comment