WPReportBuilder - The plugin doesn't seem to be able to handle sheets with tabs.
If there are 3 sheets/tabs inside an excel file, and in the second sheet/tab you have some variables...the plugin doesn't seem to be able to differentiate tabs and it outputs the to first tab how it wants instead of the second tab where the variables actually exist...
This is a big fault and creates more work, is there any way to fix this?
Unfortunately, that is correct. Our plugin, and this add-on are still not able to read data from multiple Excel sheets, so only the first one will be used.
There's no workaround for this, but our developers have this planned for the future. Unfortunately, I don't have any ETA for this.
Can you please put a +1 on this for the developers? It creates more work if you can't use the actual template that needs to be filled resulting in the client having to copy and paste contents from 1 export into the actual template that needs to be filled possibly causing loss of data or wrong data if the rows and columns aren't copied properly...
I wanted to leave this out of the hands of the client and have WP Report Builder handle it...now its kind of back to square one if there still needs to be human interaction which can lower the integrity of the data if the data in the exported report needs to be copied and pasted into one of the sheets of another excel file
You can't use multiple sheets for creating tables from an external data source, nor can you use multiple sheets in the Report Builder templates - it simply won't work.
I don't know how you got it to populate the second sheet - I haven't been able to do that in my tests. Can you send me the table, and the template, so I can try it out?
It was a weird case but I got it to work in an ok manner. I was able to get the client to use the exported workbook with the data in the first sheet...the other sheets had to be completely empty for this to work.
Because for some reason, even though the variables are in the first sheet...the data was getting outputted in the second sheet...I think it might have been because the second sheet had similar column names to the first sheet, all in all the I think the plugin should be improved to be able to handle multiple sheets.
I had a fast look into the code and I think what might be causing the delay is that you guys are working with abandoned PHPOffice libraries: https://github.com/PHPOffice/Common
This will get more unwieldy as it seems that it doesn't have PHP 8.0 support which within the next year or two will start becoming standard. Look how long this pull request has been open: https://github.com/PHPOffice/Common/pull/34
Please encourage the devs to migrate to PHPSpreadsheet and PHPWord which seems to be what the PHPOffice team is focusing their time on:
At the moment, we're still using an older version of PHPWord, which (as a dependency) has the Common library.
In the latest version of PHPWord, this dependency has been removed, but in order for us to switch to it, the whole Report Builder add-on needs to be tested thoroughly. We do have this planned, but at the moment it's not a priority.
As for the PHPSpreadsheet, the switch to it has been made back in 2018 - that is for the spreadsheet builder. It's no longer in the lib of reportbuilder because it's using wpDataTables'.
Please feel free to add this to our feature suggestion page as our developers prioritize requests based on the number of requests, so more requests (votes) this feature has - more likely it's going to be developed sooner.
WPReportBuilder - The plugin doesn't seem to be able to handle sheets with tabs.
If there are 3 sheets/tabs inside an excel file, and in the second sheet/tab you have some variables...the plugin doesn't seem to be able to differentiate tabs and it outputs the to first tab how it wants instead of the second tab where the variables actually exist...
This is a big fault and creates more work, is there any way to fix this?
Hello TheLoneDev
Unfortunately, that is correct. Our plugin, and this add-on are still not able to read data from multiple Excel sheets, so only the first one will be used.
There's no workaround for this, but our developers have this planned for the future. Unfortunately, I don't have any ETA for this.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Can you please put a +1 on this for the developers? It creates more work if you can't use the actual template that needs to be filled resulting in the client having to copy and paste contents from 1 export into the actual template that needs to be filled possibly causing loss of data or wrong data if the rows and columns aren't copied properly...
I wanted to leave this out of the hands of the client and have WP Report Builder handle it...now its kind of back to square one if there still needs to be human interaction which can lower the integrity of the data if the data in the exported report needs to be copied and pasted into one of the sheets of another excel file
I will forward this as another suggestion vote for this feature to be developed, but I can't promise any ETAs, unfortunately.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello again.
You can't use multiple sheets for creating tables from an external data source, nor can you use multiple sheets in the Report Builder templates - it simply won't work.
I don't know how you got it to populate the second sheet - I haven't been able to do that in my tests. Can you send me the table, and the template, so I can try it out?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
It was a weird case but I got it to work in an ok manner. I was able to get the client to use the exported workbook with the data in the first sheet...the other sheets had to be completely empty for this to work.
Because for some reason, even though the variables are in the first sheet...the data was getting outputted in the second sheet...I think it might have been because the second sheet had similar column names to the first sheet, all in all the I think the plugin should be improved to be able to handle multiple sheets.
I had a fast look into the code and I think what might be causing the delay is that you guys are working with abandoned PHPOffice libraries: https://github.com/PHPOffice/Common
This will get more unwieldy as it seems that it doesn't have PHP 8.0 support which within the next year or two will start becoming standard. Look how long this pull request has been open: https://github.com/PHPOffice/Common/pull/34
Please encourage the devs to migrate to PHPSpreadsheet and PHPWord which seems to be what the PHPOffice team is focusing their time on:
https://github.com/PHPOffice/PHPWord
https://github.com/PHPOffice/PhpSpreadsheet
Thanks for that, I already shared it with our developers.
We are planning code refactoring in the future, and I believe this will be changed soon. I cannot make any guarantees, though.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Any updates on this?
Hello again.
As far as I know, no progress has been made for this, but I did send the inquiry to our developers. As soon as I hear from them, I'll get back to you.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello TheLoneDev
At the moment, we're still using an older version of PHPWord, which (as a dependency) has the Common library.
In the latest version of PHPWord, this dependency has been removed, but in order for us to switch to it, the whole Report Builder add-on needs to be tested thoroughly. We do have this planned, but at the moment it's not a priority.
As for the PHPSpreadsheet, the switch to it has been made back in 2018 - that is for the spreadsheet builder. It's no longer in the lib of reportbuilder because it's using wpDataTables'.
Please feel free to add this to our feature suggestion page as our developers prioritize requests based on the number of requests, so more requests (votes) this feature has - more likely it's going to be developed sooner.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables