One or more columns doesn’t have a header. Please enter headers for all columns

Hello,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

Yes. This is caused by our Plugin’s latest couple of updates, our developers introduced new error checking for tables linked from Excel/CSV Data;
but they are already intensively working on a fix which can resolve this issue.

Can you please send us your source Excel file so that we can inspect it and we will do our best to provide you with a fix as quickly as possible?

If the file does not have any sensitive data, you can upload it to weTransfer and send us a download link here.

If the Excel contains any sensitive data, in that case please open a ticket on our?main Support platform here, and one of our Agents will respond as quickly as possible.

If you don’t have a licence (or if it expired), please open a pre-purchase ticket which doesn’t require a purchase code.

If you wish a quick temporary solution, you can download version?2.1.71?version?here.
Just scroll down to the “Previous Versions”?section and you can ‘downgrade’ your Live site installation to that version since it has the ‘old error checking’.

?Please note?: Previous versions of plugins may not be secure or stable. They are not recommended for use on production websites.

So let us know if you could send us your Excel file, it can help our developers to make a quicker fix when we can gather sample data from our users like this.
Thank you.

Thanks for the reply. The file doesn’t contain sensitive information, and can be found here: https://we.tl/t-oJGj8Txj3I

I have already reverted back to the old version of the app but one of the problems I’ve experienced is that we no longer get access to the filtering options. We bought the plugin in 2018 via Evanto Market place but only the most recent full version can be downloaded. I downloaded the previous version and installed that but it’s just the standard free version, not paid.

Is there a way that we can get a previous version of the paid plugin, so that I can utilise tables again until a fix has been issued?

With thanks,

Andy

Hello,
This Forum is used for Lite Support, so we assumed you were using the Lite/Free Version.

Our developers managed to build a fix for both the Lite and the Premium versions, so we will certainly help you sort everything out.

The Page we sent you is for Lite Users. They can download older Lite Plugin versions there, but for the Premium Plugin users, it is a different process.

We can certainly confirm that we are able to create a Table from your Excel file now ( in both Lite and Premium versions) when we apply the said fix, so on this Forum we will help all Lite users directly, while you can contact our Premium Support and they will help you there to provide the premium version of the fix.

Since you are using our Premium Plugin, please open a private?pre-purchase ticket?which doesn’t require a purchase code, but you can send your Envato Licence key there ( or copy of your Envato invoice) and our Agents will provide you with the fix for the latest full/premium version.


2. For any Lite users that might come across this Post, we will share the instructions on how you can edit our Lite Plugin’s code to apply the fix.
Find this PHP file via FTP or your Hosting File Manager or the Plugin File Editor, in the path :
../wp-content/plugins/wpdatatables-lite/source/class.wpdatatable.php.
Then around line 1754 search with “CTRL+F” for this line :

$headingsArray = $objWorksheet->rangeToArray('A1:' . $highestColumn . '1', null, true, true, true);

Under it, add this :

while (!end($headingsArray[1])) {
    array_pop($headingsArray[1]);
};

So in the end, that part of the code should look like this :

$headingsArray = $objWorksheet->rangeToArray('A1:' . $highestColumn . '1', null, true, true, true);
while (!end($headingsArray[1])) {
    array_pop($headingsArray[1]);
};

Save changes, and purge cache of your Site, then try to load the existing Table/ or link a new Table from the same file and now it should work without throwing the error about empty Headers.

With this sample Excel, we can confirm it works when this fix is applied on both Lite and Premium Plugin versions.

This fix should be included in the next Update, our QA Team is just conducting final tests to ensure there are no negative effects before it is added to the Plugin’s core.

If any Lite/free Plugin user comes across this, and if the fix does not work for you, feel free to open a new Post and send us your source file there;
Or if it has any sensitive data, please open a private Pre-Purchase ticket on our Main Support – so we can debug the issue there.