While Read Range using the PreserveFormat for amount column

I’m having the columns with amount that is dynamical today it will only one column tomorrow it could be 2 more columns with amount i was having input data in excel like 34,200.00
but it is reading as 34200 when using preserve formate it is coming different output
FYI i’m attaching the ss

MicrosoftTeams-image (9)
but i need while reading the it should be output as 34,200.00

Hi @Jyothi1

Check the below thread

It’s better to use Excel activities rather than workbook activities.

Hope it helps!!

it is not even working with excel application scope
the correct out put is not getting those columns are deleting in process

Hi @Jyothi1

Can you share your excel once.

Regards

SOA as on 06112024 (1).xlsx (27.8 KB)

Hi @Jyothi1

You are using workbook activities right.

Regards