| How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | Jasonhemu | 3/31/11 9:21 AM | Hi there, I want to create an app which will automatically generate QR Code based on the data in Google Spreadsheet with Google Chart API. Now I am able to generate the Google Chart API URL in a cell, but it will not display the picture, unless I pa |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | Henrique Abreu | 3/31/11 10:38 AM | Well, use the sheet.insertImage method with the url you generated to show the image directly in the spreadsheet, e.g. SpreadsheetApp.getActiveSheet().insertImage(qrCodeUrl, 2, 2 ); Note: the same url that works on browsers address bar may not with t |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | Jasonhemu | 4/1/11 1:45 PM | Hi Henrique, Thanks for you help! I did not realize there is an "insertImage" method. How silly am I :-) |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | DavidLangan | 6/29/11 11:21 PM | Hi there, I am trying to do this EXACT same thing... and a little confused. I've created a script with the following: function createQR(text) {var r = SpreadsheetApp.getActiveRange().getRow();var c = SpreadsheetApp.getActiveRange().getColumn();var |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | Henrique Abreu | 6/30/11 3:59 AM | Are you trying to use this as a custom function? You're not going to be able to do this, custom functions can not modify the spreadsheet, only read and return values. You may want to use your custom function just to return the url and then pass it to |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | DavidLangan | 6/30/11 9:46 AM | I've tried using the built in insert image function however it returns an error saying no image was found at the url. Here's an example of my syntax using the built in function and a url from the Google Chart API: =image("http://chart.apis.google.c |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | DavidLangan | 6/30/11 10:02 AM | Just found this forum post that's a little old... and I think it describes the problem I'm running into: https://www.google.com/support/forum/p/Google+Docs/thread?tid=768b94a7642a4a25&hl=en So I guess the problem is in fact inserting an image with no |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | Henrique Abreu | 6/30/11 10:11 AM | Indeed, it seems that the image function does not work with Google Charts API. You should complain about this in the Google Docs forum, since it has nothing to do with Apps Script. In the end, it seems that you'll not be able to write a custom funct |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | Jasonhemu | 6/30/11 11:39 AM | Hi there, I don't think the image function have any problem in Google Apps Script, because it still functions very well in my spreadsheet. Since the Google Chart API requires encoded URL, it could be the reason for David's problem. So just use "enco |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | Henrique Abreu | 6/30/11 11:51 AM | I think you missed the point a little here Jasonhemu.. He wanted to build a custom function to insert the image and a custom function cannot call insertImage because of its limitations. There's nothing wrong with the encoding of: "http://chart.apis.g |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | paulwoll | 7/11/11 12:32 PM | I also am frustrated with the IMAGE formula in regards to http://chart.apis.google.com/chart?chs=150x150&cht=qr&chl=hello%20world I have my spreadsheet setup with some sparklines but the urls only work if I paste them in the browser and the images |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | SBYRD | 4/11/12 9:43 AM | I am using: =IMAGE("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=Hello%20world") to view the QR Code in a Google Doc and that is working fine. I want to replace the 'Hello World' data with data in a cell (or range of cells) on the Googl |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | Henrique Abreu | 4/11/12 1:22 PM | This has nothing to do with Apps Script. You should try the Google Spreadsheet forum. Anyway, just concatenate it: =IMAGE("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="&A2) |
| Re: How to display a QR Code (generated by Google Chart API) in Google Spreadsheet | SBYRD | 4/11/12 2:28 PM | Yes I figured it out - thank you for the reply. |