how to diaplay spreadsheets data

Viewing 2 replies - 1 through 2 (of 2 total)
  • thevukaslt

    (@thevukaslt)

    Hi, it works fine with Google’s given public html code.
    [gdoc key="https://docs.google.com/spreadsheets/d/1Q3Sp0aoBwFOkODihDxINv5p6_we8sS6fFG0u9I5tp14/pubhtml"]

    For limiting output use query. From FAQ documentation:

    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.

    This time it would look like this:
    [gdoc key="https://docs.google.com/spreadsheets/d/1Q3Sp0aoBwFOkODihDxINv5p6_we8sS6fFG0u9I5tp14/pubhtml" query="select C"]

    Thread Starter preetam

    (@preetam2012)

    thanks sir ??
    one more help please i wan’t to store age value(only row first cell C ) in $myage how to store please tell me

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘how to diaplay spreadsheets data’ is closed to new replies.