Read data from excel

Question

Hi Techies,

I have a business requirement of reading data from excel which will have multiple templates.

Example : Excel 1 -> ClientName may be on column #2 and Age may be column #10

Excel 2 -> ClientName may be on column #20 and Age may be column #1

Basically, the order of column may different and some time merged column also.

Each client will have their own template with specified data, hence I cannot force them to use a standard template

Your technical solution would be much appreciated.