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

 Sri K (Sri5777)
ExperienceIT

ExperienceIT
US
Sri5777 Member since 2017 7 posts
ExperienceIT
Posted: Aug 2, 2019
Last activity: Aug 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?

To see attachments, please log in.
Robotic Process Automation

Posted: 5 years ago
Posted: 6 Aug 2019 6:28 EDT
Sravan Aluvala (chakri5122)
Accenture

Accenture
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.

To see attachments, please log in.
Posted: 5 years ago
Posted: 6 Aug 2019 9:46 EDT
Sri K (Sri5777)
ExperienceIT

ExperienceIT
US

Hi Chakri,

 

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

Thanks for the reply.

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