Set the Worksheet Tab Color

[ivanfemia]

In Excel you have the possibility to set the worksheet tab color. This is often useful for showing related data or differentiate between sheets containing unrelated information.

[ivanfemia]

Updating issues (#174, #31, #71, #134, #137, #141, #155, #156, #170, #176, #179, #180, #182)

[ivanfemia]

added functionality requested.
Can be tested with the following coding:

REPORT.
DATA: lo_excel                TYPE REF TO zcl_excel,
      lo_worksheet            TYPE REF TO zcl_excel_worksheet.
DATA: lv_tabcolor TYPE zexcel_s_tabcolor.
CONSTANTS: gc_save_file_name TYPE string VALUE 'colored_tabs.xlsx'.
INCLUDE zdemo_excel_outputopt_incl.
START-OF-SELECTION.
  " Creates active sheet
  CREATE OBJECT lo_excel.
  " Get active sheet
  lo_worksheet = lo_excel->get_active_worksheet( ).
  lv_tabcolor-rgb = zcl_excel_style_color=>create_new_argb( ip_red   = '00'
                                                            ip_green = 'C0'
                                                            ip_blu   = 'C0' ).
  lo_worksheet->set_tabcolor( lv_tabcolor ).
  lo_worksheet = lo_excel->add_new_worksheet( ).
  lv_tabcolor-rgb = zcl_excel_style_color=>create_new_argb( ip_red   = 'C0'
                                                            ip_green = '00'
                                                            ip_blu   = 'C0' ).
  lo_worksheet->set_tabcolor( lv_tabcolor ).
*** Create output
  lcl_output=>output( lo_excel ).

[ivanfemia]

I think it would be the best to add this coding to the Demo Report that demonstrates multiple worksheets.

[ivanfemia]

Thank you for implementing this feature!!!!!
I would like to test it but getting errors during the nugget import.

Is it possible to get the current nugg-file without the webdynpro objects. SAPlink runs in an error while importing the webdynpro component/interface/sicf objects. So the import stops in the middle with missing objects. Everything after the ZIWCI_DEMO_EXCEL_WDA01is not installed.

Thanks a lot
Kilian

[ivanfemia]

Dear Kilian,

please make sure that you update SAPlink to the latest available daily build. That should avoid the import problem. Also update the SAPlink plug-ins to the latest daily build. It's easy now because most of them are coming in a single nugget.

Best regards
Gregor

[ivanfemia]

I encountered the same problem when installing from the working directory.
I issued an issue #26 into project ZAKE because of this but I guess something alike should be done for ZSAPLINK if you install a complete nugget

---

live long and prosper
Stefan Schmöcker

[ivanfemia]

I have now installed the latest version of ZSAPLINK together with ZA2X stable version 7 and could also use the function successfully.
Thank you very much for implementing this feature - it works like a charm!!!!

Best regards
Kilian

[ivanfemia]

[[image:cyMaEYdcKr473dacwqjQYw]]
different worksheet tab colors