Excel format cell then set cell

Discuss RoboTask here
Post Reply
wbyford
Posts: 10
Joined: Thu Jan 11, 2018 5:29 pm

Excel format cell then set cell

Post by wbyford »

I have run into an issue with using the Excel set cell action. I have a text file that has rows of numbers, many of which have leading zeroes. When I do a text loop to get each number and load to an Excel file, the zeroes are dropped in Excel. I have Excel template files which have the specific column format set to text. I have also tried setting the format using the format cell = @.

Neither of these help. When the number is put into the cell in Excel, the format is reset to general and leading zeroes dropped. I also tried adding a single quote to the beginning of the variable holding the number when I set the cell. This appears to work but I end up with a leading single quote in the cell. This Excel file will eventually be used in another process and there cannot be anything other than the number in the cell.

When the file is opened and the numbers are pasted into the Excel file (outside of RoboTask), it works as needed. Any suggestions?
Oleg
Site Admin
Posts: 3000
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Re: Excel format cell then set cell

Post by Oleg »

You are correct.
The value is integer value, so the action resets the cell format to General format. The same behavior when you paste the number with leading zero into the cell from clipboard.
It seems that we need to improve the action and the action editor to use the text format forcibly.
Oleg Yershov
wbyford
Posts: 10
Joined: Thu Jan 11, 2018 5:29 pm

Re: Excel format cell then set cell

Post by wbyford »

That would be very helpful. Thank you!
wbyford
Posts: 10
Joined: Thu Jan 11, 2018 5:29 pm

Re: Excel format cell then set cell

Post by wbyford »

Oleg - i have installed version 7.1 which has the Excel Set Cell improvements. THANK YOU!!! This is going to save us so much time! I will recommend RoboTask to anyone looking for automation. Not just for the app itself but for the superior customer service. You are awesome! :D
Post Reply