topic Re: How to access Excel file stores by using OAOR. in Application Development and Automation Discussions

How to access Excel file stores by using OAOR.

Former Member — Mon, 30 Aug 2010 06:36:05 GMT

Hi ,

We have got following requirement:

We need to store an Excel template on application server. We have to create Excelsheet by using this template and need to save it on application and presentation server.

Solution:

We have thought of doing this, by using BDS i.e. T code OAOR. We are able to upload the Excel template by using OAOR, but we don't know, how to access those Excel template in a program , Edit them and then generate an Excel file.

So following are the main queries:

How to acess an Excel template in program, stored in BDS using t code OAOR?

How to edit or create an Excelsheet using this template?

Regards

Re: How to access Excel file stores by using OAOR.

Former Member — Wed, 01 Sep 2010 09:02:35 GMT

Hi Folks,

I am bit confused about my question.

Did i ask wrong question or do i need to ask it in different forum?

Regards

Re: How to access Excel file stores by using OAOR.

Olivier_S — Wed, 01 Sep 2010 09:31:11 GMT

Not sure whether this will do, but this was features on the homepage a while ago:

http://code.google.com/p/abap2xlsx/

Re: How to access Excel file stores by using OAOR.

Former Member — Wed, 01 Sep 2010 09:35:19 GMT

Hi Oli,

Thanks for your reply. But this links does not suits my requirement.

Regards

Re: How to access Excel file stores by using OAOR.

Former Member — Wed, 01 Sep 2010 09:47:59 GMT

Hi,

I have found some wiki which explains me, how we can use BDS concept to generate Excelsheet using Template.

Here is the Link:

http://wiki.sdn.sap.com/wiki/display/ABAP/HandlingDatainExcelIn-placeDisplayUsing+BDS

But i am getting following issue after implimenting a test program:

I am trying to store an Excel template through BDS and then trying to read that template to generate an Excel sheet on presentation server.

For testing pupose i used given program. Except the module pool part, i have written the same program as given in the link mentioned in the Wiki.

Everything is going right, i am getting Sy-subrc = 0 for every method or FM call. But the Excelsheet is not generated. Program just executes successfully without generating any Excelsheet.

When i debugged the porgram. it gave me following url:

SAPR3://SAPR3CMS/get/700/BDS_5FDB2_5FR/CF4620D538358A4B939975C020BE4EFC/TABLE_20TEMPLATE.xlsx

But i don't know , how to find this document( If it has been generated). And everytime i run program, it gives me the same URL.

Could you please tell me , that whyt could be the reason that, i am not able to generate the Excelsheet even though everything seems to be executing properly.

Regards