|
Chris,
RE: >>How did you convert the spreadsheet to a usable format for display on the web page?
Hey there. It's not easy. From the spreadsheet app (google or excel) I used primopdf to print the sheet as a pdf file. If you have acrobat you can use that too. Basically you are printing to a pdf file instead of paper, which is the same as creating an image or picture of the sheet.
Once you have a pdf or image of the spreadsheet you can open it in an image editing program like photoshop and save it as a GIF file (gif is same as jpeg, but creates a smaller file size when the image is not photographic in nature).
Next, when you have a web type image you can just create a new post on BPL and upload the image using their tool or host it elsewhere and link to it (better option because you can keep the image size larger, BPL will shrink your image if it is too big, dimensions wise, not megabytes wise.
Notes:
-- Set primopdf to use the "Print" settings rather than "Screen".
-- Open in Photoshop and choose 96 dpi import resolution if you used small text in your spreadsheet and don't use anti-aliasing if that is an option, it will blur your text.
-- Save for web as "GIF", should be about 45k max file size for large spreadsheet.
A quick and dirty option is to use the key on your keyboard labelled "Print Screen" if you have a PC. This takes a picture of whatever is on the screen at that time and saves it to the clipboard. I an image editing program you can create an new file and paste the sheet in. If the sheet is longer than the screen you can do two or three "Print Screens" to capture it all.
|