Save Excel to PDF - error - Save Excel File As PDF: Nothing to save

Help Studio
1

HI Team,

Could you please assist me with below error :

Save Excel file as PDF -
Error Message - Save Excel File As PDF: Nothing to save.
Facing mentioned error only in Unattended mode.

However, Bot is working fine in attended mode.
Please assist with mentioned error.

Thanks,
Gaurav

2

Hi @Gaurav

Check out this thread. It might help you.

Regards

3

Hello @Gaurav ,
Ensure there is only one sheet in the Excel file.
If there is more tha one required sheet, delete those unwanted sheets using Delete sheet activity.
Refer to this thread you may get some idea

4

Hello @Gaurav

  1. Open Excel Application

    • ExcelFilePath: “C:\Path\To\Your\File.xlsx”

  2. Delay

    • Duration: “00:00:05” // Adjust the delay duration as needed

  3. Log Message

    • Message: “Excel file opened successfully”

  4. Save Excel File As PDF

    • OutputPDFFilePath: “C:\Path\To\Your\Output\File.pdf”
    • Overwrite: True

  5. Log Message

    • Message: “Excel file saved as PDF successfully”

Thanks & Cheers!!!

5

Hi @Gaurav

  1. In unattended mode, the robot might not have the necessary permissions to access or
    modify the Excel file. Check and ensure that the robot has the required permissions to read
    the Excel file and create a PDF in the specified location.
  2. Instead of relying on relative paths, use full file paths in your automation.
  3. Use Delay before the “Save Excel as Pdf” activity
  4. Debug the code to ensure the code the running as you expect
6

Happy new year.

Thanks for briefing the solution in detail.
But unfortunately its giving same error - i.e. nothing to save in unattended mode.

Thanks,
Gaurav