Hello fangquans.

Thank You for Your purchase.

If I understood You correctly, You have a <a href=...> </a> in one of the cells in Google Spreadsheet and You're trying to create a table using that Spreadsheet.

If that is true, All You need to do is modify a cell inside Google Spreadsheet and add the content (<a href=...> </a>) and it should pull the data. I tried it myself and it works. If, however, it won't work like that, You can create a copy of the first sheet in the same document using =IMPORTRANGE and that disregards all formatting and styling for the first sheet and pulls the actual data from the second one. You can read more about that here.

Please let me know if this was what You were looking for.

Best regards.

Hello again fangquans.

Unfortunately, adding new columns to Google Sheets after You already created a table in wpDataTables will not work. There are some issues with the data being pulled from Google Spreadsheets, and it simply breaks the table, or like in Your case it doesn't display the new columns.

It is rather easy to work around this, though.

All You need to do is to create a new sheet in the same document and paste the new URL to the existing wpDataTable. Let me show You an example.

This is the original data from Google sheets, and as You can see I added two new columns.

These two columns will not be shown in wpDataTables, or the table would break all in all.

If You were to add a new sheet (in the bottom left of the page) and insert:

=IMPORTRANGE ("URL_OF_THE_FIRST_SHEET", "Data!A1:F25")

Then copy the URL for this second sheet and paste it in the wpDataTables table as a Input file path or URL it will show all the columns without any issues.

It has been brought to my attention a while ago, that You can add new columns, and that wpDataTables would accept them, if You were to simply paste the same URL again and hit Apply. I can't say for sure that this works, but You're welcome to try, and let us know what solution works for You.

Best regards.