05-27-2008 11:37 AM
i want to add new tabs to my excel file using abap.... can someone help me on this?
05-27-2008 11:42 AM
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
05-27-2008 11:42 AM
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
05-27-2008 11:50 AM
Hi,
CALL METHOD OF g_worksheets 'Add' = g_worksheet.
U can add shee to excel.
Venkat