1

Google spreadsheets contain FontStyle information, such as bold, red, etc. I want to read the FontStyle from the spreadsheet.

Is GAS the only way to read FontStyle info from a google spreadsheet? Are there any other options?

I am using appengine and Gdata/Spreadsheet API with OAuth. This is reading Cell Data from the google spreadsheet.

Gdata & Google Spreadsheets API 3.0: I have searched Gdata & Google Spreadsheets API, as far as I can tell, these only read cell data. There is a GData feature request to read FontStyle info here :

Avoid Google Apps Script: I want to avoid using google apps script. I know GAS can read FontStyle info. But GAS is complex/scary for a non programmer to setup and so I want to avoid GAS.

eddyparkinson
  • 3,680
  • 4
  • 26
  • 52

1 Answers1

2

I think the easiest way to work around this would be to use the Google Drive API instead and download the spreadsheet in HTML format. Then you can parse the HTML to determine the cell fonts and colors.

Jay Lee
  • 13,415
  • 3
  • 28
  • 59
  • Had not thought of doing a download. I will look into it. This says download as HTML is possible http://stackoverflow.com/questions/13082918/download-a-google-docs-spreadsheet-as-html. Will check if it exports style info. – eddyparkinson Jan 14 '13 at 03:24
  • Google example of how to download a file from google drive: https://developers.google.com/drive/v2/reference/files/get – eddyparkinson Jan 15 '13 at 04:22