Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

System goes to not respond while uploading multiple sheets excel

manojmathi
Explorer

‎2017 May 22 6:28 AM

0 Likes
3,191

Hi,

I have a scenario to upload multiple sheets excel to SAP.

On that the program works fine when I choose to upload 25 rows at max., when I choose more than 25 rows the system will hang on or goes to not responding or an information message from SAP says 'Application is not responding or is busy ' .

While debugging the SAP will hang on in 'get_ranges_data' method.

error.jpg

error1.jpgerror2.jpg

If any one know Let me know please,

Regards,

Madhivannan

Preview file
130 KB
Preview file
101 KB
Preview file
186 KB

Hi,

I have a scenario to upload multiple sheets excel to SAP.

On that the program works fine when I choose to upload 25 rows at max., when I choose more than 25 rows the system will hang on or goes to not responding or an information message from SAP says 'Application is not responding or is busy ' .

While debugging the SAP will hang on in 'get_ranges_data' method.

error.jpg

error1.jpgerror2.jpg

If any one know Let me know please,

Regards,

Madhivannan

Reply
6 REPLIES 6
Read only

former_member189059
Active Contributor

‎2017 May 22 7:33 AM

0 Likes
2,835

Try keeping Excel closed before attempting to run the program. Also make sure that the excel process doesn't exist in the Task Manager.

Read only

Former Member

‎2017 May 22 8:30 AM

0 Likes
2,835

As Kris said...

An application not responding message is normally due to an application that is not polite enough to 'doevents' on a timely enough basis. Also, be aware that using the 'Quit' method for excel does not (or did not) used to quit the program properly and is a constant source of this message.

Read only

Sandra_Rossi
Active Contributor

‎2017 May 22 9:46 AM

0 Likes
2,835

You probably did something wrong in your program, but how can we help ? You seem to be using DOI (because of method name "get_ranges_data"). Please tell us what you do.

Read only

manojmathi
Explorer

‎2017 May 22 2:47 PM

0 Likes
2,835

Can you please share your mail id. So that I Can send my codes.

Read only

Sandra_Rossi
Active Contributor

‎2017 May 22 3:15 PM

0 Likes
2,835

No sorry. As per forum rules, the use of the forum implies that the question is fully discussed in the forum and not in private, so that all people seeking for answers can have the whole context and solution.

Please, only attach the relevant code, as a zipped file. Thanks.

Read only

manojmathi
Explorer

‎2017 May 27 5:20 PM

0 Likes
2,834 
Please find the attachment. I have attached my code

code.txt
code.txt