Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-09-22 05:54 PM
Hi All,
Anyone knows how to perform Text to Number conversion in excel using Blueprism?
Is spying the best approach?
------------------------------
Rishabh Chauhan
------------------------------
Anyone knows how to perform Text to Number conversion in excel using Blueprism?
Is spying the best approach?
------------------------------
Rishabh Chauhan
------------------------------
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-10-22 10:38 PM
Hi @RishabhChauhan,
You can use the below code for performing the conversion:


Hope it helps !!
------------------------------
Ritansh Jatwani
Manager
Deloitte
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------
You can use the below code for performing the conversion:
Hope it helps !!
------------------------------
Ritansh Jatwani
Manager
Deloitte
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------
6 REPLIES 6
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-09-22 06:07 PM
Hi @RishabhChauhan,
Whenever you are dealing with an excel automation, always try for code stage or inbuilt action items rather than going to the spying approach. Code stage is the fastest solution for performing the automation. Did you try code stage in this scenario?
------------------------------
Ritansh Jatwani
Manager
Deloitte
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------
Whenever you are dealing with an excel automation, always try for code stage or inbuilt action items rather than going to the spying approach. Code stage is the fastest solution for performing the automation. Did you try code stage in this scenario?
------------------------------
Ritansh Jatwani
Manager
Deloitte
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-09-22 06:29 PM
Thanks @ritansh.jatwani for the response.
I tried for the code stage but I was not able to succeed in that. Can you please share the code, if you have it?
------------------------------
Rishabh Chauhan
------------------------------
I tried for the code stage but I was not able to succeed in that. Can you please share the code, if you have it?
------------------------------
Rishabh Chauhan
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-09-22 03:26 PM
Hi Rishabh
Do you mean you are trying to set the format of a cell from text to a number? or are you trying to get the cell value which is text in excel but you want it to go to a data item in blueprism as a number?
If you want to extract it from excel into a blue prism data item then you just need to get the cell value using the Excel VBO and action Get cell value and let it output to a data item which has the datatype number.
If you want to format the cell value in excel from a text to a number then try using the Excel VBO with either Format cell or Format current cell actions and set the input format to "0"
Hope this helps 🙂
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------
Do you mean you are trying to set the format of a cell from text to a number? or are you trying to get the cell value which is text in excel but you want it to go to a data item in blueprism as a number?
If you want to extract it from excel into a blue prism data item then you just need to get the cell value using the Excel VBO and action Get cell value and let it output to a data item which has the datatype number.
If you want to format the cell value in excel from a text to a number then try using the Excel VBO with either Format cell or Format current cell actions and set the input format to "0"
Hope this helps 🙂
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-10-22 10:38 PM
Hi @RishabhChauhan,
You can use the below code for performing the conversion:


Hope it helps !!
------------------------------
Ritansh Jatwani
Manager
Deloitte
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------
You can use the below code for performing the conversion:
Hope it helps !!
------------------------------
Ritansh Jatwani
Manager
Deloitte
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-10-22 10:15 PM
Hi @Michael ONeil,
Thanks for your response. I have a huge set of data in an excel which needs conversion from text to number hence I can't use Get Cell Value as it needs to be done for every cell. While I was looking for a solution which can work on a full column. PFB the screenshot for what i was looking for:

Also, I tried changing the format to '0' but it didn't work.
------------------------------
Rishabh Chauhan
------------------------------
Thanks for your response. I have a huge set of data in an excel which needs conversion from text to number hence I can't use Get Cell Value as it needs to be done for every cell. While I was looking for a solution which can work on a full column. PFB the screenshot for what i was looking for:
Also, I tried changing the format to '0' but it didn't work.
------------------------------
Rishabh Chauhan
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-10-22 10:16 PM
Thanks a ton @ritansh.jatwani.
The code worked perfectly fine!! 🙂
------------------------------
Rishabh Chauhan
------------------------------
The code worked perfectly fine!! 🙂
------------------------------
Rishabh Chauhan
------------------------------
