As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #1949834
Importing data from Excel but some cells are formulas
Closed

Comments

  • Lucas Daniel Flores started the conversation
    March 26, 2019 at 8:36pm

    I want to create a table using imported data from an Excel, but my question of what if some cells has formulas instead of plain numbers? Will that import work? How can be done? Any documentation to read?

  •  472
    Isidora replied
    March 27, 2019 at 10:10am

    Hi Lucas,
    Thank you for your interest in wpdatatables.

    When working with Excel-based tables, please note 2 things:

    1. Formulas and merged cells are not supported,
    2. They generally work slower than CSV-files, or even Google Spreadsheets; so if your table is large, it is much better to port it to a different format, or – even better – to MySQL table (you can use “Create a table by importing data from data source” to import your Excel file to MySQL).

    What we have is Formula (calculated) columns.

    We have Lite version of wpdatatables which you can try for free.

    wpDataTables Lite is a basic version of a popular best-selling WordPress table plugin. While some premium features are reduced, wpDataTables Lite is still quite a handy tool that allows you to quickly create tables in WordPress from different sources. You can download it from this link.

    Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.

    All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables