Hi fei,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

 I used Google Translate for some parts of your message, so i apologise if anything got 'lost in translation'.

1. If i understood, you are trying to update an existing Manual Table by uploading your updated Excel file, right?

2. And you pick the option "Add rows to the current table data" ?

If you pick this option, you must not rearange any Column order from your source Excel, and you must not add/remove any Columns or change Header Names.

When you choose to only add new Rows - 

When you click “Save Changes”, a popup window will be shown with an explanation of what will happen next, as you can see in the image below.

As you can see, with this option you’re about to add data from the source file to the existing manual table.

If you have any date-type columns in your file, please make sure that you match the date input format in the Main settings of the plugin to the one you’re using in your source file first. 

If they are different, some data may not be added correctly.

Due to everything mentioned above, our advice is to duplicate your table first before updating, because there is no undo option.

Please note that for this option in the source file you will need to have:

• The same number of columns
• The same names of column headers
• Data (empty file is not allowed)

So please do not rearange the Columns/rename the Headers, or add/remove Columns for that option.

You can see more details explained here how this Feature works :

https://wpdatatables.com/documentation/table-features/update-manual-tables-from-source-files-csv-excel-or-google-sheet/.

3. If you have to rearange or add/remove/rename Header on some Columns on this Table data, and wish to upload an updated file, you can choose a different option :

Replace entire table with source.

With this option - you can do anything you wish with the Source data Structure, like re-order Columns/rename Headers, or add/remove columns and it will work.

But again, we still advise making a duplicate from the original Table, just to have a copy for safety.

Let me know if that helps.