Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function printPdf() {
- SpreadsheetApp.flush();
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheet = ss.getActiveSheet();
- var gid = sheet.getSheetId();
- var pdfOpts = '&size=A4&fzr=false&portrait=false&fitw=true&gridlines=false&printtitle=false&sheetnames=false&pagenum=UNDEFINED&attachment=false&gid='+gid;
- var last_row = sheet.getLastRow();
- var printRange = '&c1=0' + '&r1=0' + '&c2=34' + '&r2='+last_row // B2:APn
- var url = ss.getUrl().replace(/edit$/, '') + 'export?format=pdf' + pdfOpts + printRange;
- var app = UiApp.createApplication().setWidth(200).setHeight(50);
- app.setTitle('Verze pro tisk');
- var link = app.createAnchor('Zobrazit PDF', url).setTarget('_new');
- app.add(link);
- ss.show(app);
- }
- function printPDF() {
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheet = SpreadsheetApp.getActiveSheet();
- var cols = [2, 3, 4, 5, 7]; // columns to print
- var lastRow = sheet.getLastRow();
- var newSs = SpreadsheetApp.create(ss.getName() + ' for print', lastRow, cols.length);
- var newSheet = newSs.getSheets()[0];
- for (var i = 0; i < cols.length; i++) {
- var values = sheet.getRange(1, cols[i], lastRow, 1).getValues();
- newSheet.getRange(1, i + 1, lastRow, 1).setValues(values);
- }
- SpreadsheetApp.flush();
- // copied from your code, including deprecated UiApp
- var pdfOpts = '&size=A4&fzr=false&portrait=false&fitw=true&gridlines=false&printtitle=false&sheetnames=false&pagenum=UNDEFINED&attachment=false&gid=0';
- var url = newSs.getUrl().replace(/edit$/, '') + 'export?format=pdf' + pdfOpts;
- var app = UiApp.createApplication().setWidth(200).setHeight(50);
- app.setTitle('Print Version');
- var link = app.createAnchor('Show PDF', url).setTarget('_new');
- app.add(link);
- ss.show(app);
- // End of copy
- DriveApp.getFileById(newSs.getId()).setTrashed(true); // delete temp file
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement