Excel cell gives Null value when referenced to chained referenced cell

[Rajna (Rajeswari)]

Hello ALL ,

I am trying to extract excel sheet data to data table where a column named rate referenced to multiple sheet rate cell . Each sheet rate is referenced to another cell value .
For Example , Consider an excel has one main sheet and multiple vendor sheers . Then in Main sheet column E1 has Rates and E2 is referenced to VendorSheet1 G20 , E3 to Vendorsheet2 G20 .and so… on . This G20 is again referenced to value
G18-19 , where G18 has G1625+G1730 and G16 referenced to further down cell values. So the value E20 referred to chained referenced cell .

Now , I am reading this excel data using read workbook . Cannot use excel activites as it is taking longer time to read huge excel file. Output data table gives all values except this rates column value and it has IncompatibleValue as text

sample output -

1110,EA,IncompatibleValue,IncompatibleValue,18.326203819123197,IncompatibleValue,18.897414067199996.

Please help to resolve the issue

[sharazkm32 (Sharaz K M)]

How many rows are there in the sheet which you are trying to read??

While reading the sheet - make sure the following settings are configured. See if there is any performance improvement after making the below settings

Also share a sample excel if possible. Or at least the screenshot of the values which are trying to read by the BOT