Hi there, we are having an issue loading a table. Screenshot attached of the error that shows up when loading the table which then creates a "critical error" on the page the table is on.
The excel sheet has a couple columns that need to be empty for now (these numbers are not available yet as its something tracked monthly, so future months have no data ).
Is there a way to upload the excel sheet with these fields empty or other?
In the file you shared there is a missing header in the first column which is most likely causing this issue. It is OK for some cells in the column to stay empty but all columns need to have a header in order to be properly read by the plugin.
Also it is worth mentioning that formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.
If you need to show numbers as integer or float but still have the percentage sign please remove the percentage sign from the source file and also empty values as - and when you create table you can add cell prefix or suffix in column settings.
Hi there,
we are having an issue loading a table.
Screenshot attached of the error that shows up when loading the table which then creates a "critical error" on the page the table is on.
The excel sheet has a couple columns that need to be empty for now (these numbers are not available yet as its something tracked monthly, so future months have no data ).
Is there a way to upload the excel sheet with these fields empty or other?
Thanks!
Hi Michael
Thank you for reaching out to us.
Could you please send us the source file so we can try and recreate this locally and try to find a solution?
Heres the table:
https://www.melissinostrading.com/wp-content/uploads/2021/06/Webpage-Chart-Data-Performance-Table-2.xlsx
Hi Michael
In the file you shared there is a missing header in the first column which is most likely causing this issue. It is OK for some cells in the column to stay empty but all columns need to have a header in order to be properly read by the plugin.
Also it is worth mentioning that formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.
If you need to show numbers as integer or float but still have the percentage sign please remove the percentage sign from the source file and also empty values as - and when you create table you can add cell prefix or suffix in column settings.