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.
Question
Dynamic Excel Sheets reading
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+21- Safer
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?