Excel format cell then set cell

Discuss RoboTask here

Excel format cell then set cell

Postby wbyford » Thu Feb 15, 2018 5:16 pm

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?
wbyford
 
Posts: 7
Joined: Thu Jan 11, 2018 5:29 pm

Re: Excel format cell then set cell

Postby Oleg » Thu Feb 15, 2018 5:53 pm

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
Oleg
Site Admin
 
Posts: 2351
Joined: Thu Jan 01, 1970 1:00 am

Re: Excel format cell then set cell

Postby wbyford » Thu Feb 15, 2018 6:21 pm

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

Re: Excel format cell then set cell

Postby wbyford » Thu May 31, 2018 2:34 pm

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
wbyford
 
Posts: 7
Joined: Thu Jan 11, 2018 5:29 pm


Return to General Discussion

Who is online

Users browsing this forum: Google [Bot] and 13 guests