Excel-layout to Smartforms

[Weiskopf]

Dear development team,

I have a requirement to the smartforms with a lot of information (such as article data, info record data, vendor, etc.). For this there is a template in Excel format.

To reduce the effort to design the smartforms Iu2019m looking for an approach to import the excel layout to the smartformsu2019 table structure.

Is there any possibility to import the excel-format (the format is fully reassessed) to the smartforms?

Thanks for your hint.

Best regards,

Kurt.

[Former Member · Accepted solution]

You may use the FM 'ALSM_EXCEL_TO_INTERNAL_TABLE' to transfer your excel data into internal table and code your program accordginly so as to pass internal table data as parameters to your smartforms.

[OttoGold]

Or you can start from scratch using ABAP OLE for Excel or generate XML Excel.

You can understand what to do from these blogs:

/people/otto.gold/blog/2010/02/11/happy-reporting-with-excel-ii

/people/otto.gold/blog/2010/02/09/happy-reporting-with-abap-ole-excel

regards, Otto

[Weiskopf]

Hello to all,

thanks for your useful hint.

Best regards,

Kurt.

[Former Member]

Hi ,

Not possible ..