BI Export to Excel not translating

[Former Member]

Hi -

I am able to export to Excel from BI 7.0 on the MAC, but when I open the file it looks like MIME.

Thanks for any insight.

Ann

[gregor_kolck]

Hi ,

in our context it worked, when exports are generated to xls 2000 format.

This can be done in the web application with command EXPORT XLS2000 , for example:

                <bi:BUTTON_GROUP_ITEM name="BUTTON_GROUP_ITEM_1" designheight="23" designwidth="300" >

                    <bi:BUTTON_LIST type="ORDEREDLIST" >

                        <bi:BUTTON type="COMPOSITE" index="1" >

                            <bi:CAPTION value="EXPORT XLS2000" />

                            <bi:ACTION type="CHOICE" value="INSTRUCTION" >

                                <bi:INSTRUCTION >

                                    <bi:EXPORT >

                                        <bi:EXPORT_FORMAT value="XLS2000" />

                                    </bi:EXPORT>

                                </bi:INSTRUCTION>

                            </bi:ACTION>

                        </bi:BUTTON>

                    </bi:BUTTON_LIST>

                </bi:BUTTON_GROUP_ITEM>

See also

http://help.sap.com/saphelp_nw70/helpdata/de/44/85de4943af5919e10000000a1553f7/frameset.htm

Best Regards

Gregor

[Former Member]

Will SAP or Microsoft address this issue? As you mentioned, the file opens fine in the Windows Operating System version of Excel, but does not in the Mac OS version of Excel. The other Excel files that I use can be opened in either version.

[Former Member]

Hello... I know it's be a while since this note was posted, but can you provide the note that SAP recommended to fix this problem? Many thanks.

J

[Former Member]

Hello,

We are facing the same Problem. I can not find the related note. Can someone advise, what is the note number that related to this u201CExport to Excel erroru201D on Mac?

Than you in advance,

Mikko

[Former Member]

Hi,

There is one SAP Note which says :

09.11.2011 Page 1 of 2

SAP Note 1548060 - Export to Excel in Mac OS results in

MHTML display

Note Language: English Version: 1 Validity: Valid Since 12.01.2011

Summary

Symptom

When you export to excel in Mac OS, the excel contains the MHTML codeinstead of actual data. However it does not happen for Microsoft Excel2000.

Other terms:

Excel 2000, excel 2003, excel 2008 excel 2011, XML, MIME type.

Reason and Prerequisites:

This is not a program error. In general, the import of Excel 2003 (andabove) HTML/XML format was not supported for Excel on MAC OS. However Excel2000 format will be supported for Excel on Mac OS where you can exportplain text and tables (but not applicable for charts and maps as MIMEs are not included by Microsoft).

Solution

This is due to a restriction from Microsoft. Hence it is not possible touse this feature in Mac OS currently.

Header Data

Release Status: Released for Customer

Released on: 14.01.2011 12:25:26

Master Language: English

Priority: Recommendations/additional info

Category: Consulting

Primary Component: BW-BEX-ET-WJR-EXP Export Services and Printing

Secondary Components:

BW-BEX-ET-WJR BEx Web Java Runtime

The Note is release-independent

Related Notes

SAP Note 1548060 - Export to Excel in Mac OS results in

MHTML display

Number Short Text

1177022 7.30 NW SP 02 Patch Level (PL) 01 for BI Java

Edited by: mohan kumar on Nov 9, 2011 7:54 AM

[Former Member]

SAP supplied a note to fix this.