Sending data from Construct 2/3 to Google Spreadsheet

You're viewing a single comment in a conversation. View all the comments
  • 5 Comments

  • Order by
  • Thank you ! I have to admit I'm not familiar at all with this syntax and have a little trouble to understand what to do.

    Actually, my app already has an array to csv export system (this one actually howtoconstructdemos.com/export-array-data-to-csv-excel-file-format-c3p/) so maybe this string named 's' can be sent to spreadsheet.

    Two questions :

    - Does the spread sheet adapts itself to the number of lines my array has or do I have to specify it somewhere ? (my array grows and grows through time)

    - Do we have to give a name to every spreadsheet column or is it possible to refer to them in the script with their rank (starting from 0) like we do in arrays in C3 ? My array has 100 columns .

    • Is your array 1D or 2D? The example I posted above should parse 1D array and put all values in a new row on the spreadsheet, each value in its own column. Say, if you are sending this string: "apple,banana,plum,100,200"

      Then "apple" will be in column A and "200" in column E.

      • My array is 2D. Thank you, I get it from your exemple.

        How do I tell when values are to be stored in line 2, 3, etc ?

        I read on your wonderful website that you offered free casual help (that's what you are doing now and I'm very grateful) but that you can also solve a problem for a fee. I don't have much for this project but can offer some money. The project here is to help my father track is health condition (he has Parkinson).