topic Re: OLE Multi Sheet Excel Upload in Application Development and Automation Discussions

OLE Multi Sheet Excel Upload

Former Member — Thu, 03 Jan 2013 03:28:54 GMT

Hello Friends,

I am working on a Service Contract Creation program to upload data from multiple sheets of an excel file.

I had referred this code

http://wiki.sdn.sap.com/wiki/display/Snippets/Multiple+sheet+Excel+Document+from+SAP+using+OLE

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,

Nishit Shah

Re: OLE Multi Sheet Excel Upload

Former Member — Thu, 03 Jan 2013 05:04:18 GMT

Hi Nishit,

Check this link

http://wiki.sdn.sap.com/wiki/display/Snippets/OLE+program+for+converting+to+multitab+excel

Regard's

Smruti

Re: OLE Multi Sheet Excel Upload

Former Member — Thu, 03 Jan 2013 05:11:42 GMT

Your Reference Purpose :

Check dis one also..

http://wiki.sdn.sap.com/wiki/display/Snippets/Read+multiple+sheets+of+an+Excel+file+into+SAP+through+ABAP

Regard's

Smruti

Re: OLE Multi Sheet Excel Upload

Former Member — Thu, 03 Jan 2013 10:04:34 GMT

Hi Smruti,

I am already having the code for multiple sheet upload the problem I am facing is some times the data from the excel sheet is not getting captured in the internal table , the program is not behaving in a consistent manner

http://wiki.sdn.sap.com/wiki/display/Snippets/Multiple+sheet+Excel+Document+from+SAP+using+OLE

Kindly refer the above link

Thanks & Regards,

Nishit Shah

Re: OLE Multi Sheet Excel Upload

Former Member — Thu, 03 Jan 2013 11:26:12 GMT

Hi Nishit,

As per the link which is u Refer it is download the data into Excel sheet into three different Worksheet .

but you asking for Uploading the data into Database from Excel sheet (is it right ?)

"Service Contract Creation program to upload data from multiple sheets of an excel file."

Regard's

Smruti

Re: OLE Multi Sheet Excel Upload

Former Member — Mon, 07 Jan 2013 08:48:32 GMT

Hi Smruti,

Kindly refer to this link

https://wiki.sdn.sap.com/wiki/display/Snippets/Read%20multiple%20sheets%20of%20an%20Excel%20file%20into%20SAP%20through%20ABAP

Thanks & Regards,

Nishit

Re: OLE Multi Sheet Excel Upload

Former Member — Mon, 07 Jan 2013 09:05:00 GMT

Yeah Nishit,

i already provided dis link to u , my above conversation . , and also test dat code working f9..no issue..

Regard's

Smruti

Re: OLE Multi Sheet Excel Upload

Former Member — Wed, 09 Jan 2013 10:27:18 GMT

Hi Nishit,

I'm not sure about your initial problem. Do you miss Sheet3? If this is the case, you should know the following:

In the sample you referred to (MULTIEXCEL) the comment "* Create second Excel sheet" do not mean that a new sheet is created. It's only activating an already existing sheet.

In that example all 3 sheets are created by the command "CALL METHOD OF workbook 'Add'.". In this case it's creating the number of sheets, specified als default in Excel Options. If the number of sheets is set to 2, you'll only get 2 sheets and the third one is missing. You can change this by either using

SET PROPERTY OF application 'SheetsInNewWorkbook' = 3. "(ATTENTION: This will change the default setting in Excel !)

before you add the workbook by "CALL METHOD OF workbook 'Add'.", or use the

CALL METHOD OF application 'Add'.

to add additional (missing) sheets.

If you want save the current setting for SheetsInNewWorkbook, you should retrieve the current value by GET PROPERTY and reset it to the origional value after your "CALL METHOD OF workbook 'Add'.".

I hope this helps.

Regards

Detlev