Forum Discussion
Can we manage to import multiple DTAB from a single Excel which will have multiple sheet of different DTABs.
Suppose I have two DTABs named A and B. I want to maintain a single Excel workbook containing two sheets named A and B. Whenever I need to import a DTAB, it should be retrieved from the workbook by m...
The import process requires a CSV file, and an Excel spreadsheet with multiple tabs cannot be saved as a CSV file, so you would need to create code that automatically split each tab into its own CSV file before loading those in.