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

    (@meitar)

    Yes. This is already in the plugin’s FAQ. Please read it:

    Can I remove certain columns from appearing on my webpage?

    If you’re using the “new” Google Spreadsheets, you can strip out columns by selecting only those columns you wish to retrieve by passing a Google Charts API Query Language query to the shortcode’s query attribute. For example, to retrieve and display only the first, second, and third columns in a spreadsheet, use a shortcode like this:

    [gdoc key="ABCDEFG" query="select A, B, C"]

    Alternatively, you can hide columns using CSS with code such as, .col-4 { display: none; }, for example.

    Thread Starter shpeedie

    (@shpeedie)

    Thanks, i did read that, but i want to hide rows, not columns.

    Can this same select method be used for hiding rows?

    Thanks

    Plugin Author Meitar

    (@meitar)

    Can this same select method be used for hiding rows?

    Yes, of course. Just select the rows you want and not the ones you don’t.

    select A, B, C, D where C != 'exclude these rows'

    Read the Google Query Language specification to learn more about how to select only the rows/columns/whatever you want.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘hidden rows’ is closed to new replies.