Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to check if Excel File is already open or Not

former_member15804
Participant
0 Kudos
334

HI ,

I am using ALSM_EXCEL_TO_INTERNAL_TABLE to upload the File . But if mistakanly File gets opened it stuck in between , before checking the sy-subrc value only . So is there any way we can check if File is already open or not and give a error mesg.<br>Thanks
3 REPLIES 3

abo
Active Contributor
175

Other than formatting the question in such a way that I don't have to scroll into the neighbouring country to read it 😉 I don't know what to say.

Oh, yeah, I do: don't use that function, it is not released to customers. You can use abap2xlsx and a direct replacement for that function is shown in ZDEMO_EXCEL15. A complete table-upload method is in the works.

former_member15804
Participant
0 Kudos
175

Thank you Andrea and sorry for the inconvenience.

The FM abap2xlsx is not therr in my system and the program is not worked according to my requirement.

I have to upload the data from excel file and before that i just need to check if the file is already closed or not.

Hope i m clear

abo
Active Contributor
0 Kudos
175

Of course it is not in the system, that's why I gave you the link to the source 🙂