Skip to main content
Question

how to read files when filenames and path are stored in another datasource (database)

  • January 15, 2019
  • 1 reply
  • 10 views

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 ?

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+50

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings