Event Handler for Download to Excel Button

[former_member193352]

Hi Experts,

I have been trying to debug and find some clue about the Export to Spreadsheet Button present normally in a table view. My requirement is to modify the records before they are downloaded to an excel sheet.

Any quick clues will be highly appreciated.

Thanks

Vishal

[Former Member]

Hi Vishal,

I guess you can put your code in one of these methods, GET_TABLE_COMPONENTS or GET_PAGE_CONTEXT of IMPL class.

Put a break point in IF_BSP_WD_MODEL_TV_EXCEL_EXPRT~GET_CSV, its there in CNXX class of your table view context node and then see call stack.

Hope that helps.

Regards,

BJ

[former_member193352]

Thanks BJ. Thats very close. How could I miss the context node class methods.

I'm sure I'll be able to implement the solution using these methods.

Thanks

Vishal

[VishnAndr]

Hi, Vishal.

One more input regarding your question (may be it will be usefull) is that the service UIF_EXPORT_TAB (in tx. SICF) is responsible for this button. Its handler class CL_CHTMLB_CONFIG_TAB_EXCEL_EXP handles requests from this button. And also it works with template (method gDo) and actual data (method gDa) from the table. It calls mentioned GET_TABLE_COMPONENTS, GET_TEMPLATE_XML, GET_DATA_XML, GET_CSB methods from your table context node class.

[former_member214667]

Hi Vishal,

You can try to see the class behind the tag that builds the table to figure out how the download to excel is being done.

Regards,

Shiromani