Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you can use it in the text object ,
=sum(if(نام='a23',[شماره پرسنلي]))
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 .
you want to load only 25 rows from the excel?
you can use it in the text object ,
=sum(if(نام='a23',[شماره پرسنلي]))