Topic
Posting a Long Gear List
Forum Posting
A Membership is required to post in the forums. Login or become a member to post in the member forums!
Home › Forums › General Forums › Philosophy & Technique › Posting a Long Gear List
- This topic is empty.
-
AuthorPosts
-
Sep 28, 2009 at 9:11 pm #1239721
My gear list is about 120 lines long, in Excel. How do I include it in a post? (Not my Profile)
In Excel I can Save As a pdf, and then from the pdf Export to JPG, but that results in 3 JPGs based on Excel's page breaks, which I would then have to stitch together in Illustrator, or GIMP. Tedious. Messy. Ugly. And I don't what to go the Google Apps route.
Tips or Tricks?
Thanks.
Sep 29, 2009 at 2:14 pm #1531515Roleigh MartinBPL Member@marti124
Locale: Founder & Lead Moderator, https://www.facebook.com/groups/SierraNorthPCThikerswhy not take the link to your excel file in your profile page and embed it as a link in your post?
Sep 29, 2009 at 3:22 pm #1531537"why not take the link to your excel file in your profile page and embed it as a link in your post?"
Because that ties the thread to a Gear List which will change over time – making the thread nonsensical.
Sep 29, 2009 at 3:45 pm #1531545Greg,
If there are three pages you could just export the PDFs to jpgs and then upload 3 jpg images. I don't see why you would need to splice them. But if you know about Gimp, you probably know a lot about this, so I am guessing I am missing something.
Sep 29, 2009 at 3:48 pm #1531548Try it.
You'll see why.Sep 29, 2009 at 5:14 pm #1531576Roleigh MartinBPL Member@marti124
Locale: Founder & Lead Moderator, https://www.facebook.com/groups/SierraNorthPCThikersGreg, but it would be nice if at your profile page you did upload your Gear List — I don't see it. I have a lengthy gear list at my profile page. I'd like to see yours.
Sep 30, 2009 at 6:42 am #1531705It took some rooting around, but here it is – provided your version of Excel (.xlsx) has these features.
(If your version is old (.xls) use File/Page Setup, Scale, and then create a PDF manually with Adobe Acrobat.)
Before anything else, Do a Save As to create a copy of your Excel files and work on that, to preserve the original.
There only 3 Steps, the first 2 in Excel, the 3rd in Adobe:
1)Page Layout/Scale
2)Save As – PDF
3)Export – JPGFirst, in Excel, in the Menu Bar, select Page Layout, and then Scale to Fit.
Change the Height to a number big enough to capture your spreadsheet. In my case '3 pages' does it. (CLUE: When I previewed or printed, I saw 3 pages.)
Next, do a " Save As" to an Adobe PDF, and you will get a single long page document.
Last, open the file in Acrobat, and click on EXPORT. In my case I chose to export a JPEG –
Which, when Inserted into a BPL post [the 'Insert Image at Cursor' button is above and right of the Comments box], looks like this –
Neat and Clean.
As long as you want.
And you can actually read it.The Gear List is preserved in the thread, and any future changes to your Gear List won't have an impact.
Sep 30, 2009 at 9:13 am #1531758Greg:
You must have a newer version of Excel than I do. There is no "scale to fit" function in Excel 2002, nor do I have the option of saving as a pdf.
Sep 30, 2009 at 9:15 am #1531760Bob –
darn…
sorry.The old version of Excel has the Scale function under File/Page Setup – it's in the middle of the window.
Create a PDF with the Adobe Acrobat 8.0 or so, and then export. It will suck in an .xls just fine.
Sep 30, 2009 at 12:09 pm #1531815There is a thread from 2007 that has a few hints:
2007 ThreadHope that helps!
Oct 1, 2009 at 8:43 pm #1532315…
Oct 2, 2009 at 7:33 am #1532402Mike,
Does it honor or ignore the page breaks that the native program creates?Oct 2, 2009 at 9:24 am #1532440…
Oct 2, 2009 at 9:35 am #1532446Thanks for the info Mike.
CutePDF sounds like a good tool.Edit: I see that another app called 'GhostScript' must also be installed.
-
AuthorPosts
- You must be logged in to reply to this topic.
Forum Posting
A Membership is required to post in the forums. Login or become a member to post in the member forums!
Our Community Posts are Moderated
Backpacking Light community posts are moderated and here to foster helpful and positive discussions about lightweight backpacking. Please be mindful of our values and boundaries and review our Community Guidelines prior to posting.
Get the Newsletter
Gear Research & Discovery Tools
- Browse our curated Gear Shop
- See the latest Gear Deals and Sales
- Our Recommendations
- Search for Gear on Sale with the Gear Finder
- Used Gear Swap
- Member Gear Reviews and BPL Gear Review Articles
- Browse by Gear Type or Brand.