on 05-07-2008 10:47 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
SAP supplied a note to fix this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.