How to get the size of the Blob object in Google Apps script?

Question

I have created a script where in Google Sheet is converted to PDF and sent in an email (via Gmail API).

Please find the below syntax which is used to convert sheet to PDF

var blob=DriveApp.getFileById(<<Google Sheet ID>>).getAs('application/pdf');

what can be done to find out the size of the blob here?

score 7 · Accepted Answer · answered Jun 26 '20 at 17:03

7

Blob has getBytes() method, which returns a byte array.

Size of the blob(in bytes) = byte array's length

const size = blob.getBytes().length;

answered Jun 26 '20 at 17:03

TheMaster

Note that getBytes() has a size limit, so this wont work for very large files – nwaltham Aug 18 '20 at 08:20
@nwaltham Do you know the limit? I haven't heard any such thing till now. – TheMaster Aug 18 '20 at 10:02
@nwaltham Related: https://stackoverflow.com/questions/60181888/google-apps-script-get-range-of-bytes-from-binary-file/60182078?noredirect=1#comment112261635_60182078 – TheMaster Aug 19 '20 at 12:01

ag-dev · Answer 2 · 2020-06-26T16:48:43.293

3

Just do it like this :

var sizeInBytes = blob.size

edited Jun 26 '20 at 16:48

answered Jun 26 '20 at 16:24

ag-dev

score 1 · Answer 3 · edited Oct 31 '22 at 18:40

1

Have you tried

var sizeInBytes = blob.size

edited Oct 31 '22 at 18:40

Saeed

answered Jun 26 '20 at 16:25

Dhruv Shah

3 Answers3