Hello All,
I have an issue, I need to retrive data from an excel where there are subcolumns of the main headers,
like,
Function DTM DTM1
Status Data Status Data
fnc_createnew Y ravindra Y Bhapri
fnc_sendMessage Y asfsdg Y saffaff
In the shown excel format,i will get the main coulmn data from some global variables. if the global variable give the column name as DTM then it should read the values of "status" and "data" sub coulumns of DTM,
in the similar way if the if my global variable has the values of DTM1, it should read "Status" and "Data" sub columns of DTM1.
I tried using DDT method, but i could not able to read values which are present under sub coulms(status, data).
Need help on this please....