Skip to main content
Question

Dynamic Excel Sheets reading

  • December 4, 2017
  • 1 reply
  • 16 views

Forum|alt.badge.img

I need to implement to load one Excel file into AWS RDS Database. And Excel file have multiple sheets and one sheet have 65000 records. And I don't know how many sheets will be come based on dividing sheets with 65000 records for one file. I searched google and FME knowledge. There is the similar answer which is using Generic Reader for loading all dynamic sheets. But it is not working using Generic Reader. Thus, I would like to ask the way to load dynamic excel sheets from one file to load into the database.

1 reply

fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • December 5, 2017
Hi @jasonjungict, can you elaborate on how it's not working with the Generic Reader? Are you seeing errors or is the behaviour not what you intended?

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