It is not resolved. Please, answear!
This issue is resolved in OBIEE 18.104.22.168, which allows exporting to Excel 2007+, which does not have the 65K rows limit.
Thank you for your answer, but the option exporting in OBIEE 22.214.171.124 to Excel 2007+ is available in OBI Analytics, but in Publisher it's still only one available Excel Format (for Excel Template) xls.
You can try export to CSV and then use MS Access to access this file.
MS Access does not have the limit of 65K rows.
Any ideas to cope with this issue BI Publisher Excel Template Layout Output is Truncating Data to 65536 Rows (Doc ID 1469264.1).
I need some tips to cope with issue. And we need only Excel Template for customer.
I am facing similar problem with XML Publisher Excel output. It is truncating data to 65536, Can you please share the steps you followed to spread the data into multiple sheets by count. I found http://docs.oracle.com/cd/E23943_01/bi.1111/e22254/create_excel_tmpl.htm#BIPRD2844 bit useful but not sure where to call Preprocesser XSLT files In XML publisher.