This project provides a PL/SQL API that allows the user to generate fully functional Excel documents. The API generates Excel XML 2003 documents. The API supports custom styles, formulas, multiple worksheets, etc ... Excel documents can be streamed directly through a web browser or streamed to a file.
文 件 列 表
installUtil.sql A Simple Method for Creating Excel Reports using the ExcelDocumentType.doc EmployeeReportDemo.sql ExcelDocTypeUtils.pkg ExcelDocumentTypeGTT.udt PLSQLExcelObject.zip EmployeeReportDemo_file_based.sql
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.003487s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.127278s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002692s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002819s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002482s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003685s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002290s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003231s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014802s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002633s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 220647 [ RunTime:0.001191s ]