Home » Fusion Middleware & Colab Suite » Business Intelligence » Opening XML Report in EXCEL 2007 IN EBS 11i
Opening XML Report in EXCEL 2007 IN EBS 11i [message #532729] Thu, 24 November 2011 03:31 Go to next message
Messages: 54
Registered: June 2011
Hi Experts,

I am working with EBS 11i and database 9i. I am working on XML Publisher reports, i have a XML Publisher report with output in EXCEL, generating millions of records. Since EXCEL 2003 has constraint on no of records, it's not able to accomodate beyond it's capacity. If i can open the output EXCEL 2007 instead of 2003, I think i can solve my problem since EXCEL 2007 capacity is more.

My question is, is there anyway we can open the EBS11i XML Publisher report in EXCEL 2007. If yes, could you guys please help me, otherwise, any alternative solution to this or any suggestions are helpful.

Thanks in advance.

Re: Opening XML Report in EXCEL 2007 IN EBS 11i [message #532798 is a reply to message #532729] Thu, 24 November 2011 14:49 Go to previous message
Messages: 21647
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, Excel 2010 sheet is limited to 1,048,576 rows (which means that lower versions are at their best equal to or even lower than that value) so ... you might still have problems if your output contains millions of records. What would you do with that many records in Excel, anyway?
Previous Topic: OBIEE 11g newbie - need guidelines
Next Topic: XML Publisher, unable to display from outergroup
Goto Forum:

Current Time: Mon Jan 18 11:54:24 CST 2021