CSV file same functionality as Spreadsheet file?

  • Resolved mateox

    (@mateox)


    7 years ago

    Hey there again!

    Just a short question: Does the plugin provide the same functionality for CSV files and Google Spreadsheet files?

    F.e. would a shortcode like this work ?[gdoc key="xxx.csv" http_opts='{}' ordering="false" datatables_dom="t" class="no-responsive" datatables_scroll_x=”true” style="position: relative; overflow: auto; width: 100%;" use_cache="no" query="select B, C, D, E, F where A=111 LIMIT 10"]

    I trief it and it doesn’t seam wo work. Is this a matter of my personal code or the plugins functionality?

    Best regards and thanks for your help! Really appreciate your work.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter mateox

    (@mateox)

    *tried and *to work

    Plugin Author Meitar

    (@meitar)

    Many features are applied to both CSV and Google Spreadsheets but the query language is an example of a part that is different. For a CSV, use your column headings in the select statement, not the column letter as it is displayed in Google Sheets (because a CSV does not have a “Column A,” it has whatever-you-named-the-first-column).

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘CSV file same functionality as Spreadsheet file?’ is closed to new replies.