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.
Posted: 4 years ago
MOD
Pegasystems Inc.
US
Posted: 4 years ago
Updated: 4 years ago
Updated: 18 Mar 2021 6:11 EDT
UNIQA
UNIQA
PL
Posted: 4 years ago
Updated: 4 years ago
Updated: 18 Mar 2021 6:11 EDT
UNIQA
UNIQA
PL
@ThomasSasnett I printed the exception in a dialog box using a Try and Catch wrap. What kind of Excel setup is required here? I have the filename, sheet and password defined.
Posted: 4 years ago
MOD
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?
@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.