(IR) Report to Excel (xlsx)
(IR) Report to Excel (xlsx) Tweet |
|
|
Categories:
Process Type Plugin
Download the output of your report as an Excelfile This plugin uses the source queries of all report regions on a page, either a clasic or interactive, new version 0.806 Special Requirements Changelog: version 0.806 support for Wizard Report support for SQL Report based on a PL/SQL function body returning SQL query XML-escaping for string data and sheetnames version 0.804 support for timestamp and clob filename changed from anton.xlsx version 0.802 fixed a bug on 11.2 databases version 0.800 initial version Keywords
Excel, process type |
Share on Digg
Save This Page
|
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first. Reviews / Questions / Comments are e-mailed to the author of the Plug-in. |
@chandrashekar
by Anton Scheffer
on April 5, 2012
You can't do that with this plugin.
how to display item value as a header
by chandrashekar
on April 5, 2012
Hi,
I am using your plug in and it's works great,
but i need to display some item value(ex: sysdate as a header) as a header part in excel file..
how i can acheive this? please help me on this...
regards
Chandran
I am using your plug in and it's works great,
but i need to display some item value(ex: sysdate as a header) as a header part in excel file..
how i can acheive this? please help me on this...
regards
Chandran
Wrong number of columns selected in the
by Rajesh Nag
on March 16, 2012
Hi I am getting Wrong number of columns selected in the LOV SQL query for Download File. See examples for valid statements.
Contact your application administrator.
Could you please help me how do i fix it
Regards,
Rajesh
Contact your application administrator.
Could you please help me how do i fix it
Regards,
Rajesh
Excel does Auto Correct
by Thor
on January 17, 2012
Well I used the number Format in Apex. But after I open Excel it says "Number saved as text". I have Euro currencys in my sheet. After clicking in a cell excel realzised the number format. It is working with the demo application. But these values are without decimal seperator.
@Sunil Sindal
by Anton Scheffer
on December 14, 2011
I'm sorry, I have no idea
Help with FUNCTION_RETURNING_SQL_QUERY
by Sunil Sindal
on December 14, 2011
Hi,
This pluggin is really helpful to me.
But i am facing the problem with the report of type FUNCTION_RETURNING_SQL_QUERY.
my query is a plsql block returns varchar2 and also contains the bind values.
I tried and even resolve the issue that Alfredo faced but getting new error as ORA-01008: not all variables bound .
Could you please help me in resolving the same.
Thanks
This pluggin is really helpful to me.
But i am facing the problem with the report of type FUNCTION_RETURNING_SQL_QUERY.
my query is a plsql block returns varchar2 and also contains the bind values.
I tried and even resolve the issue that Alfredo faced but getting new error as ORA-01008: not all variables bound .
Could you please help me in resolving the same.
Thanks
@Alfredo Ordoñez Hdz
by Anton Scheffer
on November 4, 2011
The last time I got an error with this plugin it showed the my email-adres in the error message
Help with FUNCTION_RETURNING_SQL_QUERY
by Alfredo Ordoñez Hdz
on November 4, 2011
Hi!
The plugin works fine with report query but when i try to create an excel file from FUNCTION_RETURNING_SQL_QUERY it sends an error ORA-06512: en línea 381, can you help me please?
Tx in advance, I debug my app but how can send you the file?
The plugin works fine with report query but when i try to create an excel file from FUNCTION_RETURNING_SQL_QUERY it sends an error ORA-06512: en línea 381, can you help me please?
Tx in advance, I debug my app but how can send you the file?
@Tom
by Anton Scheffer
on October 18, 2011
Thanks for the compliments.. A lot of the code I used for this plugin is used in package. This pacakge can be used to generate excel-files, see http://technology.amis.nl/blog/10995
Great Plugin
by Tom Raudabaugh
on October 18, 2011
Anton,
Your plugin code has been invaluable for my project of producing mult-tabbed worksheets. I was able to add new styles, color code columns, insert dates, etc into the exported workbook. I ended up converting the plugin to a callable stored procedure and passing in the desired page.
Thanks Again,
Tom
Your plugin code has been invaluable for my project of producing mult-tabbed worksheets. I was able to add new styles, color code columns, insert dates, etc into the exported workbook. I ended up converting the plugin to a callable stored procedure and passing in the desired page.
Thanks Again,
Tom
| Powered by Sigsiu.NET |  |