My ask is to load 10 excel sheets ( 7 xlsx and 3 xls) into an Oracle table. In each of these excels, there are three worksheets - A , B and C. I need to load B from each of them. The structure of B is exactly same.
Your solution asks us to use Dynamic XLSX. When I put the sheet names that I do not want to use, ( A and C ) , it is giving me this error - The field ' Sheet names' is not contained in the record.
I am also having a problem with .xls files. I have a few workbooks that each contain a single sheet but the sheet name varies from month to month. Is there a way to bring in whatever sheet is available for this file type as well?