Is it possible to get integers using READ RANGE activity?

Hello everybody,

I cannot repeate the exercise from the 3rd lesson of Foundation training. In the video the file “Employees300 orig.xlsx” is read and then data table gets filtered by the condition “Age < 30”.

If I try to do this, the condition doesn’t work: no rows stay in the table if I set “keep rows” and the condition.

What do I do wrong? This column in data table has type System.Double.
Thank you in advance!

Hello @dapachev

Have a look at this sample

Main.xaml (9.6 KB)

Test.xlsx (8.2 KB)

The problem in your case might be that you are using the same datatable as input and output.


1 Like

Hello @PrankurJoshi,

Thank you for your responce.
I tried both: the dame data table and another one as output: non has worked. And in the video in the training the same data table is used.

The file Main.xaml confuses me: I cannot find there something about reading excel files. Where schould I look at?

Here we have read excel sheet


Hi @PrankurJoshi,

The file which you uploaded looks so:

I cannot find Excel Application Scope activity there. Is it a wrong file or I’m looking at the wrong places?

Ohh my bad use this

Main.xaml (9.6 KB)

1 Like

Thank you @PrankurJoshi,
Due to server error the files cannot be downloaded now. I’ll check the file later.

1 Like

Hi @PrankurJoshi,

Your script works by me not properly either.

It looks like my local problem. I address tech support then und delete this thread.
Thank you for your help!

1 Like