从Oracle Apex 4.0.2用户帐户将数据从* .xlsx或* .xls装载到Oracle表 [英] Load data from *.xlsx or *.xls to Oracle table from Oracle Apex 4.0.2 User account

问题描述

我需要使用Oracle Apex 4.0.2用户帐户从Excel文件（ *。xlsx，* .xls ）将数据加载到Oracle 11。

I need some help loading data from Excel Files (*.xlsx, *.xls)to Oracle 11 using an Oracle Apex 4.0.2 User Account.

我找到并修改了一个进程来加载* .cvs文件。此过程的工作方式如下：

I found and modified a process to load *.cvs files. This process works as follows:

1. 将 *。csv 文件加载到 BLOB column。


2. 插入表格后，我执行


3. 此过程将每行插入表

1. Load the *.csv files into a BLOB column.
2. After insert into the table, I execute the
3. This process inserts every row to the table

我想让您帮助我编写一个类似的代码，但不是加载* .csv我想要使用Excel文件

I want you to help me to code a similar code, but instead of loading *.csv I want it to work with Excel files.

Oracle Apex 4.0.2 有一个 Workshop 加载，但只允许 Developers ，并且我想创建此过程以允许 Users

Oracle Apex 4.0.2 has a Workshop to load but it is only allowed to Developers, and I want to create this process in order to allow Users to load data by themselves.

推荐答案

任何原因，你不升级到5.0或至少4.2？ 4.1中增加了数据加载组件，为您提供了快速开发此精确需求的方法。 4.0现在是古代的，不再支持。

Any reason why you don't upgrade to apex 5.0, or at the very least 4.2? The "Data Loading" components have been added in 4.1 and offer you a fast way of developing this exact requirement. 4.0 is ancient by now and no longer supported.

加载xlsx或xls与加载CSV非常不同。再次，我会问，为什么不更新。有可用的插件处理Excel文件到集合，甚至XLSX。再次，虽然，你的顶点版本太低。 你在脚下射击自己 e。不是没有可用的编码选项，但仍然。

Loading an xlsx or xls is vastly, vastly different from loading a CSV. Again, I'd ask, why not update. There are plugins available which process excel files to collections, even XLSX. Again though, your apex version is too low. You're shooting yourself in the foot here. Not that there aren't coding options available, but still.

如果您仍然不希望出于某种任意原因升级，请关注xlsx文件。他们本质上是zip文件与一堆文件。我在2012年撰写了一篇博客。 http://tpetrus.blogspot.be/2012/09/a-non-standard-export-to-excel-2010-xlsx.html

If you still don't want to upgrade for some arbitrary reason, focus perhaps on xlsx files. They're essentially zip-files with a bunch of files. I wrote a blog on this back in 2012. http://tpetrus.blogspot.be/2012/09/a-non-standard-export-to-excel-2010-xlsx.html

它仍然是相关的，我只是链接它，因为它包含所有的代码的勇气。这不是绝对的，尽管有限制。也许有其他方法。对于4.0较少。

It's still relevant and I'm only linking it because it contains all the guts of the code. It's not infallible and has limits though. There's probably other ways, too. Less so for 4.0.

这篇关于从Oracle Apex 4.0.2用户帐户将数据从* .xlsx或* .xls装载到Oracle表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！