topic another excel question in Application Development and Automation Discussions

another excel question

Former Member — Mon, 04 Jul 2005 13:30:25 GMT

hi,

I read an excel file like this:

CREATE OBJECT gv_excel 'Excel.Application'.

SET PROPERTY OF gv_excel 'VISIBLE' = 0.

CALL METHOD OF gv_excel 'Workbooks' = gv_books.

CALL METHOD OF gv_books 'Open'

EXPORTING

#1 = p_file

#2 = 1.

...

FREE OBJECT gv_cell.

FREE OBJECT gv_excel.

FREE OBJECT gv_books.

FREE OBJECT gv_sheet.

CALL METHOD OF gv_excel 'QUIT'.

the question is, why the excel process is not kill in the task manager?

joseph

Re: another excel question

RichHeilman — Mon, 04 Jul 2005 13:40:21 GMT

I'm guessing that it may have something to do with the fact that you are freeing the object before you are actually "quitting" it. I think that "freeing" disconnects the pointers? Try moving the FREE statements to after the "QUIT" method.

Regards,

Rich Heilman

Re: another excel question

Former Member — Mon, 04 Jul 2005 13:46:06 GMT

thank you!!

Re: another excel question

andreas_mann3 — Mon, 04 Jul 2005 13:46:54 GMT

Hi ,

i think Rich is right.

another problem could be if you've used an object to

save your data:

like :

CALL METHOD  OF H_EXCEL 'Save' = h_save.

so you've to free this too:

FREE OBJECT H_save.

regards Andreas