ADF11g从Excel导入到Table.doc

ADF 11g : Import From Excel Into an ADF Table ADF 11g provides an “export to excel” feature that allows you to take data from an ADF table into an excel sheet. But what about the other way around. Sometimes you need to work with excel sheets or comma separated values, and load the content of such a file into a database table. You could use the external table feature of the Oracle Database for that, or you just use any tool to load the csv contents into a database table. The use case I have is that the data in the csv needs to be validated and changed before it is committed into the database. In this post I show you how to load the csv contents into an ADF table component so you can edit the data before committing Setting up the application This post is based on a simple table and on a simple csv file. The Staff table definition is here:  HYPERLINK http://technology.amis.nl/blog/8418/adf-11g-import-from-excel-into-an-adf-table \l viewSource \o view source view source  HYPERLINK http://technology.amis.nl/blog/8418/adf-11g-import-from-excel-into-an-adf-table \l printSource \o print print HYPERLINK http://technology.amis.nl/blog/8418/adf-11g-import-from-excel-into-an-adf-table \l about \o ? ? 1CREATE TABLE ALS_STAFF 2??(  3????ID??????????? NUMBER(3,0), 4????FIRST_NAME??? VARCHAR2(20 BYTE),  5????LAST_NAME???? VARCHAR2(30 BYTE), 6????EMAIL_ADDRESS VARCHAR2(100 BYTE),  7????CONSTRAINT ALS_STF_PK PRIMARY KEY (ID) ENABLE 8??)And the csv file  HYPERLINK http://technology.amis.nl/blog/8418/adf-11g-import-from-excel-into-an-adf-table \l viewSource \o view source view source  HYPERLINK http://technology.amis.nl/blog/8418/adf-11g-import-from-excel-into-an-adf-table \l printSource \o print print HYPERLINK http://technology.amis.nl/blog/8418/adf-11g-import-from-excel-into-an-adf-table \l about \o ? ? 1ID,FRST_NAME, LAST_NAME,EMAIL 2100,Peter,Jones,testmail@  3101,John,Janssen,a-testmail@ 4102,Thomas,Higgins,b-testmail@  5