Weedwhacker's blog: Using the ATP/NGA website

Posted on May 12, 2016 4:18 PM

PRINTING OUT MY PLANT LIST (including making labels):

From Rick Corey:
I usually "select" the table with my mouse, then copy it to an MS Word document.

Usually it would paste itself as a "table". I haven't tried recently on a Plant List, but it worked with most (all?) of the seed swap artifacts.

Then I could easily delete the parts I did NOT want, and print the rest. I work with MS Word tables a lot, to print double-sided labels. They have a nice laser printer at work, that will print double-sided, with registration/alignment of front and back usually better than 1 mm.

>> What I would really like is to print just the 'Plant' column so that I can import it into my label file to print new labels.

In your case, after copy-pasting into the editor of your choice, you could probably select just the "name" column, copy just that column, and paste just that column.

--------------------
From RickM:
Per @ZuZu , I set the page size to 200 (only have 105 items in my list)
Per @Horntoad, clicked on the 'Print this page' to get a less-cluttered version.

I selected and copied the resulting page and pulled it into Word and deleted the Status, Notes and Events columns
Sort the table on the remaining 'Plant' column
Convert the table to text

What you have left is your plant list, including the hyperlinks into the plant database. I got rid of those by copying the list into a plain text editor and then back into Word. The list remains, but without the links.

Since my labels will hold 3 lines of text at 9pt, I
converted the line breaks to page breaks
converted the left paren to a line break
converted the right paren to nothing

I'm left with a file that contains all of my plants formatted so each will print on a separate label.

Thumb of 2016-05-12/Weedwhacker/08eb5e

_____________________________

Post a new thread about this blog entry:

Drag and drop a photo here to upload, or click below:

- 😀

smily acorn grouphug glare tongue_smilie blushing drool angry rolleyes hurray tiphat bigear thinking hogrin biggrin greengrin nodding blinking confused crying grumbling sad doh hearts rofl thumbsdown thumbsup cross_finger whistling lol angel shrug iagree thankyou welcome sigh

« View Weedwhacker's blog

Member Login:

( No account? Join now! )

Today's site banner is by Newyorkrita and is called "Rose Francois Rabelais"

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.