Skip to Content
0
Former Member
Dec 20, 2006 at 03:51 PM

Create new excel worksheet

173 Views

Hi all,

Kinldy let me know how to create a new worksheet if the records exceeds 65536 rows in excel.

Im using FM MS_EXCEL_OLE_STANDARD_DAT.

call function 'MS_EXCEL_OLE_STANDARD_DAT'

exporting

file_name = filepath

create_pivot = 0

data_sheet_name = 'Material List'

  • pivot_sheet_name = 'Material List1'

  • PASSWORD = ' '

  • PASSWORD_OPTION = 0

tables

  • pivot_field_tab =

data_tab = it_bom_final

fieldnames = out

Am i missing any parameters in the FM or need to add additional logic??

Regards,

Senthil