How To Post an Excel Table - Honda Pilot

kemosabe · 03-09-2003, 06:56 PM

Background: this is in response to a user who wanted to post their Pilot gas mileage data that they had in a Microsoft Excel spreadsheet into this forum.....

Bring up your spreadsheet in MS Excel. In my case here, I am using Tom Clancy books as my example...

kemosabe · 03-09-2003, 06:57 PM

Save your spreadsheet as a web page by choosing the File --> Save As... menu option.

I'm calling mine (duh!) clancy.htm

kemosabe · 03-09-2003, 06:59 PM

Use Wordpad or Notepad to bring up your newly created web page file (in my example, clancy.htm) and search for the line that says "border=0" and change it to read "border=1". Save the change!!

kemosabe · 03-09-2003, 07:01 PM

Highlight everything starting from the HTML tag that starts with "<"table x:str border=1 until...

kemosabe · 03-09-2003, 07:04 PM

...the last html table tag near the bottom of the document. Then click on the "Copy" button (or choose the Edit --> Copy menu item).

kemosabe · 03-09-2003, 07:06 PM

Paste your selected text into your post. Using the keyboard combo of Ctrl-V will work nicely...

kemosabe · 03-09-2003, 07:07 PM

And when all is said and done, you should have somewhat of a table... (don't know why there is so much space before the table shows up!!!

)

1984	The Hunt for Red October
1986	Red Storm Rising
1987	Patriot Games
1988	The Cardinal of the Kremlin
1989	Clear and Present Danger
1991	The Sum of All Fears
1993	Without Remorse
1994	Debt of Honor
1996	Executive Orders
1998	Rainbow Six
2000	The Bear and the Dragon
2002	Red Rabbit

kemosabe · 03-09-2003, 07:08 PM

Also, be sure that HTML code is turned ON for the thread you're posting to!!!!!

florida_guy · 03-09-2003, 07:20 PM

Oh mighty graphics master

What do you use to capture your screen shots?

kemosabe · 03-09-2003, 07:32 PM

Quote:

Originally posted by florida_guy
Oh mighty graphics master

What do you use to capture your screen shots?

I take my Nikon 35mm camera and aim it at my 19" computer monitor. When I have used up all 36 shots on the roll, I take the film to Wal-Mart and in 3 days, I go pick it up. I then scan the 4"x6" pictures in.....

Just kidding... I used a package called Paint Shop Pro to do the screen captures... it works pretty well.

havasu · 03-09-2003, 10:22 PM

Quote:

Originally posted by kemosabe
And when all is said and done, you should have somewhat of a table... (don't know why there is so much space before the table shows up!!! )

All the space is because a break (new line) is inserted for each new line in the post.
To fix this, you can edit your html (before posting is easier) to remove the newlines.
I have to do this in the VIN table thread or there would be over 300 blank lines!! Thanks to admin for pointing this out to me.

kemosabe · 03-09-2003, 11:10 PM

Well, I'll be... thanks, havasu!!! Who would've thunk it was the newlines, huh???

Thanks!!!

1984	The Hunt for Red October
1986	Red Storm Rising
1987	Patriot Games
1988	The Cardinal of the Kremlin
1989	Clear and Present Danger
1991	The Sum of All Fears
1993	Without Remorse
1994	Debt of Honor
1996	Executive Orders
1998	Rainbow Six
2000	The Bear and the Dragon
2002	Red Rabbit

florida_guy · 03-09-2003, 11:43 PM

Quote:

Originally posted by kemosabe

I take my Nikon 35mm camera and aim it at my 19" computer monitor. When I have used up all 36 shots on the roll, I take the film to Wal-Mart and in 3 days, I go pick it up. I then scan the 4"x6" pictures in.....

Just kidding... I used a package called Paint Shop Pro to do the screen captures... it works pretty well.

You had me going until you talked about the "roll" of film.

I used to use the shareware version of PaintShop. Still installed on here somewhere. Didn't know it could do that. Thanks for the info.

kemosabe · 03-09-2003, 11:51 PM

If you're using the shareware version of PSP (ver. 4.12), then go to the Capture menu to setup and start your screen captures...

florida_guy · 03-10-2003, 12:11 AM

Quote:

Originally posted by kemosabe
If you're using the shareware version of PSP (ver. 4.12), then go to the Capture menu to setup and start your screen captures...

Just did a search. I have 4.14 zipped up but not installed. Thanks for the info.

03-09-2003, 07:20 PM	#9 (permalink)
florida_guy Super Senior Member Join Date: Feb 2003 Location: Tampa Bay Area Florida Posts: 2,479 Feedback Score: 0 reviews	Screen Capture Oh mighty graphics master What do you use to capture your screen shots? __________________ Note: If you want to be sure I see a post either quote a message from me or put - florida_guy - somewhere in the body of the post so it shows up when I search. I am trying to stay active without spending too much time here. '03 Pilot EX Sandstone Metallic Options: Cargo Cover OEM Hitch StreetPilot 2610 Sportsworks Transport Bike Carrier

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Remove Advertisements Sponsored Links
Piloteers.org Advertisement