How to work with DOI to download data to Excel template

[former_member249594]

Dear Friends,

Now I am developing a report program to download data to Excel. We need to use DOI techniques because of better perfermance and more easy to maintain the Excel template. But I don't know how to do it because I have not work with this technique before. Any frieds can give me some tips/useful linkages/example on below issues:

1/ How to upload the excel template to SAP server

2/How to call the excel template and fill the data to it in my ABAP program.

Please help. Thanks very much in advance.

Best Regards

Joe

[Former Member]

Hi Joe,

Make use of the Function Module "ALSM_EXCEL_TO_INTERNAL_TABLE

" to upload your excel file content into an internal table. Before that you need to declare an internal table which has the same structure as the excel file columns.

There is a Type-pools "Truxs". You can also make use of this. There are a number of simple Function Modules in that for this excel related works.

Thanks,

Madhan.

[former_member249594]

Hi Madhan

Can this FM open the Excel template in SAP server and display in user front-end? And how can I upload the excel template to our SAP server?? Thanks.

Best Regards

Joe