Styjun

How does proof assistant organize knowledge?

How to remove ambiguity: "... lives in the city of H, the capital of the province of NS, WHERE the unemployment rate is ..."?

Is this curved text blend possible in Illustrator?

Annotating a table with arrows

What ability do tools use?

how do companies get money from being listed publicly

Are employers legally allowed to pay employees in goods and services equal to or greater than the minimum wage?

Does fossil fuels use since 1990 account for half of all the fossil fuels used in history?

What should I call bands of armed men in the Middle Ages?

If clocks themselves are based on light signals, wouldn't we expect the measured speed of light to always be the same constant?

Not going forward with internship interview process

First amendment and employment: Can a police department terminate an officer for speech?

Is there a SQL/english like language that lets you define formulations given some data?

Loading military units into ships optimally, using backtracking

Solution to German Tank Problem

How far did Gandalf and the Balrog drop from the bridge in Moria?

Markov-chain sentence generator in Python

Plotting octahedron inside the sphere and sphere inside the cube

TEMPO: play a sound in animated GIF/PDF/SVG

Is it legal for a company to enter an agreement not to hire employees from another company?

Do beef farmed pastures net remove carbon emissions?

Is it okay for a ticket seller in the USA to refuse to give you your change, keep it for themselves and claim it's a tip?

Super Duper Vdd stiffening required on 555 timer, what is the best way?

How much maintenance time did it take to make an F4U Corsair ready for another flight?

Generate and download pdf file using google apps script to local PC

General assistance in Google Apps scripting“e” undefined Google Script errorExport (or print) with a google script new version of google spreadsheets to pdf file, using pdf optionsDownload “automatically” spreadsheet as .xlsx to local machine on eventApp Script Hyperlink Download PDFGoogle Apps Script to Open copy of Google Sheet in new windowGoogle Script opening PDF after exportingDownload generated XML with Google Apps ScriptHow to read a time in googlespreadsheet with google apps script?Combining two scripts into a google sheets addon

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I wrote a Google Apps script in a Spreadsheet that convert the Spreadsheet to pdf. This works.
How can I copy this generated pdf file automatically using the same script to PC's local folder (Desktop f.e.)

Code.gs

function onOpen() 
 var submenu = [name:"Save PDF", functionName:"generatePdf"];
 SpreadsheetApp.getActiveSpreadsheet().addMenu('Export', submenu);


function generatePdf() 
 var sourceSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
 var pdfName = Browser.inputBox("Name of generated pdf");
 var save2folder = DriveApp.getRootFolder();
 var theBlob = sourceSpreadsheet.getBlob().getAs('application/pdf').setName(pdfName);
 var pdfFile = save2folder.createFile(theBlob);

 

Thanks

google-apps-script

share|improve this question

asked Mar 27 at 8:48

major Kalinamajor Kalina

111 bronze badge

add a comment | 

0

I wrote a Google Apps script in a Spreadsheet that convert the Spreadsheet to pdf. This works.
How can I copy this generated pdf file automatically using the same script to PC's local folder (Desktop f.e.)

Code.gs

function onOpen() 
 var submenu = [name:"Save PDF", functionName:"generatePdf"];
 SpreadsheetApp.getActiveSpreadsheet().addMenu('Export', submenu);


function generatePdf() 
 var sourceSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
 var pdfName = Browser.inputBox("Name of generated pdf");
 var save2folder = DriveApp.getRootFolder();
 var theBlob = sourceSpreadsheet.getBlob().getAs('application/pdf').setName(pdfName);
 var pdfFile = save2folder.createFile(theBlob);

 

Thanks

google-apps-script

share|improve this question

asked Mar 27 at 8:48

major Kalinamajor Kalina

111 bronze badge

add a comment | 

I wrote a Google Apps script in a Spreadsheet that convert the Spreadsheet to pdf. This works.
How can I copy this generated pdf file automatically using the same script to PC's local folder (Desktop f.e.)

Code.gs

function onOpen() 
 var submenu = [name:"Save PDF", functionName:"generatePdf"];
 SpreadsheetApp.getActiveSpreadsheet().addMenu('Export', submenu);


function generatePdf() 
 var sourceSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
 var pdfName = Browser.inputBox("Name of generated pdf");
 var save2folder = DriveApp.getRootFolder();
 var theBlob = sourceSpreadsheet.getBlob().getAs('application/pdf').setName(pdfName);
 var pdfFile = save2folder.createFile(theBlob);

 

Thanks

google-apps-script

share|improve this question

asked Mar 27 at 8:48

major Kalinamajor Kalina

111 bronze badge

function onOpen() 
 var submenu = [name:"Save PDF", functionName:"generatePdf"];
 SpreadsheetApp.getActiveSpreadsheet().addMenu('Export', submenu);


function generatePdf() 
 var sourceSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
 var pdfName = Browser.inputBox("Name of generated pdf");
 var save2folder = DriveApp.getRootFolder();
 var theBlob = sourceSpreadsheet.getBlob().getAs('application/pdf').setName(pdfName);
 var pdfFile = save2folder.createFile(theBlob);

 

function onOpen() 
 var submenu = [name:"Save PDF", functionName:"generatePdf"];
 SpreadsheetApp.getActiveSpreadsheet().addMenu('Export', submenu);


function generatePdf() 
 var sourceSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
 var pdfName = Browser.inputBox("Name of generated pdf");
 var save2folder = DriveApp.getRootFolder();
 var theBlob = sourceSpreadsheet.getBlob().getAs('application/pdf').setName(pdfName);
 var pdfFile = save2folder.createFile(theBlob);

 

function onOpen() 
 var submenu = [name:"Save PDF", functionName:"generatePdf"];
 SpreadsheetApp.getActiveSpreadsheet().addMenu('Export', submenu);


function generatePdf() 
 var sourceSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
 var pdfName = Browser.inputBox("Name of generated pdf");
 var save2folder = DriveApp.getRootFolder();
 var theBlob = sourceSpreadsheet.getBlob().getAs('application/pdf').setName(pdfName);
 var pdfFile = save2folder.createFile(theBlob);

 

share|improve this question

asked Mar 27 at 8:48

major Kalinamajor Kalina

111 bronze badge

share|improve this question

asked Mar 27 at 8:48

major Kalinamajor Kalina

111 bronze badge

asked Mar 27 at 8:48

major Kalinamajor Kalina

111 bronze badge

asked Mar 27 at 8:48

major Kalinamajor Kalina

111 bronze badge