![]() They even doesn't exists in Inactive Version. I tried to import the nugget ABAP2XLSX_V_7_0_6 and the log shows that the objects are installed successfully, but when I see the objects they doesn't actually exist. TRANSFER lv_file TO lv_default_file_name. OPEN DATASET lv_default_file_name FOR OUTPUT IN BINARY MODE. ![]() CREATE OBJECT lo_excel_writer TYPE zcl_excel_writer_2007. lo_worksheet ->set_cell ( ip_column = 'B' ip_row = 2 ip_value = 'Hello world' ). lo_worksheet ->set_title ( ip_title = 'Sheet1' ). " Get active sheet lo_worksheet = lo_excel ->get_active_worksheet ( ). " File name with path " Creates active sheet CREATE OBJECT lo_excel. 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. ![]() CONSTANTS : lv_file_name TYPE string VALUE '25_HelloWorld.xlsx'. ![]() 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. Lo_worksheet ->bind_table ( ip_table = is_table_settings = ls_table_settings it_field_catalog = lt_fieldcat ). 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. When I check the data placed in the application server I find some garbage values. ![]()
0 Comments
Leave a Reply. |