Modern Excel read range read all column as string

[Ahmad_Rais (Ahmad)]

Modern Excel read range read all column as string and like the calssic read range it rerturn as object thus its easy to use filter data table activities,

how can i use modern but outoput the data type as object/ correct data type so i can use filter easier

[Yoichi]

Hi,

Can you try the following settings?

Set RawValue at ReadFormatting
Uncheck at VisibleRowsOnly

Regards,

[Ahmad_Rais (Ahmad)]

the data type still output as string,

ususally using classic it gives as object thus we can use filter activity more easly

[Yoichi]

Hi,

Can you share your input file? It’s no problem if dummy data.

Regards,

[Ahmad_Rais (Ahmad)]

Data2.xls (30.5 KB)

[Yoichi]

HI,

In my environment. it works well as the following. Can you also share your workflow?

Regards,

[Ahmad_Rais (Ahmad)]

which package are u using ?

[Yoichi]

Excel pack 2.24.4

Also can you try the following sample?

Sample20250917-1.zip (10.0 KB)

Regards,

[Ahmad_Rais (Ahmad)]

i try yours its object, this is very weird actually haha

[Ahmad_Rais (Ahmad)]

i will send u my script ya , please take a look

[Ahmad_Rais (Ahmad)]

hi there are no preserve format in the modern excel activities as far as i know