Change data type from text to integer in a data table before pasting in excel

[crowdo]

Hi,

I am reading an excel data table, then doing calculation and writing the new datatable in excel. However, it writes in excel as Text and not numbers.

How can I change in my data table that a specific column should be written as integer?

Thank you

[Pratik_Wavhal]

Hi @crowdo

You can refer below post and use that activity.

Changing excel cell format with UiPath

Hi, To change cell format , you can use the “ChangeCellType” activity which is existing in the blow link. Regards Balamurugan.S

Hope this may help to solve your issue
Mark as solution if this helps you and like it

Happy Automation

Best Regards
Er Pratik Wavhal