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
Showing results for 
Search instead for 
Did you mean: 
Read only

Upload multiple journals via Excel

Former Member
0 Likes
490

Dear All,

I want to Upload multiple journals via Excel file into SAP.

Will you please let me know how to do this, it would be greatfull if you can send some code.

Thanks in Advacne,

Ramana

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
461

Hi,

use your "normal" upload and after OPEN set this:

  • Set First Workdsheeet

CALL METHOD OF H_EXCEL 'Worksheets' = H_WORK EXPORTING #1 = 1.

PERFORM ERR_HDL.

CALL METHOD OF H_WORK 'Activate'.

PERFORM ERR_HDL.

Hope it helps.

Regards, Dieter

2 REPLIES 2
Read only

Former Member
0 Likes
462

Hi,

use your "normal" upload and after OPEN set this:

  • Set First Workdsheeet

CALL METHOD OF H_EXCEL 'Worksheets' = H_WORK EXPORTING #1 = 1.

PERFORM ERR_HDL.

CALL METHOD OF H_WORK 'Activate'.

PERFORM ERR_HDL.

Hope it helps.

Regards, Dieter

Read only

Former Member
0 Likes
461

Hi,

Check the following link it may help you:

Regards,

Bhaskar