abap2xlsx is a complete library for the creation of professional Excel (XLSX) from scratch.
After importing the transport files:
None of the demos are running: implementations missing:
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_DYN_CALL_ILLEGAL_METHOD', was
not caught in
procedure "CONSTRUCTOR" "(METHOD)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated that the
exception would occur, the current program is terminated.
The reason for the exception is:
It was tried to call a not-implemented method
"ZIF_EXCEL_SHEET_PROTECTION~INITIALIZE" in the class "ZCL_EXCEL_WORKSHEET".
i had the same problem.
I implemented the method in ZCL_EXCEL_WORKSHEET as an empty method.
now the examples are working.
I think there will be a fix with the correct implementation in a view days.
Hi All ,
I Have succesfully converted my reports to xlsx, but now my problem is i want to use merge cells functionality which is not supporting in my older version,now i want to download abap2xlsx nudd file but i am not getting newer version of that file & also suggest how implement merge cells in xlsx
I have succesfully installed abap2xlsx . But when I want to open the generated .xlsx files to popups occurs :
Probably those are Excel - issues . How can those popups be avoided ?
can you please open an issue also providing if possible the report you're using to create the XLSX file and the created XLSX. Are you able to open the content created by the Demo reports without errors?
I can't download sap link file of abap2xlsx from SAP Code Exchange.
You can download them here for your reference.
Please use the code exchange platform for comments or issue.
@Frank please do not cross post. You have to forward your request to SAP Code Exchange Team, we cannot do nothing with the code exchange TOU related error.
My installation is missing class ZCL_EXCEL where I can get this class. I can activate ZCL_CHTMLB_TAB_EXCEL_EXPORT class.
Please let me know.
please try to install the latest build or stable version from the project homepage at https://cw.sdn.sap.com/cw/groups/abap2xlsx and if it still fails let us know in the project discussion forum.
I have a problem with the code in background.
My Program does not work in background but the same code works in fore ground. Could you please help me if there are any setting for the same.
unfortunately we don't have a crystall ball to analyze your problem. Please describe it in more detail and especially let us know if it is abap2xlsx related. Have you based your code on one of the examples?
Good one ..
It is related to ABAP2XLSX.
The below is the report program. When I check the data placed in the application server I find some garbage values. This is the same way I placed my code in app server in background mode but with the difference that I used the below code as my excel comprises of tables.
lo_worksheet->bind_table( ip_table = <fs_history_data> is_table_settings = ls_table_settings it_field_catalog = lt_fieldcat ).
REPORT zdemo_excel25. DATA: lo_excel TYPE REF TO zcl_excel, lo_excel_writer TYPE REF TO zif_excel_writer, lo_worksheet TYPE REF TO zcl_excel_worksheet. DATA: lv_file TYPE xstring. CONSTANTS: lv_file_name TYPE string VALUE '25_HelloWorld.xlsx'. DATA: lv_default_file_name TYPE string. CALL FUNCTION 'FILE_GET_NAME_USING_PATH' EXPORTING logical_path = 'LOCAL_TEMPORARY_FILES' " Logical path' file_name = lv_file_name " File name IMPORTING file_name_with_path = lv_default_file_name. " File name with path " Creates active sheet CREATE OBJECT lo_excel. " Get active sheet lo_worksheet = lo_excel->get_active_worksheet( ). lo_worksheet->set_title( ip_title = 'Sheet1' ). lo_worksheet->set_cell( ip_column = 'B' ip_row = 2 ip_value = 'Hello world' ). CREATE OBJECT lo_excel_writer TYPE zcl_excel_writer_2007. lv_file = lo_excel_writer->write_file( lo_excel ). OPEN DATASET lv_default_file_name FOR OUTPUT IN BINARY MODE. TRANSFER lv_file TO lv_default_file_name. CLOSE DATASET lv_default_file_name.