Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Kasia Markowska (KasiaM40)
UNIQA

UNIQA
PL
KasiaM40 Member since 2020 13 posts
UNIQA
Posted: Mar 17, 2021
Last activity: Apr 12, 2021
Posted: 17 Mar 2021 10:02 EDT
Last activity: 12 Apr 2021 13:35 EDT
Closed

Exporting to table from a password-protected xlsx

Hi,

I can open the file file however execution stops after Excel.Open block (at the Excel.ExportToTable block) though message with an exception does not pop up.

xlsx

To see attachments, please log in.
Pega Robotic Automation 8.0 SP1
Robotic Process Automation
Other Industry
Robotics System Architect

Posted: 3 years ago
Posted: 17 Mar 2021 12:45 EDT
Thomas Sasnett (ThomasSasnett)
MOD
Lead Robotics Architect
Pegasystems Inc.
US

@KasiaM40 You might be sure to enable the FilePublisher so that you can see the exception in the RuntimeLog.txt. I imagine there is an exception happening that would get written to the logs that might be helpful to see.

To see attachments, please log in.
Posted: 3 years ago
Posted: 12 Apr 2021 13:35 EDT
Thomas Sasnett (ThomasSasnett)
MOD
Lead Robotics Architect
Pegasystems Inc.
US

@KasiaM40I apologize for the delay Kasia. I missed your reply somehow. That seems to indicate that you haven't defined the Workbook yet. You must first open your workbook before you can run any methods against it. Can you provide screenshots of your automation?

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice