Export data to Microsoft Office Excel file with WebChart

Links: http://www.dbatools.net/mytools/webchart-excel.html

    WebChart just have limited chart features compared to Microsoft Excel, But we can export data to an Excel file and do more analyze. It require you download Apache POI packages and put it to the tomcat common library directory.

c:\TomcatWebChart\common\lib
/TomcatWebChart/common/lib

    Take the second query in feature overview page.

SELECT Dname, empno, ename, job,
      to_char(hiredate,'yyyy/mm/dd') hiredate
  from dept, emp
  where dept.deptno = emp.deptno order by dname

    Click the download data to excel link, you will get an excel file, and it looks as following.

    It took me quite a long time to add this feature.

Post a comment

Remember Me?

« Previous | Main | Next »

Powered by
Movable Type 4.25