ABAP2XLSX delete row

[oliver_am]

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.

[oliver_am · Accepted solution]

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

[abo · Accepted solution]

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.

[pokrakam]

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 ).