Excel Component - Text to Columns Property
Dear 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.
Accenture
IN
Hi
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
Pegasystems Inc.
US
Hi Sivamaddy,
Thanks. I have followed up with a Community Moderator to get someone to reply to your question.
Best regards,
Tigran
Accenture
IN
Dear 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
Pegasystems Inc.
IN
Hi Siva,
Have you checked out this great blog yet? Pega Robotics - Excel How To
I belive this answers many of your questions!