Copy table with border(lines)

[Former Member]

Hi,

The requirement is to copy an HTML table (or excel tables which will have dynamic number of columns and rows) in a Z field in any Z transaction. this table need not be saved as fields and rows in SAP database. It can be saved in just one field. customer wants to copy & paste details given in excel or word in table form in SAP. we are able to copy the text in Z field but the border lines of table does not appear. How can we do this?

Thanks,

Binita

[Former Member]

Hi,

The requirement is to copy an HTML table (or excel tables which will have dynamic number of columns and rows) in a Z field in any Z transaction. this table need not be saved as fields and rows in SAP database. It can be saved in just one field. customer wants to copy & paste details given in excel or word in table form in SAP. we are able to copy the text in Z field but the border lines of table does not appear. How can we do this?

Thanks,

Binita

[koolspy_ultimate]

Hi,

you can you table control wizard in module pool for displaying table format.

or

You can use alv grid display .

Regards,

madhumahesh.

[Former Member]

So I guess you want to display a simple XLS file or word file in a Z-transaction? Let me know if you have a different requirement.

You will need an ALV grid coupled with a dynamic internal table to hold xls/word data. The number of fields in the internal table will depend on the number of fields in the XLS (You can get this by counting the number of tabs +1 ).  For word it can be one large field.

Tab = CL_ABAP_CHAR_UTILITIES=>horizontal_tab.

Search the forum to see how to create/use dynamic internal tables.

Regards,

Shravan

[Clemenss]

Hi Binita,

no code no details no help.

Regards

Clemens