Question
Ford India PVT Ltd
IN
Last activity: 2 Jan 2020 8:19 EST
PEGA Excel Connector Issues
I opened an excel workbook using the PEGA new Excel connector. After making some manipulations, I again opened another excel workbook. When I connected the 'close' method, PEGA abruptly closes both the workbooks, instead of closing the current/active workbook.
So I don't have any choice and forced to use a script with INTEROP instead of PEGA automation tools.
Can anyone in PEGA suggest how to close the active workbook using the PEGA Automations tools?
Accepted Solution
Pegasystems Inc.
US
If you need to work with 2 workbooks at the same time, create 2 Excel connectors.
Pegasystems Inc.
US
I created a sample solution where I tried to reproduce the problem, but I could not. I am using 19.1.14. Are you able to reproduce using this solution?
Pegasystems Inc.
US
Now reading Jeff's comments, I see that it is possible you are trying to open two documents with one connector? That would obviously perform as expected given your description. I assumed you meant you were opening a second document manually or otherwise outside of the connector. Is that not that case?
Ford India PVT Ltd
IN
Hello Jeff and tsasnett. Thank you. Am able to connect two excels simultaneously using two different Excel connector. The solution is much useful :)