Display merged cells from Google Sheets

  • Resolved penhtech

    (@penhtech)


    4 years, 3 months ago

    The Google sheets I need to display feature several rows with merged cells–essentially subheadings that span the full width of the table. On any given table there might be one, two, three or more, at irregular intervals. To some extent I guess this is a case of essentially trying to put several small spreadsheets on one, and it may just be that the plugin and possibly DataTables itself just can’t handle that, but I am really hoping there is a solution other than just breaking them all down into smaller tables. If it helps any, all merged rows except the first one are preceded by a blank row of empty cells. While the tables are not large–rarely more than 30 rows and 5 or 6 columns, there are a lot of them. In fact, I don’t actually need or want any of the DataTables functionality. I just need to display tables that are laid out the same as the Google Sheet. Is this possible?

    • This topic was modified 4 years, 3 months ago by penhtech.
    • This topic was modified 4 years, 3 months ago by penhtech. Reason: Add additional info
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Meitar

    (@meitar)

    4 years, 3 months ago

    https://wordpress.org/support/topic/plugin-inline-google-spreadsheet-viewer-merged-cells/

    Thread Starter penhtech

    (@penhtech)

    4 years, 3 months ago

    I am absolutely not imagining things. I searched for the words “merged” and “merged cells” before posting and got no hits at all. I tried it multiple times because I could not believe I was not finding ANYTHING. Now, of course, I get many results.

    Anyway, thanks. I had already come to the same conclusion myself after looking through your (very nicely written and commented) code and seeing that you used the CSV export. I’ll look into the API to see if I can’t just create a simple plugin to display our tables, as we don’t need any of the DataTables library features.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Display merged cells from Google Sheets’ is closed to new replies.