Many thanks for providing this feature, I am using this in my application and it’s working pretty well without any problem.
But I have a small problem, when user try to download data more than 65536 rows (Excel limit) then it will discard the rows, which crossed the upper limit. I am just thinking that is there is any possibility that the remaining rows will automatically move to the new worksheet?
Thanks once again for all your help, really such a great stuff.
I installed your package on XE, APEX 3.1.
Everything is OK, except the columns heading in xls file.
In explanation, every second column has no heading, but has data (data are displayed correctly), so my table looks incorrectly because heading name dont match with data below it.
I checked all installation procedure and i think i did everything correctly.
I installed this package in APEX 3.1 on 10gR2. Everything is OK, even columns heading.
I have a question about then new interactive report feature in APEX 3.1. It would be very nice if i could use this package instead of Oracles CSV export.. (I don't have BI publisher). Do you have any plans for that?
Just downloaded and installed package. Works great, but would like some assistance with one small annoyance (probably something that I have caused). Some of my columns in the Excel file are displayed as text fields rather than numbers (which is how they are stored in the DB table).
I install excel package and when I download excel I have this error: Report Header Error: ORA-06502: PL/SQL: numerischer oder Wertefehler: character string buffer too small / -6502.
I need help to fixe this error !
Interesting. I think a variable within the package is not big enough to accept the value.
Haven't seen this before. How many columns do you have in your report? Have you tried
excluding some of them? Unfortunately, I am on the road now and have no access to all
of the tools I need to look into the problem.
I am just starting out with this excel package, and I am finding it very useful so thanks for creating it. I am in the process of trying to customise it, and had 2 quick questions:
1. Is there any way that I can specify a landscape page layout?
2. What type of code is the package creating for excel to use? XML?
Your export works almost ;-) perfect. Only one thing happens which I can't explain.
My report contains a date field, when I open the XLS file in excel, the date has been become a number (01-01-2006 becomes 38718). I've tried to put a to_char around the date, but the number stays in excel. I don't know if it is a excel option (coulden't find it) or if apex is pulling my leg.
You are right. Bernhard Kahles did some changes on the package and you can download
the newest version from my demo application. You need to enable pdf printing on the report
and there you can also include or exclude the columns you want to show. The package is
now also showing the dates properly. See this example: