Datatable to HTML Format

[Bindu_sai]

“”

I am doing Data Table to html format for mail body

Input excel having some 2.04% value data but unfortunately while exceuting the proces output was 2.0439205247647113E-2 like this can you please help me on this.

@Vajrang

[Gokul001 (Gokul Balaji)]

Hi @Bindu_sai

Have a look on the document

Convert a DataTable to an HTML string using UiPath - RPA Learners

Regards
Gokul

[Rajesh_Manikandan]

Not exactly sure, why this conversion happens. Share the activities where this happened.

One more way to convert Datatable to Html would be using Create HTML Content activity

[Gokul001 (Gokul Balaji)]

Also Look into the thread @Bindu_sai

How to convert data table to html

Hi @akanksha.patil630, DataTableToHtmlText.xaml (14.5 KB) Thanks!

Regards
Gokul

[ppr (Peter Preuss)]

@Bindu_sai

2.0439205247647113E-2

Computers internaly have to do particular steps to handle fractions. This resulting number is of the internal targeted precisions.

But you can correct within a cleansing / harmonization step like e.g.

we would recommend to do it within a for each row on the data table and bring it within format you would like to see within the HTML table

[Vajrang (Vajrang Billlakurthi)]

Convert value to Decimal with tryparse decimal.

Thanks

Vajrang

[ushu (Usha kiranmai)]

@Bindu_sai You can round a number of decimals to 2 then update to the same data table

How do I round a number of 2 decimals?

At the moment I am trying to get rounded values (2 decimals) from Excel with the robot, but if I paste the values it does not round up or down. I just get the two last decimals. Does somebody know what to do?