Is there a way for tablepress to only take the data from the table in the excel.

  • Resolved yuktasarode

    (@yuktasarode)


    2 years, 1 month ago

    I am creating a tablepress table in wordpress using an excel file which has a table consisting of 350 rows. So when I import the excel file tablepress creates a table with 1000 rows, basically keeping the rows from 351 to 1000 blank. Is there a way for tablepress to just take the rows which are filled with data in the table inside of excel?

    • This topic was modified 2 years, 1 month ago by yuktasarode.
Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    2 years, 1 month ago

    Hi!

    Thanks for your post and sorry for the trouble!

    Normally, TablePress does only import the rows that contain data. Sometimes, this detection is not working, e.g. if Excel somehow added something (like styling) to a cell in that row 1000.

    As a workaround, you could copy your 350 data rows into a fresh/new Excel file and try again.

    Or, you could save your Excel table to a CSV file and then check if the CSV file only has the desired 350 rows.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Is there a way for tablepress to only take the data from the table in the excel.’ is closed to new replies.