I've gone through so many links on the web about importing/exporting excel files. Here is some of them:
https://technology.amis.nl/2013/01/19/read-a-excel-xlsx-with-plsql/
https://technology.amis.nl/2011/02/19/create-an-excel-file-with-plsql/
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/260104953
Read Excel file from PL/SQL
ORA-00001: Unique constraint violated: Working with Office 2007 (OOXML) files using PL/SQL
Basically, I have excel file already imported into BLOB column. Now, I'm looking for a solution that converts it into a table. Most of the links above are about writing/reading excel files into/from directory (Please correct me if I'm missing something). The file is already in BLOB. Is is possible from there to read it and write it into Oracle table?
Currently what I have is, I import the file into BLOB using APEX, and I can import it into table via apex_collections. However, it has the limitation of 50 columns max. I want bypass that collection (this is not APEX question). I've got the file in binary format in the table, I want to convert it directly (or via several steps) to a table. Do I have to write it first into the directory using one of the options above, and then write back into a table (external table -> oracle table) ?
Appreciate it if you can direct me into the right direction