Yes, Importing multiple sheets from Excel files is not possible through the plugin's built-in features at this time.
There is a way, however, to upload those files to Google Spreadsheets and then You'd be able to create a table for each sheet, because Google Sheets have a separate URL for every sheet.
You can read about creating tables from Google Spreadsheets on this link.
Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.
All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.
I have an excel workbook that contains multiple sheets. 1 sheet collects data while other sheets perform calculations based on the data entered.
Will wpdatatable support this usage? How can I set this up within wpdatatables?
Sorry...guess I just needed to look a little further as this has already been answered here: https://tmsplugins.ticksy.com/ticket/1818711/
Hi darrmik,
Thank you for your interest in wpdatatables.
Yes, Importing multiple sheets from Excel files is not possible through the plugin's built-in features at this time.
There is a way, however, to upload those files to Google Spreadsheets and then You'd be able to create a table for each sheet, because Google Sheets have a separate URL for every sheet.
You can read about creating tables from Google Spreadsheets on this link.
Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.
All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables