Question Re: ABAP2XLSX delete row in Technology Q&A

ABAP2XLSX delete row

oliver_am — Thu, 25 Apr 2024 07:38:09 GMT

Hello, all.

I'm trying to use ABAP2XLSX.

I want to print the content of an internal table in an excel sheet.
But the method bind_table is printint also a header, and I dont want a header of the columns.
(I've tried to modify the code of the method, but is not working fine...)

With the method SET_TABLE i have a dump, because the internal tabla has no dictionary structure...

So, in the end i'm trying to use BIND_TABLE method and then remove the header row, but I cannot find any method in class ZCL_EXCEL_WORKSHEET to delete a row.

Any tip?
Thanks in advance.

Re: ABAP2XLSX delete row

oliver_am — Thu, 25 Apr 2024 08:29:15 GMT

In the end I've created a new method SET_INTERNAL_TABLE copied from SET_TABLE but changing the line

lo_tabdescr->get_ddic_field_list(

with:

lo_tabdescr->get_components( )

I'll add a new parameter fieldcat to add more functionality to this method.

Regards

Re: ABAP2XLSX delete row

pokrakam — Thu, 25 Apr 2024 08:54:50 GMT

Untested, but from memory it's something like:

data(sheet) = excel->get_active_worksheet( ).
data(row) = sheet->get_row( 1 ).
sheet->get_rows( )->remove( row ).

Re: ABAP2XLSX delete row

abo — Thu, 25 Apr 2024 11:55:35 GMT

Please consider submitting any changes upstream: if you modify the library on your system, you'll miss out on portability and you'll be on your own for updates.