Whenever I use the Write from data table action, the results in Excel are always strings, no matter what type columns the data table has. I’ve tried with both decimal points (, .) and the result is the same. Is there a way to get the numbers into Excel?
Question
Excel Advanced: Write from data table action pastes only strings
+5
+9Theodore Xypteras wrote:
Whenever I use the Write from data table action, the results in Excel are always strings, no matter what type columns the data table has. I’ve tried with both decimal points (, .) and the result is the same. Is there a way to get the numbers into Excel?
Are you trying to enter currency into the Excel sheet? Or do the numbers have some other kind of formatting, such as percentage?
1 person likes this
+5Shreya.Kumar wrote:
Theodore Xypteras wrote:
Whenever I use the Write from data table action, the results in Excel are always strings, no matter what type columns the data table has. I’ve tried with both decimal points (, .) and the result is the same. Is there a way to get the numbers into Excel?
Are you trying to enter currency into the Excel sheet? Or do the numbers have some other kind of formatting, such as percentage?
Just a number with 2 decimal places. Here’s my table variable
and this is my test task
Cheers!
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.