Home » Fusion Middleware & Colab Suite » Business Intelligence » XML Publisher Excel Template design (R12.2.4)
XML Publisher Excel Template design [message #639653] Mon, 13 July 2015 12:46 Go to next message
P1Oracle
Messages: 60
Registered: August 2014
Location: Hyderabad
Member
Hi every one,
I have a requirement where i need to design excel template in such way that for each 65532 records it should split into new excel sheet..
i have tried using BI publisher desktop but cannot split into multiple excel sheets where as data is truncating to 65532 records, i did some google and went through metalink id's in oracle support but didn't find exact solution for this..Please help me anybody..
i am using following applications:
R12.2.4
BI Publisher Desktop 11 version
ms-office 2007
Re: XML Publisher Excel Template design [message #639655 is a reply to message #639653] Mon, 13 July 2015 13:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
This is NOT an Oracle problem, but a Microsoft problem.
Newer versions of Excel do not have any such row count limitation.
besides Excel can directly connect to any ODBC compliant RDBMS & issue SQL against the DB

https://www.google.com/webhp?hl=en&tab=ww#hl=en&q=excel+row+limit
Re: XML Publisher Excel Template design [message #639656 is a reply to message #639655] Mon, 13 July 2015 13:12 Go to previous messageGo to next message
P1Oracle
Messages: 60
Registered: August 2014
Location: Hyderabad
Member
Hi sir,
thanks for the reply..
Even though i am using ms-office 2007 it shouldn't truncate to 65532 record isn't?..
Re: XML Publisher Excel Template design [message #639657 is a reply to message #639656] Mon, 13 July 2015 13:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
you can lead some folks to knowledge, but you can make them RTFM
Re: XML Publisher Excel Template design [message #639658 is a reply to message #639657] Mon, 13 July 2015 13:40 Go to previous messageGo to next message
P1Oracle
Messages: 60
Registered: August 2014
Location: Hyderabad
Member
IS the way to give a answer..??
Re: XML Publisher Excel Template design [message #639659 is a reply to message #639658] Mon, 13 July 2015 13:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you are ever dissatisfied with the tone, tenor, completeness, correctness, or timeliness of any response,
please submit your request for a prompt & full refund to /dev/null
Re: XML Publisher Excel Template design [message #639661 is a reply to message #639659] Mon, 13 July 2015 15:20 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As you use Excel 2007 and it supports 1,048,576 rows per sheet (as well as all higher versions up to date), there shouldn't be any problem.

(Here is a nice table which shows Excel limits regarding number of rows/columns so - have a look).
Previous Topic: Case Statement Month Rank
Next Topic: Error Message appears when attempting to save an Analysis
Goto Forum:
  


Current Time: Fri Mar 29 02:13:42 CDT 2024