Question
Bankofamerica.com
IN
Last activity: 6 Nov 2018 20:02 EST
How to Open excel and read the value in the cell
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Integrity Systems, Inc.
US
You will need to add a MicrosoftExcel component to you solution, it is found under Pega Robotics Connectors in the toolbox. Set the properties to open you excel file. Then you can read the value from B1 and place in the Path of the adapter, assuming this is a windows adapter.
Bankofamerica.com
IN
Thanks Chan for your reply. I tried that same way. I got an error message " object reference not set to on instance of the object".
Can you please check and update on this.
Integrity Systems, Inc.
US
i tried to replicate your error using the same automation steps as in Image3 but I can't get the error. Can you post an image of the properties for you microsoftExcel1 component and an image of your excel worksheet that includes the sheet names at the bottom.
Bankofamerica.com
IN
when I execute first time in debug mode. I didn't get the error message. From second time onwards. I got the error message. Find the attached images.
This is due to excel file is not closed after first time was opened.
Integrity Systems, Inc.
US
OK, I was able to reproduce your issue. The problem is that when the Excel workbook is closed it cases the microsoftExcel1 component to Stop. Just add a Start call to the microsoftExcel1 component before your Open call.
Integrity Systems, Inc.
US
I cannot reproduce your issue using the same steps in the provided image.
I suggest that you open an SR with support as it appears you need someone who can look at your machine. If you do open an SR, please post the SR number here for tracking purposes.
The following article will be help you in creating an SR-
My Support Portal explained for Pega Robotic Automation (formerly OpenSpan)