Error in Excel Transform Bean in files with VLOOKUP

[former_member245008]

Hi Eng,

I have successfully implemented the ExcelTransformBean for one of my interfaces. Thank you very much for sharing this solution.

I want to ask you regarding an issue I am facing in cases where the incoming excel files has VLOOKUP formulas. I am getting the error below.

Error while sending message: Cannot send message to module processor com.sap.aii.af.lib.mp.module.ModuleException: Error during processing local bean: localejbs/Custom_AF_Modules/FormatConversionBean

This only happens for files with VLOOKUP formulas and active content security warnings.

I have set my formatting module parameter to "excel" instead of "raw" in order to get values same as how they are displayed in the cell. Below are all the parameters I have set in my channel.

converterClass com.equalize.xpi.af.modules.excel.Excel2XMLTransformer

documentName MT_ZKAM_DEMANDSOURCE

documentNamespace urn:com:Innovations:EMEA:SAP:BW:KAM:source

emptyCellOutput defaultValue

formatting excel

processFieldNames notAvailable

Is there a way to avoid this issue even if we have lookups in the excel file?

engswee.yeoh