Help2

[mr_ramshini]

I have a lot of data and I would like an Excel file with data that is in cell 24 in the text box to show

and I attached a file

I want show value on row 24 and column d

please guide me

[tamilarasu]

Try this script.

Data:
LOAD D
FROM
s1.xlsx
(ooxml, No labels, table is Sheet2)
Where  RecNo() = 24;

Let vValue = Peek('D');

DROP Table Data;

Create a textbox in front end and type the variable name like =vValue .

[arulsettu]

you want to load only 25 rows from the excel?

[marjan_it · Accepted solution]

you can use it in the text object ,

=sum(if(نام='a23',[شماره پرسنلي]))