Subscribe Contribute Advertise Facebook Twitter Instagram Forums Newsletter
Posting a Long Gear List
Display Avatars Sort By:
Greg Mihalik
(greg23) - M

Locale: Colorado
Posting a Long Gear List on 09/28/2009 22:11:41 MDT Print View

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.

Roleigh Martin
(marti124) - MLife

Locale: Moderator-JohnMuirTrail Yahoo Group
Re: Posting a Long Gear List on 09/29/2009 15:14:01 MDT Print View

why not take the link to your excel file in your profile page and embed it as a link in your post?

Greg Mihalik
(greg23) - M

Locale: Colorado
Re: Re: Posting a Long Gear List on 09/29/2009 16:22:50 MDT Print View

"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.

Edited by greg23 on 09/29/2009 16:26:33 MDT.

Jeff K
(jeff.k) - F

Locale: New York
Re: Re: Re: Posting a Long Gear List on 09/29/2009 16:45:23 MDT Print View

Greg,

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.

Greg Mihalik
(greg23) - M

Locale: Colorado
Re: Posting a Long Gear List on 09/29/2009 16:48:10 MDT Print View

Try it.
You'll see why.

Roleigh Martin
(marti124) - MLife

Locale: Moderator-JohnMuirTrail Yahoo Group
Re: Posting a Long Gear List on 09/29/2009 18:14:14 MDT Print View

Greg, 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.

Greg Mihalik
(greg23) - M

Locale: Colorado
Re: Posting a Long Gear List on 09/30/2009 07:42:17 MDT Print View

It 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 - JPG

First, 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.)

GearListPageScaling3

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 -

ExportLongPDF

Which, when Inserted into a BPL post [the 'Insert Image at Cursor' button is above and right of the Comments box], looks like this -

JMTList4RoleighPDFsmallJPG

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.

Edited by greg23 on 03/21/2010 16:25:52 MDT.

Bob Bankhead
(wandering_bob) - MLife

Locale: Oregon, USA
Posting a Long Gear List on 09/30/2009 10:13:56 MDT Print View

Greg:

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.

Edited by wandering_bob on 09/30/2009 10:16:00 MDT.

Greg Mihalik
(greg23) - M

Locale: Colorado
Re: Posting a Long Gear List on 09/30/2009 10:15:57 MDT Print View

Bob -

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.

Edited by greg23 on 09/30/2009 10:37:36 MDT.

Lance Marshall
(Lancem) - F - MLife

Locale: Oregon
Posting a Long Gear List on 09/30/2009 13:09:02 MDT Print View

There is a thread from 2007 that has a few hints:
2007 Thread

Hope that helps!

Edited by Lancem on 09/30/2009 13:15:08 MDT.

Mike W
(skopeo) - F

Locale: British Columbia
Posting a Long Gear List on 10/01/2009 21:43:11 MDT Print View

I use a free tool called CutePDF Writer for PDF conversion from any program.

It installs as if it's a printer but outputs a PDF. Great tool!

Greg Mihalik
(greg23) - M

Locale: Colorado
Re: Posting a Long Gear List on 10/02/2009 08:33:40 MDT Print View

Mike,
Does it honor or ignore the page breaks that the native program creates?

Mike W
(skopeo) - F

Locale: British Columbia
Posting a Long Gear List on 10/02/2009 10:24:21 MDT Print View

Since this acts like a printer you have complete control on defining the page output size. You can pick from all of the standard page sizes or define a custom page size. For example, you can set a page size of 8.5" X 36" and you won't get a page break unless your output is more than 36 inches long.

Greg Mihalik
(greg23) - M

Locale: Colorado
Re: Posting a Long Gear List on 10/02/2009 10:35:58 MDT Print View

Thanks for the info Mike.
CutePDF sounds like a good tool.

Edit: I see that another app called 'GhostScript' must also be installed.

Edited by greg23 on 10/02/2009 10:58:59 MDT.