Question6Replies3026Views×Close popoverDevi Michael (DeviM738) Mphasis Mphasis IN View ProfileSend Message DeviM738 Member since 2017 18 posts Mphasis Posted: October 9, 2017Last activity: October 16, 2018Posted: 9 Oct 2017 7:58 EDTLast activity: 16 Oct 2018 12:03 EDT Closed Solved Pega Robotics - Excel QueriesPlease let me know how to do the following:1) Select a range in the excel (for example column A)2) Select Format Cells for the above range3) Select Category as Date, and the type as 3/14/01***Updated by moderator: Lochan to create new post from reply*****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. Robotic Process Automation ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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: 3 years agoPosted: 9 Oct 2017 7:58 EDT×Close popoverDevi Michael (DeviM738) Mphasis Mphasis IN View ProfileSend MessageDeviM738 Mphasis replied to DeviM738An update on the above query, I am able to set the format as Date by using the NumberFormat property available in the Range object. However I am still not clear on how to select the range ( I do not want to use the UsedRange, I want to select a range of my choice) Please help Posted: 3 years agoPosted: 9 Oct 2017 7:58 EDT×Close popoverDevi Michael (DeviM738) Mphasis Mphasis IN View ProfileSend MessageDeviM738 Mphasis replied to DeviM738Can somebody please help with this? Posted: 2 years agoPosted: 2 Aug 2018 18:03 EDT×Close popoverSwaminathan Madurai Natarajan (smartragi) Tata Consultancy Services Tata Consultancy Services US View ProfileSend Messagesmartragi Tata Consultancy Services replied to DeviM738Hi Devi, Can you help me with how did you get the Range Object ? Posted: 3 years agoPosted: 9 Oct 2017 8:00 EDT×Close popoverUjjwal Jha (UjjwalJ8) Mphasis Mphasis IN View ProfileSend MessageUjjwalJ8 Mphasis replied to DeviM738This comment/reply has been branched into a new post Accepted Solution Posted: 3 years agoPosted: 10 Oct 2017 23:28 EDT×Close popoverAndrew Grondin (grona) PEGA GCS Solutions Engineer I Pegasystems Inc. US View ProfileSend Messagegrona PEGA replied to DeviM738I don't believe you can select a range with the Excel connector but you can use the set and get cell methods to cycle through the cells you want to work with piecemeal. http://help.openspan.com/80/Components/Microsoft_Excel.htm Posted: 3 years agoPosted: 11 Oct 2017 3:01 EDT×Close popoverKondaiah Nali (KRSNA@NALI) Cognizant Technology Solutions India PVT Ltd Cognizant Technology Solutions India PVT Ltd IN View ProfileSend MessageKRSNA@NALI Cognizant Technology Solutions India PVT Ltd replied to DeviM738Hi, you can go for import data and export data, For Example This automation shows how to use the MicrosoftExcel connector to run a macro in an Excel spreadsheet and then return the data from the spreadsheet to a Windows form.