Skip to main content

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?

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?


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