function module to know file data.
Is there any function module available which can give me details of a file like no of rows and cols in a file?
My input file is EXCEL file and I want to know no of lines (i.e rows) present in file before reading it.
If there is no such FM then plz let me know any function module which will read an excel file line by line in internal table as follow :
types : begin of ty_itab,
Line type string,
End of ty_itab.
Data : gt_itab type standard table of ty_itab.
i want ot read excel file in above internal table which stores excel file dta line by line in it.