Skip to main content
  • EN

Hi everybody,

it seems to be an easy job, but at the end it is taking a lot of time to implement. I have patterns in my oracle database to access and read multiples Excel files, which contains several sheet.

When i access to this database, i get the filename, i cannot call directly the Reader for excel passing the name, sheet name and format.

 

I did some experiment with subroutines (like external calls) but it seems more complicated than expected. How can i read Excel files whose name is in the database without calling another workflow ? which is the logic standing behind this ?

You can read the database with an Oracle reader, then run those features through a FeatureReader so you can construct the filename of the Excel file to be read using the attribute out of the Oracle database.

Reply


Community Stats

30,386
Posts
115,449
Replies
38,184
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.