While Read Range using the PreserveFormat for amount column

Help Studio
, ,
1

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 (10)
MicrosoftTeams-image (10)500×507 6.37 KB

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

2

Hi @Jyothi1

Check the below thread

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

Hope it helps!!

3

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

4

Hi @Jyothi1

Can you share your excel once.

Regards

5

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

6

Hi @Jyothi1

You are using workbook activities right.

Regards