search Google sheets?

[raynamharris]

As far as I can tell, the search function is not searching Google Sheets. I'm not sure if this is known or not. The search engine says that it's indexing them, but it never returns a sheet that I know contains the keyword.

[charlesreid1]

Correct, that's because Google Drive files are put into two buckets:

• Documents (.docx files) where content is indexed
• Everything else (including spreadsheets) where only the filename is indexed

Because spreadsheets are structured, there's definitely the possibility to extract text from spreadsheets, I just didn't want to delve too deep into the second bullet point above in the interest of getting a prototype working.

[raynamharris]

Ah okay. Maybe I'm the only one, but I see "document" and think any of file in Google drive... kinda like how you can ask someone "Do you want a coke" and they can say, "Yes, I'll have a Dr.Pepper/Pepsi/CocaCola/Sprite" because coke and document are blanket terms.

[ctb]

I wonder if running 'strings' on the document would be sufficient? :P)

[charlesreid1]

xlrd library would provide a (possible?) way to extract text from spreadsheet files. would probably want to do additional processing, since this would all be word soup and has high potential to become an irrelevant result in lots of searches.

pptx library provides ability to navigate powerpoint files, extract text: https://stackoverflow.com/a/39430554 (same with post-processing, see above)

[charlesreid1]

for PDFs: I remember using PDFMiner to extract text from a PDF file a while back. Can't remember where that script went but probably in copper repo somewhere.