使用 PL/SQL 创建 xls 文件而无需通过 xml [英] Create xls file using PL/SQL without going through xml

问题描述

我的系统是APEX/Oracle 11g开发的，想直接创建xls文件，不用创建xml文件.系统当前创建了一个xml文件，然后可以保存为xls格式，但是非常挑剔的用户不喜欢尝试打开xml文件时的Windows 7警告(Excel警告该文件的格式与其扩展名不匹配).有没有办法在 APEX 中使用 Oracle PL/SQL 来完成此操作?

My system is developed in APEX/Oracle 11g, and I want to create an xls file directly without having to create an xml file. The system currently creates an xml file which can then be saved to xls format, but the user, who is very picky, does not like the Windows 7 warning when one tries to open the xml file (Excel warning that the format of the file does not match its extension). Is there any way to use Oracle PL/SQL from within APEX to accomplish this?

推荐答案

Morten Braten 整理了一个很棒的 PLSQL 资源页面:http://code.google.com/p/plsql-utils/

Morten Braten has put together a great PLSQL resource page: http://code.google.com/p/plsql-utils/

特别是 Anton Scheffer 分享了他的包 AS_XLSX，它可以满足您的 APEX 需求:http://technology.amis.nl/2011/02/19/create-an-excel-file-with-plsql/

Specifically Anton Scheffer has shared his package AS_XLSX which would meet your APEX needs: http://technology.amis.nl/2011/02/19/create-an-excel-file-with-plsql/

使用起来非常简单，包头中有很好的例子.

Very simple to use with good examples in the package header.

这篇关于使用 PL/SQL 创建 xls 文件而无需通过 xml的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！