If there is a requirement to produce output from an application into Excel, you would probably create a CSV (Comma Separated File) with the data and start Excel to show the data - at least that's what I did...until now. The drawback of this solution is that you could only produce data and no nice layout. But Excel is also capable of opening HTML-files and using this you could create Excel files with data and magnificent layout! Let me give an example: 1. Create a procedure to show the data in formatted in an HTML table. CREATE OR REPLACE PROCEDURE display_emp_list IS v_emp_count NUMBER(5); v_empno NUMBER(8); v_ename VARCHAR2(50); v_job emp.job%TYPE; v_sal emp.sal%TYPE; v_bg_color VARCHAR2(10) := ''; CURSOR c_emp IS SELECT empno, initcap(ename), job, sal FROM emp ORDER BY ename; BEGIN SELECT COUNT(*) INTO v_emp_count FROM emp; owa_util.mime_header('application/ms-excel', FALSE); htp.p('Content...
Comments
a nice example, but i doesn't work work correct in Opera, the small images are displayed strange.
The example at http://interface.eyecon.ro/demos/fisheye.html works correct in Opera, so maybe there is some bug in your implementation?
http://www.macobserver.com/article/2008/10/08.9.shtml
Does the MacMenu also work in Apex 4.0 ?
can you please explain from were the CSS file should be created, is this from your page were the MacMenu is located or is this from the http://interface.eyecon.ro/demos/fisheye.html page.
And where soould the function call
to the jQuery 'start' function be created ?
regards,
Marco
can you please explain me the last step(4. Add a function call to the jQuery 'start' function:).
I am not getting where to insert the jquery code in apex.
Whether in dynamic action or Application process or In HTML Header of the page?
So please guide me on this flow.
Regards
Sharath SN
snsharath88@gmail.com
Banglore(India)