readexcelsheet Function Unable to read Excel with Formulas

Hello,

I am using readexcelsheet() to read an Excel File with multiple sheets. I have used functions mentioned below in the excel sheet.

• CONCAT(), TRANSPOSE(), SHEET(), CELL()

Upon using this function I am getting some errors. please 

• I don't understand why the readexcelsheet() is trying to read/evaluate formulas. 
• Shouldn't it only read Data(output of the formula) ??

If readexcelsheet() is not expected to support files having above mentioned functions, please suggest an alternate way to use those functions.