Skip to Content

Error in Excel Transform Bean in files with VLOOKUP

Nov 07, 2017 at 01:17 PM


avatar image
Former Member

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 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.



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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers