xlookup and Valuetotext Excel function not working in transformation

Multiple Excel formulas are not working. For example xlookup when used is not giving value in preview mode means data is not going to the database hence output also not generated properly.