Question6Replies3011Views DeviM738 Member since 2017 18 posts Mphasis Posted: October 9, 2017Last activity: October 16, 2018 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 agoDeviM738 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 agoDeviM738 Mphasis replied to DeviM738Can somebody please help with this? Posted: 2 years agosmartragi Tata Consultancy Services replied to DeviM738Hi Devi, Can you help me with how did you get the Range Object ? Posted: 3 years agoUjjwalJ8 Mphasis replied to DeviM738This comment/reply has been branched into a new post Accepted Solution Posted: 3 years agogrona 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 agoKRSNA@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.