Rails 5: Google Sheets API strange behavior2019 Community Moderator ElectionA concise explanation of nil v. empty v. blank in Ruby on RailsUnderstanding the Rails Authenticity TokenHow can I rename a database column in a Ruby on Rails migration?How do I get the current absolute URL in Ruby on Rails?How to handle structured queries for retrieving rows with Google Sheets API v4Using CURL to edit entries on google sheets documentsSetting date format in Google Sheets using API and PythonFilter Google Sheets based on the value in a columnPosting To Google Sheets Api v4 - AndroidGetting 403 from Google Sheets API using apikey
Is there any relevance to Thor getting his hair cut other than comedic value?
Where is the line between being obedient and getting bullied by a boss
Make me a metasequence
Accessing something inside the object when you don't know the key
What is knowledge and vision?
Sometimes a banana is just a banana
I can't die. Who am I?
Real life puzzle: Unknown alphabet or shorthand
How do ISS astronauts "get their stripes"?
A "strange" unit radio astronomy
Can we carry rice to Japan?
Did Amazon pay $0 in taxes last year?
Where was Karl Mordo in Infinity War?
How to deny access to SQL Server to certain login over SSMS, but allow over .Net SqlClient Data Provider
Infrastructure damage from sudden thickening of water
What do the pedals on grand pianos do?
Is divide-by-zero a security vulnerability?
Reason why dimensional travelling would be restricted
Is there a ternary operator in math
Wrap all numerics in JSON with quotes
Understanding Kramnik's play in game 1 of Candidates 2018
Second-rate spelling
Is the set of paths between any two points moving only in units on the plane countable or uncountable?
What are these green text/line displays shown during the livestream of Crew Dragon's approach to dock with the ISS?
Rails 5: Google Sheets API strange behavior
2019 Community Moderator ElectionA concise explanation of nil v. empty v. blank in Ruby on RailsUnderstanding the Rails Authenticity TokenHow can I rename a database column in a Ruby on Rails migration?How do I get the current absolute URL in Ruby on Rails?How to handle structured queries for retrieving rows with Google Sheets API v4Using CURL to edit entries on google sheets documentsSetting date format in Google Sheets using API and PythonFilter Google Sheets based on the value in a columnPosting To Google Sheets Api v4 - AndroidGetting 403 from Google Sheets API using apikey
I added the Google Sheets API to my application.
I'm having some trouble to render the response in my view.
For example the default majorDimension is ROWS. When I use this I get the following output in my view.
Instead this should display ROW A2:G2, but this only display COLUMN A2
This is my Controller:
def sheets
client = Signet::OAuth2::Client.new(client_options)
client.update!(session[:authorization])
service = Google::Apis::SheetsV4::SheetsService.new
service.authorization = client
spreadsheet_id = ''
range = 'Tabellenblatt1!A2:G'
@response = service.get_spreadsheet_values(spreadsheet_id, range,
major_dimension: 'ROWS'
)
end
Now when I change to major_dimension: 'COLUMNS' then ROW A2:G2 is displayed.
This is my view:
<% @response.values.each do |row| %>
<%= row[0] %>
<% end %>
I also would like to add some styling in my view, but this seems impossible, since the response returns only one big chunck which is <%= row[0] %>
ruby-on-rails google-sheets-api google-api-ruby-client
asked 14 mins ago
klasarnklasarn
648
add a comment |
I added the Google Sheets API to my application.
I'm having some trouble to render the response in my view.
For example the default majorDimension is ROWS. When I use this I get the following output in my view.
Instead this should display ROW A2:G2, but this only display COLUMN A2
This is my Controller:
def sheets
client = Signet::OAuth2::Client.new(client_options)
client.update!(session[:authorization])
service = Google::Apis::SheetsV4::SheetsService.new
service.authorization = client
spreadsheet_id = ''
range = 'Tabellenblatt1!A2:G'
@response = service.get_spreadsheet_values(spreadsheet_id, range,
major_dimension: 'ROWS'
)
end
Now when I change to major_dimension: 'COLUMNS' then ROW A2:G2 is displayed.
This is my view:
<% @response.values.each do |row| %>
<%= row[0] %>
<% end %>
I also would like to add some styling in my view, but this seems impossible, since the response returns only one big chunck which is <%= row[0] %>
ruby-on-rails google-sheets-api google-api-ruby-client
asked 14 mins ago
klasarnklasarn
648
add a comment |
I added the Google Sheets API to my application.
I'm having some trouble to render the response in my view.
For example the default majorDimension is ROWS. When I use this I get the following output in my view.
Instead this should display ROW A2:G2, but this only display COLUMN A2
This is my Controller:
def sheets
client = Signet::OAuth2::Client.new(client_options)
client.update!(session[:authorization])
service = Google::Apis::SheetsV4::SheetsService.new
service.authorization = client
spreadsheet_id = ''
range = 'Tabellenblatt1!A2:G'
@response = service.get_spreadsheet_values(spreadsheet_id, range,
major_dimension: 'ROWS'
)
end
Now when I change to major_dimension: 'COLUMNS' then ROW A2:G2 is displayed.
This is my view:
<% @response.values.each do |row| %>
<%= row[0] %>
<% end %>
I also would like to add some styling in my view, but this seems impossible, since the response returns only one big chunck which is <%= row[0] %>
ruby-on-rails google-sheets-api google-api-ruby-client
asked 14 mins ago
klasarnklasarn
648
I added the Google Sheets API to my application.
I'm having some trouble to render the response in my view.
For example the default majorDimension is ROWS. When I use this I get the following output in my view.
Instead this should display ROW A2:G2, but this only display COLUMN A2
This is my Controller:
def sheets
client = Signet::OAuth2::Client.new(client_options)
client.update!(session[:authorization])
service = Google::Apis::SheetsV4::SheetsService.new
service.authorization = client
spreadsheet_id = ''
range = 'Tabellenblatt1!A2:G'
@response = service.get_spreadsheet_values(spreadsheet_id, range,
major_dimension: 'ROWS'
)
end
Now when I change to major_dimension: 'COLUMNS' then ROW A2:G2 is displayed.
This is my view:
<% @response.values.each do |row| %>
<%= row[0] %>
<% end %>
I also would like to add some styling in my view, but this seems impossible, since the response returns only one big chunck which is <%= row[0] %>
ruby-on-rails google-sheets-api google-api-ruby-client
ruby-on-rails google-sheets-api google-api-ruby-client
asked 14 mins ago
klasarnklasarn
648
asked 14 mins ago
klasarnklasarn
648
asked 14 mins ago
klasarnklasarn
648
asked 14 mins ago
klasarnklasarn
648
asked 14 mins ago
klasarnklasarn
648
648
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55001992%2frails-5-google-sheets-api-strange-behavior%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55001992%2frails-5-google-sheets-api-strange-behavior%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
