Advertisement
Guest User

Untitled

a guest
Feb 6th, 2016
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.82 KB | None | 0 0
  1. function printPdf() {
  2. SpreadsheetApp.flush();
  3. var ss = SpreadsheetApp.getActiveSpreadsheet();
  4. var sheet = ss.getActiveSheet();
  5.  
  6.  
  7. var gid = sheet.getSheetId();
  8.  
  9.  
  10. var pdfOpts = '&size=A4&fzr=false&portrait=false&fitw=true&gridlines=false&printtitle=false&sheetnames=false&pagenum=UNDEFINED&attachment=false&gid='+gid;
  11. var last_row = sheet.getLastRow();
  12. var printRange = '&c1=0' + '&r1=0' + '&c2=34' + '&r2='+last_row // B2:APn
  13. var url = ss.getUrl().replace(/edit$/, '') + 'export?format=pdf' + pdfOpts + printRange;
  14.  
  15. var app = UiApp.createApplication().setWidth(200).setHeight(50);
  16. app.setTitle('Verze pro tisk');
  17.  
  18. var link = app.createAnchor('Zobrazit PDF', url).setTarget('_new');
  19.  
  20. app.add(link);
  21.  
  22. ss.show(app);
  23.  
  24. }
  25.  
  26. function printPDF() {
  27. var ss = SpreadsheetApp.getActiveSpreadsheet();
  28. var sheet = SpreadsheetApp.getActiveSheet();
  29. var cols = [2, 3, 4, 5, 7]; // columns to print
  30. var lastRow = sheet.getLastRow();
  31. var newSs = SpreadsheetApp.create(ss.getName() + ' for print', lastRow, cols.length);
  32. var newSheet = newSs.getSheets()[0];
  33. for (var i = 0; i < cols.length; i++) {
  34. var values = sheet.getRange(1, cols[i], lastRow, 1).getValues();
  35. newSheet.getRange(1, i + 1, lastRow, 1).setValues(values);
  36. }
  37. SpreadsheetApp.flush();
  38.  
  39. // copied from your code, including deprecated UiApp
  40. var pdfOpts = '&size=A4&fzr=false&portrait=false&fitw=true&gridlines=false&printtitle=false&sheetnames=false&pagenum=UNDEFINED&attachment=false&gid=0';
  41. var url = newSs.getUrl().replace(/edit$/, '') + 'export?format=pdf' + pdfOpts;
  42. var app = UiApp.createApplication().setWidth(200).setHeight(50);
  43. app.setTitle('Print Version');
  44. var link = app.createAnchor('Show PDF', url).setTarget('_new');
  45. app.add(link);
  46. ss.show(app);
  47. // End of copy
  48.  
  49. DriveApp.getFileById(newSs.getId()).setTrashed(true); // delete temp file
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement