Can you embed a file in a google spreadsheet cell?
Here's what I tried so far:
1. I uploaded the pdf to google.
2. I got the link of the pdf and pasted it in the cell
The problem with this is that when I click on the cell, it just has the text, and doesn't transport you directly to the file.
Thanks!
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$2 Answers
1) Go to http://createpdf.neevia.com/ Select jpeg output format. For resolution, set 100 (this may have to be adjusted; Google only allows pixels of up to x1250, some trial and error may be required).
2) Upload your pdf in the box labled 2.
3) Leave the delivery method to its default "wait for conversion in browser."
4) Click on the file name to open a new window and get the link
5) Click in a cell and select insert image and paste your web link
I don't know exactly what you're trying to do, but this will get the pdf document embedded in the Google Spreadsheet.
I fooled with many other things, and this was the only thing I could get to work. There may be other ways, mind you.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$1. Open Google Docs http://docs.google.com/
2. Select "Upload" (next to the file menu, upper left)
3. Select files to upload
4. Uncheck the convert checkbox and click "Start Upload" and wait for the progress meter to complete
5. Click the newly hyperlinked filename, and click share -> get link to share
6. Check "Allow anyone with url to view" and click save and close
Type this into a cell:
=HYPERLINK( "http://locationofyourfile.com/yourfile.pdf" ; "Title of your PDF File" )
Working example:
=HYPERLINK( "https://docs.google.com/leaf?id=0BygaPM8JvuQ7M2M4YzlmZTAtNjM0YS00ODVlLTljNmItOGJmZDBkYzMzMmI0&hl=en"; "Test File")
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$