save document to pdf

[Angelo Malfitano]

Hi,

I tried to save spreadsheet to PDF but PDF didn't kept the borders and margins. I use this script: 

I want to save the same file with the same margins. 

folder: 

https://drive.google.com/drive/folders/1LdgeKskgoznRqndIdgjAWYY6ppuYYx-x

function create(){

    var folder = DriveApp.getFolderById('1LdgeKskgoznRqndIdgjAWYY6ppuYYx-x');

    var sourceSpreadsheet = SpreadsheetApp.getActive();

    var destSpreadsheet = SpreadsheetApp.open(DriveApp.getFileById(sourceSpreadsheet.getId()).makeCopy("tmp_convert_to_pdf", folder))

    var new_imo = destSpreadsheet.getBlob().getAs('application/pdf').setName('helloPDF');

    var newFile = folder.createFile(new_imo);

  DriveApp.getFileById(destSpreadsheet.getId()).setTrashed(true);

}

Thank for help

Angelo

[Marcos Gomes]

Try this

https://gist.github.com/Spencer-Easton/78f9867a691e549c9c70  

Greetings and success in the project

On Fri, Feb 28, 2020 at 9:38 AM Angelo Malfitano <angelo.ma...@gmail.com> wrote:

Hi,

I tried to save spreadsheet to PDF but PDF didn't kept the borders and margins. I use this script: 

function create(){

    var folder = DriveApp.getFolderById('1LdgeKskgoznRqndIdgjAWYY6ppuYYx-x');

    var sourceSpreadsheet = SpreadsheetApp.getActive();

    var destSpreadsheet = SpreadsheetApp.open(DriveApp.getFileById(sourceSpreadsheet.getId()).makeCopy("tmp_convert_to_pdf", folder))

    var new_imo = destSpreadsheet.getBlob().getAs('application/pdf').setName('helloPDF');

    var newFile = folder.createFile(new_imo);

  DriveApp.getFileById(destSpreadsheet.getId()).setTrashed(true);

}

Thank for help

Angelo

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/d0a79fad-347b-403c-8019-e66b4edf1202%40googlegroups.com.

[Angelo Malfitano]

Hi Marcos,

thank you for you help.

I tried with your suggestion but new file PDF like as last one. :(

I want to remove blank space. 

Thank you for your help.

Angelo

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CANA%3DMHvgG6HpizH4M1Dwvk--kv69m1vRP3ZPCdU8rpigxfw6kA%40mail.gmail.com.

[Angelo Malfitano]

Hi,

I solve add this code: 

"top_margin=0.2&left_margin=0.2&right_margin=0.2&bottom_margin=0.2&"+

Thank you for your help

Angelo

[Marcos Gomes]

Try to understand the parameters:

fitw

//r1=Start Row number - 1        row 1 would be 0 , row 15 wold be 14
//c1=Start Column number - 1     column 1 would be 0, column 8 would be 7  
//r2=End Row number
//c2=End Column number

good luck!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CABTxurNoX0H50KM6JTxi_mrSzj2ywTRhbLy5q1fS%2B8YGtC%3DvAg%40mail.gmail.com.