使用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屋！