topic Delete sheet from excel file using ABAP in Application Development and Automation Discussions

Delete sheet from excel file using ABAP

Former Member — Wed, 20 Dec 2006 09:05:50 GMT

Dear All,

I am facing problem of deleting SHEET from excel file.

Situation,

I am creating excel file with sheet 1 and sheet 2 with data. When I create excel default system will create sheet 1 to 3.

Here I dont want sheet. so I am trying to delete using

But system is popping confirmation msg with OK and cancel buttons.

Please help me how to handle this...

or any way to delete sheet from excel file...

Thnaks

Rays

Former Member — Wed, 20 Dec 2006 09:07:47 GMT

what is the class you are using to call the method?

pavan

Former Member — Wed, 20 Dec 2006 09:11:17 GMT

GO TO SE 37 SEARCH FOR FUNCTION MODULE WITH NAME STARTING FROM

ALSMDELETEFILE/SHEET

Former Member — Wed, 20 Dec 2006 09:36:41 GMT

Hi Pavan,

I declared as

*Declaration for Excel

DATA: APPLICATION TYPE OLE2_OBJECT,

WORKBOOK TYPE OLE2_OBJECT,

SHEET TYPE OLE2_OBJECT,

CELLS TYPE OLE2_OBJECT,

H_F TYPE OLE2_OBJECT. " font

And I created excel file and saved success fully....Only thing I want is I need to delete extra sheet.

Thanks & regards,

Rayudu

Former Member — Fri, 22 Dec 2006 01:04:54 GMT

I didnot get delete methord attributes...

I found alternative solution i.e I set visible property of the sheet to 2.

Its not visible any more..

Rays