Thread Starter
A13
(@a13)
Would also like to add as a side note, after uploading either an .xlsx file or a .csv file, the table editor page becomes almost completely unresponsive.
I am looking forward to this as a new feature!
Hi,
thanks for your question, and sorry for the trouble.
Yes, date formats are still tricky at the moment, as Excel has different ways of storing them. The internal value (that TablePress reads is that 41472 number). Excel however knows from other information that this is a date and converts it. I’ll need to see if I can do the same in the plugin.
About the “Edit” screen being unresponsive: That’s most likely caused by the size of the table. For large tables, the browser usually is unable to handle the large amount of input fields and just slows down 🙁
I do have some ideas on how to change this, but until that is possible, you’ll need to edit such large tables in Excel and import/replace the table after each change.
Regards,
Tobias
I assume the importing of dates using Excel hasn’t been resolved yet. Is there a workaround? Sometimes the dates are correct and other times they aren’t.
For example, I’m seeing the following dates in Excel being imported as shown:
2/6/1901 => 03/14/2037
5/6/1901 => 06/11/2037
5/9/1901 => 06/14/2037
5/31/1901 => 07/06/2037
10/2/1901 -> 11/07/2037
I have a table with 500 rows and it is too unresponsive to edit in WordPress so I’m wondering if there something I could do in Excel to make it import correctly?
Hi,
thanks for your post, and sorry for the trouble.
No, sorry, those date issues with Excel are not yet fixed. Importing from Excel turns out to be pretty tough, so it might still take a while until that leaves the “experimental” phase.
Now, instead of directly using the .xls or .xlsx formats, I suggest to use CSV here. With that, you an export the table to .csv, make your edits in Excel, save to .csv there again and then re-import that. As the dates in CSV are treated as text, they should never really be influenced/altered by Excel.
Regards,
Tobias
Hi,
First thanks for this wonderful plugin.
When do you plan to resolve this issue with xlsx date format import ?
Thanks and best regards.
Hi,
XLSX import is very tricky, and TablePress relies on an external library for this heavily. As the other import methods usually work here for now, this is not very high on my “to do” list at the moment, so that I can’t give an estimate on when this might be working. Sorry 🙁
Regards,
Tobias
