topic Re: smartforms abap in Application Development and Automation Discussions

smartforms abap

Former Member — Sun, 25 Mar 2007 19:09:41 GMT

how to insert excel sheet into main window of smartform.

thank u,

Re: smartforms abap

Former Member — Mon, 26 Mar 2007 01:17:35 GMT

Hi, MANOJ KUMAR VADDEPALLY.

You can't insert any excel sheet into main window of smartform.

Looks like your mean template or table structure in smartforms

You could insert template or table in main window and then, use pattern of it.

I wish I could help you.

Best regards

Kyung Woo.

Re: smartforms abap

Former Member — Fri, 30 Mar 2007 21:41:55 GMT

Its not possible direclty...

You will have to upload the Excel file using the Function module 'GUI_UPLOAD'. Then, pass this internal table to the main window appropriately....

Hope this helps u

Reward points if useful

Regards

Re: smartforms abap

Former Member — Sat, 31 Mar 2007 11:32:35 GMT

Hi,

use the FM ALSM_EXCEL_TO_INTERNAL_TABLE to upload the excel file into an internal table and then by using this internal table u can print the datd into the smart forms....

All the best,

Bhaskar

Re: smartforms abap

RaymondGiuseppi — Sat, 31 Mar 2007 11:43:03 GMT

Smartforms create spools (remember Adobe pdf format was a printer spool format at the beginning)

So you cannot include XLS in a spool.

You have to create a Table in your form.

Regards.

PS: Look at <a href="http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVSCRSF/BCSRVSCRSF.pdf">SAP Smart Forms</a>