Skip to Content
1
Sep 08, 2023 at 11:59 AM

Formatting of MS Excel

629 Views

Hello Experts,

I have one requirement to download an excel sheet from Fiori application. I am able to generate the excel and fill the data from a CDS view. But I need to do below formatting.

  1. Hide specific columns - I have around 230 columns in the excel but only show 50 columns when download. User should be able to 'unhide' any of the columns if required after downloading( B & C columns in screenshot).
  2. Set dropdown list with fixed values - For some fields such us incoterms we need to create dropdowns with predefined values.
  3. Coloring of cells - Need to give different colors in cells based on the requirement( ie: red for mandatory)

OLE approach will not help on background job or Odata calls. Is there any other way to achieve this from ABAP side or from UI side.

image.png

Thanks,

Deepesh AG

Attachments

image.png (19.0 kB)