Support » Plugin: WP DataTable » Using data from Excel or csv file as input

  • Resolved Stefan Sebechlebsky

    (@ssebech)


    Hi,
    how could we use table data from an Excel or csv file (e.g. in Uploads directory) as input for this plugin?
    Stefan.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author samsk

    (@samsk)

    No this is not possible. You can try it with TablePress, but it requires manual import of file before displaying.
    Easiest solution for automated displaying would be probably to read the file in php, display it as html table and maybe apply datatable to it to make it sortable etc..

    Found this little plugin:
    https://wordpress.org/plugins/csv-to-html/
    which works together with WP DataTable – place shortcodes of both of them in the same page/post.
    Just add html_id=”ID” in the csv-to-html shortcode. In case of csv created by Excel, also add csv_delimiter=”;”

    Plugin Author samsk

    (@samsk)

    Ok, thanks for sharing your solution.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Using data from Excel or csv file as input’ is closed to new replies.