Needs to add Range (Google App Script)

[shabby01]

I have been trying to add range of Invoice sheet, which PDF i have required in below the code can someone please help me in this regards.

[vba_php]

your description is vague. you want to use the range class? or you want to select a RANGE on a sheet?

https://developers.google.com/apps-s...eadsheet/range

[shabby01]

My purpose is to add the range in the code to just convert the given range into PDF instead of whole sheet.

[vba_php]

i don't develop in goog sheets so I wouldn't have the time to look that up for you. I would assume you can, however it is not going to be as simple for you as just one single statement that has been created by the goog developers. and you won't find it in the documentation either.

[Haluk]

Basically, you need to do the following in your script;

1) Create a temporary sheet,

2) Transfer the related range of data (A1:K33) to this temporary sheet,

3) Export the temporary sheet as PDF,

4) Send the temporary sheet to "Trash",