Question7Replies265Views Siva.G Member since 2016 14 posts Accenture Posted: 3 years agoLast activity: 3 years 6 months ago Closed Excel Component - Text to Columns PropertyDear Team,I am unable to use the Text-to-Columns property in excel columns.First activating the cell then selecting the entire column. Post which i'm applying the text-to-columns property. But throws an error.Can you pls guide me what are the values/paras i have to pass like destination, delimiter, comma separator.Thanks**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 agoTigranAirapetian PEGA replied to Siva.GHi Sivamaddy, What is the error that you are seeing? Thanks, Tigran Posted: 3 years agoSiva.G Accenture replied to TigranAirapetianHi I am getting the below error. Error executing link in Automation: Automation1 - From: Automation1.Wbtest.GetCellValue() To: Automation1.Wbtest.ExcelApplication.ActiveCell.Cells.EntireColumn.TextToColumns() Could not get PropertyInfo for Property: Wbtest.ExcelApplication.ActiveCell.Cells on Instance: Automator-8D464BD83A5EB10\MicrosoftExcel-8D464BDEBB70B38 I am not sure, How do we select the delimiter i.e., comma or space. Thanks Siva Posted: 3 years agoTigranAirapetian PEGA replied to Siva.GHi Sivamaddy, Thanks. I have followed up with a Community Moderator to get someone to reply to your question. Best regards, Tigran Posted: 3 years agojeffbadger PEGA replied to Siva.GPlease take a screenshot of your automation so we can see what you are trying to do. Posted: 3 years agoRameshkumarT Accenture replied to jeffbadgerHi Jeff, Please find the attached screenshots for the open span code flow and error received. Posted: 3 years agoSiva.G Accenture replied to Siva.GDear Team, Is it possible to get the video training materials for excel connector like how do navigate/use excel properties and what would be the source and output formats. Please let me know. Thanks Posted: 3 years agoLochan_DV MOD replied to Siva.GHi Siva, Have you checked out this great blog yet? Pega Robotics - Excel How To I belive this answers many of your questions!