topic Re: Copy table with border(lines) in Application Development and Automation Discussions

Copy table with border(lines)

Former Member — Fri, 29 Jun 2012 07:22:43 GMT

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

Re: Copy table with border(lines)

koolspy_ultimate — Fri, 29 Jun 2012 07:36:42 GMT

Hi,

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

You can use alv grid display .

Regards,

madhumahesh.

Re: Copy table with border(lines)

Former Member — Fri, 29 Jun 2012 14:32:06 GMT

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

Re: Copy table with border(lines)

Clemenss — Fri, 29 Jun 2012 16:10:36 GMT

Hi Binita,

no code no details no help.

Regards

Clemens