Export to MS Excel - Column Headers of Key and Name are Merged

[Former Member]

In all Bex Reports we have the following Problem:

When export the report to MS Excel the column headers are merged to one cell. See attached screen-shot

Is there any chance to change the Excel export in a way that we don't get merged cells?

Thanks a lot for you help

Kai

[Former Member]

Hello Kai,

I believe you cannot control this to split the header in separate columns.

So, this splitting is not possible.

Br,

H

[former_member223480]

Hi Kai

I haven't seen yet if you can do something with the export, but i believe is more easy to add the attribute name and have together key and attribute instead of the text. In that way i believe you will have separately the column headers. But it will be only for customer in the specific report.

Thank you

Yiannis

[lou_matura1]

Kai.

In the case that you have presented, Vendor includes both the key and text.  It separates the 2 correctly for the actual data, but for the header is considered as 1 item.  As it is displayed in your example, it is correct.

The only way that I can think of getting around this is to add in another field that contains vendor number and display one as key, and the other as text.  This will give you the "Vendor Number" and "Vendor Name" that I assume you are looking for in the title.

Lou

[Former Member]

Hi Lou

Thanks for your answer. So you're saying there is no way to influence the format of the excel sheet that is exported appart from changing the query?

Regards

Kai

[lou_matura1]

Hi Kai.

The way that I see it, you have 4 choices available to you.

1. Leave it as is.  Technically, from an accounting perspective, it is correct, to show the cells merged in this fashion.
2. Change the title headings of the export so that you have separate Vendor Number and Vendor Name titles.  You could write a macro to do this operation.
3. Change the query if you have something available as mentioned previously.
4. Change the datasource table so that you have something like vendor number that is tied to vendor so that you can do the display of vendor number and vendor name.

It ulitmately depends on costs.

What I had done in the past was option 1 (and yes, it annoyed me) but I educated the end users as to the way it is.  If the end user wanted to change the output, then it was their perogative to do so.

Lou

[Former Member]

Lou, thanks again. I think dont understan option 2 and how I could acieve that.

My point is I know the other options but I really whould like to change the excel export without changing anything else or at leat understand if that is not porssible at all.

Regards

Kai

[lou_matura1]

Hi Kai.  Basically, use the Excel functionality to unmerge the cells...  Basically 1 cell now becomes 2.  Label the 1st cell as Vendor Number and the 2nd as Vendor Name.

Lou