OLE Multi Sheet Excel Upload
I am working on a Service Contract Creation program to upload data from multiple sheets of an excel file.
I had referred this code
The code works fine as expected but the problem is somtimes it takes only partial data ie Out of 3 sheets data for only two sheets are getting populated and the third internal table remains blank as a result incomplete data gets uploaded in the database.
Can you please let me know why I am facing this problem is there any issue with excel sheet or something else??
Thanks & Regards,