Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
No option to output format in excel 2007+ .xlsx
Hello!
From my online research online (I'm not an MS history expert) - "XLS and XLSX extensions represent popular Excel file formats that were introduced by Microsoft as part of its Office suite over a period of time. XLS being the oldest and widely used file type is also known to be the Excel97-2003 file format. The XLSX file format was introduced as a replacement of XLS file type with the launch of Excel 2007."
The issue is, the older format has been blocked for use now on our systems, we can't open the files.
We did ask 2 years ago in this post although have been guide to ask the question in this forum -
Answers
-
Hi Kevin,
Thank you for asking your question in the Oracle Analytics Community.
Can you please share what oracle product you are using and the product version - the earlier post you mentioned is for Fusion HCM Application, for Fusion Product OTBI questions you should post in following FA-OTBI community
For BIP please post your question in following community:
thank you
0 -
Thank you :)
I have posted in the forums and added our application version,
Cheers
Kevin
0 -
Is yours a Publisher question?
Double posting is something that isn't well accepted in the forum, ideally this question should have been moved to the right category, but you weren't informed correctly about it.
Now the question is to figure out if yours is a purely Publisher question (and therefore the one in OTBI isn't useful), or if you meant some other kind of object than a Publisher report (making the Publisher question not useful).
0 -
Every time I post I seem to be told to post it somewhere else… my first post was 2 years ago but nothing seems to have helped…
We need to export to xlsx instead of xls in both BI Publisher and OTBI to be fair…
Cheers
Kevin
0 -
I can understand the frustration of just being moved left to right without replies…
I actually can't open the post you did 2 years (I have access denied, some parts of that forum are weirdly restricted if you don't signup to the newsletter of that product or things like that), therefore I couldn't see what it was about.
So, starting with Publisher, you have a question posted in this forum in the Publisher category, with some luck it will get somewhere. But I have the impression that category doesn't have huge traction for now.
What you could do is to post the question as well in : it's a different forum than what you used so far, and there you could get somewhere.
Then, for the OTBI part, knowing I don't have OTBI, is that exporting an analysis or a dashboard page? I believe to remember OTBI is OBIEE with a number of prebuilt content, but technically it is still OBIEE under the hood. Export formats didn't change for the past 10+ years, so not sure there are lot of options in there… But the "Excel 2007+" format is xlsx files as far as I can remember and it's available in OBIEE for both analyses or dashboard or dashboard pages by default: isn't it the case in OTBI?
0 -
And while this isn't going to help you much, this seems to be a topic posted every few months in all kind of forums (some for Fusion, some for Publisher, some for OBIA).
There seems to have been SRs raised, leading to ERs, but no idea if they ever got implemented.
Apparently it goes down to: "you can get XLSX files if you use the right template, but XSL templates can't generate XLSX files". And that's what a number of ideas and questions were about.
It sounds like you will maybe not have a direct answer because it involves a number of different products as well (you aren't using just Publisher, but Publisher embedded with other products, therefore there could be a number of limitations involved).
0 -
Thanks for supporting @Gianni Ceresa
Arjun has provided a workaround document in this post -
I have shared this with my team so we can check if this will work well for BIP outputs for our company (Doc ID 1645176.1)
Fingers crossed,
Cheers
Kevin
1
