google apps script - Copying selected row to presentation -

-

my goal copy row spreadsheet , merge row data using markers document (ideally google presentation) saves pdf can print.

i have figured out how have selected row copied object, can't life of me figure out how text copied kind of temporary document. have presentation template markers ready go.

here of scripts i've been working with.

function printrepairs() {   var sheet = spreadsheetapp.getactivesheet();   var data = sheet.getdatarange().getvalues();   var row = sheet.getactiveselection();    //prints comma delim string of single row   var row1 = data[1]   logger.log("row #1: " + row1);   var selectedrow = spreadsheetapp.getactiverange().getvalues();    // creates file selected row --doesn't work.   browser.msgbox("the row selected contains: " +selectedrow);     docslist.createfile('temp_row', selectedrow);   copyblob(selectedrow);    var folder = docslist.getfolder('temp');   folder.createfile('temp_row', 'hello', 'application/vnd.google-apps.document');    doc = documentapp.create("sheet_test");   documentapp.openbyid("sheet_test");   text.inserttext("sheet_test", selectedrow);    browser.msgbox("the row selected contains: " +selectedrow);   logger.log("the row selected contains: " + selectedrow);   }

the operation you're performing commonly called "mail merge" . there google docs add-ons can - google doc go "add-ons > add-ons" , search "merge".

to same own script, recommend first familiar material in simple mail merge tutorial. instead of building email template in spreadsheet, you'll create new document document template.

  1. create google doc template, markers match column headers in spreadsheet.

    i have presentation template markers ready go.

    unfortunately, there's no support presentations (yet). star issue 1573: presentation service google apps script. (maybe vote 1 gets done!)

  2. for each row in spreadsheet...

    1. create copy of template doc. driveapp.makecopy(name, destination). should use unique name each file, if don't you'll end multiple files same name on drive.
    2. use fileid of new file, , open document. documentapp.openbyid(id)
    3. using technique similar this, this or this, search through document markers, , replace data spreadsheet.

Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more