How to export Specific Worksheet In Google sheets to PDF

Поделиться
HTML-код
  • Опубликовано: 1 ноя 2024

Комментарии • 19

  • @KDevi-d4y
    @KDevi-d4y 2 месяца назад

    Thank you. This video is very useful. But I could not generate PDF in A4 Landscape. Please advice

  • @GoodwillParamount
    @GoodwillParamount Месяц назад

    Hi, can I know how to get the name of the file to be named as certain cell in the spreadsheet
    ?

  • @sheesh772
    @sheesh772 Год назад

    very informative and well explained,thanks,, but when i tried it in mobile using a onEdit function as a trigger,it has an error in the lines of "getfolderbyid" it says no permission,,any way posible to execute this script in mobile or tab? bcoz clickable image is not working on mobile and onEdit has error in getfolderbyid, thanks in advance

    • @AutomationMadeEasy
      @AutomationMadeEasy  Год назад

      does this work from desktop? or you are having same issue when you execute from desktop too

    • @sheesh772
      @sheesh772 Год назад

      @@AutomationMadeEasy its works with no errors in desktop also your video about automatic salary slips,,i tried also the onEdit function in there too,same error ,"getfolderbyid no permission,i think onEdit function cant be use as a trigger when having a getfolderid in script,is there's any other function that can be used in mobile as a trigger?

    • @sheesh772
      @sheesh772 Год назад

      @@AutomationMadeEasy sorry for having so many questions :( , i just need a script that can save a copy of specific sheet form into a pdf file whenever its finish to fill up,that can use into desktop and also in mobile phones

  • @JayChanthalangsy-jx3if
    @JayChanthalangsy-jx3if 3 месяца назад

    I did everything that you said but when I click on the PDF all the values say #REF! like the PDF is not pulling the cell values from the Data sheet. Please advise.

  • @varindersandhu3292
    @varindersandhu3292 Год назад

    If I only want some cells and columns to be in my invoice as I am creating buttons next to my active sheet. what do I put in the 1st varient so it doesn't print the buttons on invoice pdf

    • @AutomationMadeEasy
      @AutomationMadeEasy  Год назад

      For your requirement I would recommend you to follow below approach:
      ruclips.net/video/Aajg5eoY5TA/видео.html

  • @ebrahimelassy
    @ebrahimelassy 6 месяцев назад

    I completed all the steps successfully and the PDF file was extracted, but all the existing data was deleted because it was equations. Is there a solution to this problem?

    • @ebrahimelassy
      @ebrahimelassy 6 месяцев назад

      Please Help

    • @AutomationMadeEasy
      @AutomationMadeEasy  6 месяцев назад

      data in spreadsheet?

    • @ebrahimelassy
      @ebrahimelassy 6 месяцев назад

      I explained to you that the paper to be converted to PDF contains data linked to another worksheet. When the process is completed, as I mentioned, the paper is converted, but without the data. I want a solution to this problem.

  • @nikhilansal2505
    @nikhilansal2505 9 месяцев назад

    How to create individual PDFs of all the worksheets?

    • @AutomationMadeEasy
      @AutomationMadeEasy  9 месяцев назад

      well same solution in customized manner like looping through all the sheets and generating pdf's of the sheets

    • @KenSuso-c2b
      @KenSuso-c2b Месяц назад

      @@AutomationMadeEasy Follow up on this question

  • @iamdell5544
    @iamdell5544 7 месяцев назад

    Do filter in data then export pdf one by one

  • @tokobukusalaf
    @tokobukusalaf 4 месяца назад

    Failed gan. teamwbk ('application/pdf') how?...