Skip to Content
0
Jun 04, 2020 at 06:11 AM

How to keep Leading zeros in excel sheet download from OLE2 OBJECT

388 Views

Dear experts,

I am working on EXCEL sheet downloaded with multiple work books.

My excel sheet download with ole2_object using (CALL METHODcl_gui_frontend_services=>clipboard_export).

Once excel sheet downloaded,I found one issue.company code(bukrs) having 4chras filed.

company code(bukrs) actual value = 0001 but in excel sheet it's showing '1'.

I saw in excel sheet in(Home) defalut General showing but if we click on drop down there is a option TEXT, if we select may be issue get resolve.

Can you please help me on this issue how to keep leading zeros using OLE2_OBJECT.