getting zeros in heading

Former Member — Thu, 15 Mar 2007 07:40:07 GMT

Hi all,

This is my code to download the content of report to Excel,Problem i am getting when trying to put heading for numerical fields .Its getting '0' in the heading .For remaining Fields which are non-numberic its displaying nicely.Could any one solve this for me.

report zt11.

data : itab type mard occurs 0 .

select * from mard into table itab .

data: it_t001 type t001 occurs 0,

it_fields type dfies occurs 0 with header line,

begin of it_fnames occurs 0,

reptext like dfies-reptext,

end of it_fnames.

CALL FUNCTION 'GET_FIELDTAB'

EXPORTING

LANGU = SY-LANGU
ONLY = ' '

TABNAME = 'MARD'

WITHTEXT = 'X'
IMPORTING
HEADER =
RC =

TABLES

FIELDTAB = it_fields

EXCEPTIONS

INTERNAL_ERROR = 1

NO_TEXTS_FOUND = 2

TABLE_HAS_NO_FIELDS = 3

TABLE_NOT_ACTIV = 4

OTHERS = 5

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

loop at it_fields.

it_fnames-reptext = it_fields-reptext.

append it_fnames.

endloop.

CALL FUNCTION 'EXCEL_OLE_STANDARD_DAT'

EXPORTING

FILE_NAME = 'C:\T001'

CREATE_PIVOT = 0

DATA_SHEET_NAME = 'Companies'

PIVOT_SHEET_NAME = ' '
PASSWORD = ' '
PASSWORD_OPTION = 0

TABLES

PIVOT_FIELD_TAB =

DATA_TAB = itab

FIELDNAMES = it_fnames

EXCEPTIONS

FILE_NOT_EXIST = 1

FILENAME_EXPECTED = 2

COMMUNICATION_ERROR = 3

OLE_OBJECT_METHOD_ERROR = 4

OLE_OBJECT_PROPERTY_ERROR = 5

INVALID_FILENAME = 6

INVALID_PIVOT_FIELDS = 7

DOWNLOAD_PROBLEM = 8

OTHERS = 9

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

short dump : unable to interpret the "..... " as number.

Re: getting zeros in heading

Simha_ — Thu, 15 Mar 2007 07:45:18 GMT

Hi,

It seems u have commented the field names parameter in the F.M,

uncomment and check it...

Chers,

Simha,

Re: getting zeros in heading

Former Member — Thu, 15 Mar 2007 07:46:50 GMT

Hi,

Please change your user settings to such number format (system->User Profile->own data->(tab defaults)) 112,333,22.222

This excel export is able to handle only such number format

Regards,

Wojciech

Message was edited by:

Wojciech Gasiorowski

Re: getting zeros in heading

Former Member — Thu, 15 Mar 2007 07:48:35 GMT

Hi Narasimha,

Just I am trying all options.I have to uncomment it.Still the problem is there.

topic Re: getting zeros in heading in Application Development and Automation Discussions

getting zeros in heading

Re: getting zeros in heading

Re: getting zeros in heading

Re: getting zeros in heading