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 CAN I ADD NEW WORKSHEET(TAB) TO EXCEL USING ABAP pROGRAM?

Former Member
0 Kudos

i want to add new tabs to my excel file using abap.... can someone help me on this?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

hi,

PERFORM add_worksheet USING 'Test 1'.

&----


*& Form ADD_WORKSHEET

&----


FORM add_worksheet USING i_name.

  • Add new worksheet

IF g_first_ws <> 'N'.

g_first_ws = 'N'.

GET PROPERTY OF g_excel 'ACTIVESHEET' = g_worksheet.

ELSE.

CALL METHOD OF g_worksheets 'Add' = g_worksheet.

ENDIF.

SET PROPERTY OF g_worksheet 'NAME' = i_name.

g_row = 1.

g_col = 1.

ENDFORM. " ADD_WORKSHEET

2 REPLIES 2

Former Member
0 Kudos

hi,

PERFORM add_worksheet USING 'Test 1'.

&----


*& Form ADD_WORKSHEET

&----


FORM add_worksheet USING i_name.

  • Add new worksheet

IF g_first_ws <> 'N'.

g_first_ws = 'N'.

GET PROPERTY OF g_excel 'ACTIVESHEET' = g_worksheet.

ELSE.

CALL METHOD OF g_worksheets 'Add' = g_worksheet.

ENDIF.

SET PROPERTY OF g_worksheet 'NAME' = i_name.

g_row = 1.

g_col = 1.

ENDFORM. " ADD_WORKSHEET

Former Member
0 Kudos

Hi,

CALL METHOD OF g_worksheets 'Add' = g_worksheet.

U can add shee to excel.

Venkat