Posts

Showing posts from May, 2007

Render Excel Spreadsheet in IE

A while back we had a requirement to generate a lot of heavily formatted Excel type reports out of our application. The users also wanted this integrated seamlessly into the application so that when the report was run, it displayed in the same Internet Explorer window. After a bit of research and plenty of goggling, we came up with this solution (this demo uses a copy of the emp table from the Scott schema): Appologies in advance if the SQL / PL/SQL or HTML format gets a bit messed up but it should compile ok. N.b. I must first point out that this only works in Office 95/2003 and IE. Firefox will generate the report but opens Excel to do so. Please take any of this code and extend it to support Office 2007 and Firefox. It is only meant as a guide / proof of concept. Credit for this one goes to my colleague David Blake as he did the lifting on this one. Create this package (I create this in its own schema and have a public execute but creating it in the schema you are working is