User Tools

Site Tools


email-import-vcards
 //email-import-vcards
 function removeColumns() {
   var sheet = SpreadsheetApp.getActiveSheet();
   var data = sheet.getDataRange().getValues();
   var newData = [];
   for(i in data){
   var column1 = [data[i][0]];
   var column2 = [data[i][2]];
   var column3 = [data[i][14]];
   newData.push(column1.concat(column2,column3));
   }
   sheet.clearContents();
   sheet.getRange(1, 1, newData.length, newData[0].length).setValues(newData);
   removeRow();
   }
   
 function onOpen() {
   var ui = SpreadsheetApp.getUi();
   // Or DocumentApp or FormApp.
   ui.createMenu('Cleanup contacts')
       .addItem('Run this on imported vcard data only!', 'removeColumns')
       .addToUi();  
 }
email-import-vcards.txt · Last modified: 2017/03/08 03:19 by pete