Stack Overflow
Stack Overflow

Questions tagged [google-docs]

Questions related to interacting with Google word processing Documents programmatically. Usage questions about the web application should be posted at Web Applications Stack Exchange.

Google Docs is a cloud-based application and service for creating and collaborating on word processing documents. The service supports an internal API for Google Apps Script as well as an External API.

Usage questions about the web application should be posted at Web Applications Stack Exchange or the Google Drive Help Center instead of here.

Note: Google has historically used the brand "Google Docs" to encompass a suite of products, but since conforming to that would introduce ambiguity here, the tag is specifically for word processing documents while refers to the suite.

3539 questions
28
votes
6 answers

Is there a good R API for accessing Google Docs?

I'm using R for data analysis, and I'm sharing some data with collaborators via Google docs. Is there a simple interface that I can use to access a R data.frame object to and from a Google Docs spreadsheet? If not, is there a similar API in other…
James Thompson
  • 46,512
  • 18
  • 65
  • 82
25
votes
7 answers

How do I prevent exposure of my password when using RGoogleDocs?

I love RGoogleDocs and use it a lot. However, I don't like entering my password all the time. Obviously I could just type the password into the R script and would never have to enter it again. But thats not viable since it means that my password…
Farrel
  • 10,244
  • 19
  • 61
  • 99
25
votes
1 answer

Wrong results in Google spreadsheets Lookup functions (vlookup, hlookup, match)

The following spreadsheet demonstrates a very odd behaviour of Google Spreadsheets Lookup functions. I've used these functions many times without any problem. Can anyone confirm it happens on their side as well? Example doc:…
zstolar
  • 461
  • 1
  • 4
  • 9
24
votes
4 answers

How are scrollbars in new Google Docs UI styled (esp. the arrow buttons)?

The new Google Docs UI features cool gray scrollbars. These appear to be regular scrollbars styled with selectors like ::-webkit-scrollbar-thumb. Which is nice and accessible. However, I can't get arrow buttons to appear (circled on the…
Anton Strogonoff
  • 32,294
  • 8
  • 53
  • 61
24
votes
1 answer

VIM with Google Docs?

I finally got around to teaching myself VIM and am really liking it. I was wondering if anyone here knew of a way to set up my Google Docs to support the VIM commands?
ShowLove
  • 899
  • 1
  • 12
  • 21
24
votes
2 answers

How do I export the revision history of a gdoc to git?

I have a spreadsheet in google docs that I'd want to integrate in a git workflow (and push to github). Are there any tools (or even libraries that are gdoc version aware) that do, or help me do, that? I have some old ruby hacks lying around based on…
ecmanaut
  • 5,030
  • 2
  • 44
  • 66
23
votes
5 answers

how to open specific page on Google's docs viewer

I'm using google's docs viewer to show a pdf document in a html page and I would like to open the document starting on page 20 instead of 1 for example. There's hardly any documentation about Google's docs viewer service. They say in its webpage…
Juan
  • 459
  • 1
  • 3
  • 8
23
votes
3 answers

Google docs - automated List of tables

Is it possible to add captions to tables in Google docs? I would like to be able to produce an automated list of tables. For example something like this : Any idea ?
giac
  • 4,261
  • 5
  • 30
  • 59
23
votes
2 answers

How to add image numbers in Google Docs

I have a document in Google Docs which has a lot of images numbered sequentially. Every time I add a new image in the middle of the document I have to renumber all the image numbers along the document along with its references. How could I renumber…
Gabriel Diego
  • 950
  • 2
  • 10
  • 22
23
votes
4 answers

Add link to open a local file in Google Docs

I have made a guide (or something like a tutorial) about my tool to share with my company. I used Google Docs to do that, and I would like to add links to open video guides. I want to know a way to add link in the document.
Hyun-geun Kim
  • 919
  • 3
  • 22
  • 37
22
votes
4 answers

Google docs viewer url parameters

Is there any sort of documentation on exactly what parameters you can put in the url of Google viewer? Originally, I thought it was just url,embedded,chrome, but I've recently come accross other funny ones like a,pagenumber, and a few others for…
P O'Conbhui
  • 1,203
  • 1
  • 9
  • 16
22
votes
5 answers

How to add a hyperlink in a Google Docs using a Google Script

I have always used the insertText() function, but now I want to write a link in my google docs. The ideal would be to be able to write in HTML, but I don't know how.. it seems that it is not possible with the insertText() function. How can I do that…
qcha
  • 523
  • 1
  • 5
  • 19
22
votes
4 answers

Convert Google Docs to Jekyll Markdown

How can I convert a Google Docs, which contains images and tables, into a Markdown file which can be published as a post using Jekyll? Is it possible to first export the Google Docs into a PDF and then convert the PDF to Markdown? What will happen…
orschiro
  • 19,847
  • 19
  • 64
  • 95
21
votes
3 answers

Axis scale in google charts (from google spreadsheets)

I've generated chart form google spreadsheets. In my report for horizontal axis I have values: 1 ,2 ,3 ,4 ,5 ,10 ,20 ,30 ,40 ,50 ,100 ,200 ,300 ,400 ,500 ,600 ,700 ,800 ,900 ,1000. Chart interprets them as a labels, not a number: So the distance…
zacheusz
  • 8,750
  • 3
  • 36
  • 60
21
votes
1 answer

Is it possible to modify the Google Docs/Sheets right-click context menu?

It's well known on how to make a custom upper menu item (https://developers.google.com/apps-script/guides/menus), but can you append a function to the context menu when right clicking a cell or item?
user3645994
  • 409
  • 6
  • 13
1 2
3
…
99 100