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 [Micros…

Hi @Jyothi1 Check the below thread [image] Preserve format currency issue Activities Hi, What activity are you using? It may be better to use activity which is used inside UseExcelFile or ExcelApplciationScope. (not Workbook activities). Regards, It’s better to use…

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

While Read Range using the PreserveFormat for amount column

Help Studio

Parvathy (PS Parvathy) June 11, 2024, 3:57pm 2

Hi @Jyothi1

Check the below thread

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

Hope it helps!!

Topic		Replies	Views
Preserve format currency issue Activities excel , activities , question	2	132	May 31, 2024
Excel Application Scope changes automatically value format Studio excel , uiautomation , excel-scope	4	1529	May 27, 2022
.xls issue while reading the data Activities excel , activities , question	8	181	April 30, 2024
Studio Excel format all Studio studio , question , activities_panel	11	1412	July 26, 2021
Change excel data format Studio studio , question , activities_panel	2	1195	February 1, 2022

While Read Range using the PreserveFormat for amount column

Related topics