topic Re: ABAP2XLSX. Blank sheets in Application Development and Automation Discussions

ABAP2XLSX. Blank sheets

former_member51857 — Mon, 23 May 2011 14:34:47 GMT

I download the project form code exchange.

When I run the demo reports all the files are empty.

When I debug the internal tables are filled.

Whe trying to open the file in excel I recieve a message that the file format is wrong.

Any idea what I did wrong.

Thanks

Frances

Re: ABAP2XLSX. Blank sheets

Former Member — Wed, 25 May 2011 12:08:13 GMT

Is your Excel version correct? XLSX is only in Excel 2007 and later, I think.

Re: ABAP2XLSX. Blank sheets

former_member51857 — Wed, 25 May 2011 12:29:20 GMT

Thanks for your reply.

My excel version is 2007.

Re: ABAP2XLSX. Blank sheets

former_member182670 — Wed, 25 May 2011 13:36:11 GMT

Hi,

Which version of abap2xlsx are you using, released or daily build?

What is the version of your SAP application server?

Could you paste exact message from excel?

Re: ABAP2XLSX. Blank sheets

former_member51857 — Wed, 25 May 2011 14:11:59 GMT

I hope this is wat you asked.

This is the first time I try this.

I download version 3 of abap2xlsx.

Application Server AIX6.1 Version 5.

When I run the demo program ZDEMO_EXCEL I recieve a message

"0 bytes transfer."

All the demo files are downloaded in the folder .

Example: 03_iTab.xlsx

When I open the file messaga.

"Excel cannot open the file '03_iTab.xlsx'' because the file format or file extension is no valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

We upgrade to office 2007 a year ago. Is there something that needed to change op SAP to convert to office 2007?

Re: ABAP2XLSX. Blank sheets

former_member182670 — Wed, 25 May 2011 18:43:01 GMT

Hi,

I was asking about version of SAP (6.40, 7.00 ...)

What is the size of 03_iTab.xlsx on the disk? is it 0 bytes?

If you debug ZDEMO_EXCEL3 is lt_file_tab empty or filled when calling cl_gui_frontend_services=>gui_download?

Re: ABAP2XLSX. Blank sheets

former_member51857 — Thu, 26 May 2011 06:23:39 GMT

Sorry.

We are on ECC 6.0 (EHP3)

Sapgui 720

When I debug table lt_test have 109 lines.

But none in lv_file and lt_file_tab.

ls_table_settings-table_style = zcl_excel_table=>builtinstyle_medium2.

ls_table_settings-show_row_stripes = abap_true.

lo_worksheet->bind_table( ip_table =

is_table_settings = ls_table_settings ).

lo_worksheet->freeze_panes( ip_num_rows = 3 ). "freeze column headers when scrolling

column_dimension = lo_worksheet->get_column_dimension( 'E' ). "make date field a bit wider

column_dimension->set_width( 11 ).

CREATE OBJECT lo_excel_writer TYPE zcl_excel_writer_2007.

lv_file = lo_excel_writer->write_file( lo_excel ).

Convert to binary

lt_file_tab = cl_bcs_convert=>xstring_to_solix( iv_xstring = lv_file ).

lv_bytecount = XSTRLEN( lv_file ).

Regards

Frances

Re: ABAP2XLSX. Blank sheets

gregorw — Thu, 26 May 2011 07:37:52 GMT

Hi Frances,

as you're using the old 3.0 Version I would suggest that you update to the 4.0 Version which was released just recently: https://cw.sdn.sap.com/cw/releases/21?container=1016. Then please let us know about the results.

Best regards

Gregor

Re: ABAP2XLSX. Blank sheets

_IvanFemia_ — Thu, 26 May 2011 07:48:27 GMT


>   lo_worksheet->bind_table( ip_table          =  
>                             is_table_settings = ls_table_settings ).

Hi Frances,

It's just a copy and paste error that no data object is assigned to ip_table?

Could you please try only demo1 that is the simplest demo?

Is the interface ZIF_EXCEL_WRITER correctly implemented in class ZCL_EXCEL_WRITER_2007, sometimes saplink has problems and you need to import the nugget twice.

Let us know.

Regards,

Ivan

Re: ABAP2XLSX. Blank sheets

former_member51857 — Thu, 26 May 2011 10:01:31 GMT

Thanks for all the help.

Ivan,

The problem was with interface ZIF_EXCEL_WRITER. I just copy the coding into the method.

Now only ZDEMO_EXCEL15 gave an error.

Information on where terminated

Termination occurred in the ABAP program "ZCL_EXCEL_WRITER_2007==

in "CREATE_CONTENT_TYPES".

The main program was "ZDEMO_EXCEL15 ".

In the source code you have the termination point in line 135

of the (Include) program "ZCL_EXCEL_WRITER_2007=========CM002".

The termination is caused because exception "CX_SY_REF_IS_INITIAL

procedure "CREATE_CONTENT_TYPES" "(METHOD)", but it was neither h

nor declared

in the RAISING clause of its signature.

The procedure is in program "ZCL_EXCEL_WRITER_2007=========CP ";

code begins in line

1 of the (Include program "ZCL_EXCEL_WRITER_2007=========CM002 ".

SOURCE CODE:

132 lo_element_root->append_child( new_child = lo_element ).

133

134 " Worksheet node

>>>>> lv_worksheets_num = excel->get_worksheets_size( ).

136 DO lv_worksheets_num TIMES.

137 lo_element = lo_document->create_simple_element( name = lc_xml_node_ov

138 parent = lo_document ).

Regards

Frances

Re: ABAP2XLSX. Blank sheets

former_member182670 — Thu, 26 May 2011 11:09:16 GMT

Definitely looks like installation problem.

As Ivan suggested I'd recommend importing latest NUGG once again and activation of all objects.

Re: ABAP2XLSX. Blank sheets

former_member51857 — Thu, 26 May 2011 13:26:14 GMT

I download the tatest NUGG and activation of all objects.

All demos are working.

Thanks for your help.

One last question. How do I transport all this to the QA and production systems.

Regards

Frances

Re: ABAP2XLSX. Blank sheets

former_member182670 — Thu, 26 May 2011 13:30:04 GMT

By design SAPLink imports all objects as local ones.

You can go to SE80 , select Local Objects from the drop down on the left and assign all the abap2xlsx objects to some transportable package.