Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
working on datatables right now. Uploading an excel or converting it to a csv messes all formatting up as far a number values are concerned. It will change "." to a comma, some values to random numbers, etc I have around 70 pages to do. I am attaching the excel file so you can see for yourself. Thank you
Hi joshuadbroadwater,
Thank you for your purchase.
Formatting from Excel file will be lost in wpDataTables (Colors, Fonts, Borders...).
Can you tell me exactly what columns did not import well in wpDataTable so I can take a look?
When you import the numbers would change and add a . or , where they shouldn't be. So for example the column ceiling a number should be 39.99 and it will import to 39,99. IF you have two columns the same name it will also import only one. I went ahead and changed column type to string and that fixed the problem on the periods instead of commas
Hi Joshua,
"When you import the numbers would change and add a . or , where they shouldn't be. So for example the column ceiling a number should be 39.99 and it will import to 39,99."
- You can choose Number format on wpDataTables settings page. You can select comma to be decimal separator or to be thousand separator.
"IF you have two columns the same name it will also import only one."
- Yes, all columns should have different name in Excel file. Later when you create wpDataTable you can change names of the columns in Display Header and you can call them whatever you want.