Skip to main content
Contact a Moderator

Question

2
Replies
127
Views
 Srinivasa Prem Ranjith Kondru (SrinivasaK5777)
Prime Therapeutics LLC

Prime Therapeutics LLC
US
SrinivasaK5777 Member since 2017 7 posts
Prime Therapeutics LLC
Posted: August 2, 2019
Last activity: August 6, 2019
Posted: 2 Aug 2019 15:11 EDT
Last activity: 6 Aug 2019 9:46 EDT
Closed

Unable to get excel worksheets name

Hi All,

I am trying to get the worksheets names but ending up getting System_ComObject error any way to get the name?

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
Posted: 6 Aug 2019 6:28 EDT
Sravan Aluvala (chakri5122)
Tech Mahindra Ltd

Tech Mahindra Ltd
IN

Hi,

Could you please post the exact error message.

I Have designed a simple automation to get all the sheet names of a workbook. Please have a look once.
Posted: 2 years ago
Posted: 6 Aug 2019 9:46 EDT
Srinivasa Prem Ranjith Kondru (SrinivasaK5777)
Prime Therapeutics LLC

Prime Therapeutics LLC
US

Hi Chakri,


 


I have achieved this through Excel workbook worksheets  and trycasttoworksheet method property and working as expected. 


Thanks for the reply.

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