topic Re: Interactive list - export to excel in Application Development and Automation Discussions

Interactive list - export to excel

Former Member — Tue, 28 Nov 2006 09:38:00 GMT

i'm using the FUNCTION 'MS_EXCEL_OLE_STANDARD_DAT' for export to excel.

how to make excel treat the numeric values as text values?

there is alignment problem for different numbers and text field values.

eg. numbers in excel are aligned to the right, text in excel aligned to the left.

i'm thinking of adding ' (apostrophe) to number...

but problem again..

eg. for the matnr field... it may contain fields like "00000123", "0023", "54".."abc".."abc00"...

how to get rid of the zeros?

Cheers,

Charles

abap newbie

Re: Interactive list - export to excel

Former Member — Tue, 28 Nov 2006 12:55:07 GMT

Hi,

to get rid of the leading zeros you may map from internal (= database) to external (= presentation) format by using fm CONVERSION_EXIT_ALPHA_OUTPUT before you add apostrophes.

Regards

Re: Interactive list - export to excel

Former Member — Tue, 28 Nov 2006 12:56:32 GMT

hi,

I guess there is a command PACK which would remove the leading zeros. try using that.

santhosh

Re: Interactive list - export to excel

Former Member — Tue, 28 Nov 2006 13:07:45 GMT

Hi Charles,

I dont think formatting in excel is possible from the Function Module. I think the best solution here is to create your final internal table with only character variables. Move all the data into this table where the numeric values should be trimmed off with leading zeros using the function module(CONVERSION_EXIT_ALPHA_OUTPUT).Finally pass this final internal table to the function module which will download in the excel format.

Please let me know for any clarifications required.

Regards,

Swaroop

Re: Interactive list - export to excel

Former Member — Wed, 29 Nov 2006 02:14:38 GMT

how do i output the single quote '

eg... DATA: addchar VALUE '"'.

double quote no problem...but what about single quote?

what's the special character?

Thanks,

Charles

abap newbie

Re: Interactive list - export to excel

Former Member — Wed, 29 Nov 2006 02:25:26 GMT

ohhh...found out about the single quote...

using double single quotes..

solved

Thanks,

Charles

abap newbie

Re: Interactive list - export to excel

Former Member — Wed, 29 Nov 2006 03:10:36 GMT

Managed to insert the ' doesnt seem to solve the problem...

the output in exel will display the ' until the user manually click and enter the field in excel to be recognised as numeric..

For ALV export to excel output, everything seems ok.

So, is there a better export to excel function to solve this alignment and formatting issue when I use list instead of ALV?

Thanks,

Charles

abap newbie

Re: Interactive list - export to excel

roy_deng — Wed, 29 Nov 2006 04:32:18 GMT

If possible ,you can try like as this : FIELDCAT-edit_mask = '''__________' .

Re: Interactive list - export to excel

Former Member — Wed, 29 Nov 2006 06:51:17 GMT

care to share what u meant by that?

Thanks,

Charles

abap newbie

Re: Interactive list - export to excel

Former Member — Fri, 01 Dec 2006 01:33:16 GMT

So, is there a better export to excel function to solve this alignment and formatting issue when I use list instead of ALV?

Thanks,

Charles

abap newbie