topic Re: error in excel generation using OLE in Application Development and Automation Discussions

error in excel generation using OLE

former_member209807 — Fri, 12 Feb 2016 09:17:30 GMT

HI Experts,

i am using ole concept to download excel with multiple tabs(dynamic).

after the file is downloaded it is not having no of sheets specified.

i using below code

SET PROPERTY OF gv_excel 'SheetsInNewWorkbook' = lv_line.

can anyone help...?

thanks.

Re: error in excel generation using OLE

Former Member — Fri, 12 Feb 2016 11:46:06 GMT

For each new sheet that you require you should be using the method Sheets.Add on an OLE object that is a workbook.

To find out how to do things use the macro recorder in Excel and then translate the VBA to ABAP.

Regards

Rich

Re: error in excel generation using OLE

davis_raja — Sat, 13 Feb 2016 10:03:03 GMT

Use the below code to add new sheets

GET PROPERTY OF gs_wbook 'Sheets' = gs_sheets .

CALL METHOD OF gs_sheets 'Add' = gs_newsheet .

SET PROPERTY OF gs_newsheet 'Name' = gv_sheet_name .

Also refer the below link for more commands

Re: error in excel generation using OLE

Former Member — Mon, 15 Feb 2016 08:36:59 GMT

Isn't that what I just said ?

Re: error in excel generation using OLE

former_member209807 — Fri, 04 Mar 2016 08:57:28 GMT

thanks for your suggestion.

i am using below code .

   CREATE OBJECT gv_excel 'EXCEL.APPLICATION'.

   SET PROPERTY OF gv_excel 'VISIBLE' = 0.

   CALL METHOD OF
       gv_excel
       'WORKBOOKS' = gv_workbook.

   CALL METHOD OF
       gv_workbook
       'ADD'.

   SET PROPERTY OF gv_excel 'SheetsInNewWorkbook' = lv_line_tmp.

sometimes i am getting number of sheets mentioned and sometimes i am getting only 2/3 sheets.

thanks for your help

Re: error in excel generation using OLE

Former Member — Fri, 04 Mar 2016 09:18:12 GMT

The problem with OLE and excel is that when you use the 'QUIT' statement it does not actually quit Excel and you end up with hundreds of invisible excel instances running. It may be that you have a problem with that when you are getting the 2/3 sheets only. When this happens check in your task manager to see if that is the case.

Rich

Re: error in excel generation using OLE

former_member209807 — Fri, 04 Mar 2016 09:27:36 GMT

thanks for your response.

so when we run the program which creates excel all the excel instances in background should be closed..?

thanks,

Phanindra

Re: error in excel generation using OLE

Former Member — Fri, 04 Mar 2016 09:42:34 GMT

No,

I'm just pointing out that if you have been testing this all day you could have hundreds of instances running which could affect things. I'm trying to remember how I killed them off... let me think about that.

Re: error in excel generation using OLE

former_member209807 — Thu, 17 Mar 2016 12:26:04 GMT

hello,

thanks for your help,

i am still facing this issue.

do you remember how to kill excel instance, for proper file creation.

thanks again...:)

Regards,

Phanindra G

Re: error in excel generation using OLE

Former Member — Thu, 17 Mar 2016 13:48:59 GMT

Can't remember off of the top of my head, you call the QUIT method. Search the web - there's loads of stuff out there about this.

Rich