I have a sizeable excel document with around 10 sheets with different columns and different data.
Is there any way for me to use the same backend uploaded file to extract different datasets or do I have to upload the Excel workbook each time?
I think there is a newish plug-in for this called Excel sheet importer. It is listed as working with DSS V7.0
I've not used this personally. However, it looks cool. Will this do what you need?
I invite you to let us know how you get on with this. If you run into problems let us know.
In addition to the plug-in @tgb417 suggested, the following approach is an option. Although it doesn't require a plug-in, it may be less flexible.
Create a folder to upload the Excel file to (new Dataset, "Folder", store into filesystem folders). Upload the file to that folder.
Then from the vertical 3 dots menu for the file (hover over the file to see it), choose Create a Dataset. Click the Test button and then click on the Format / Preview tab. You can choose the Excel tab here. Create the dataset. Repeat this process for other Excel tabs.