Hatrack River Forum: Website help (does anyone know how to make an Excel table into a .jpg or .gif image?)

This is topic Website help (does anyone know how to make an Excel table into a .jpg or .gif image?) in forum Books, Films, Food and Culture at Hatrack River Forum.

To visit this topic, use this URL:
http://www.hatrack.com/ubb/main/ultimatebb.php?ubb=get_topic;f=2;t=048158

Posted by KetchupPrinceConsort (Member # 8047) on :

Does anyone know how to convert an excel table to .jpg?

I am trying to load an excel table onto a website, but it only accepts .jpg or .gif images. I tried saving it as .jpg and then uploading it, but that didn't work. I also was going to try to print to file, but my only option was to print to Microsoft Office Document Image Writer. In that format I cannot use any other program to edit it.

I even tried printing and then scanning, but our printer is not working right (image comes out blurry). I don't know enough HTML code to create one with the colors and data I want in it.

Any ideas?

[ April 03, 2007, 01:28 AM: Message edited by: KetchupPrinceConsort ]

Posted by Strider (Member # 1807) on :

if the whole table can fit on your screen you can do a screen capture and save that as a .jpg.

Posted by ketchupqueen (Member # 6877) on :

I'm not sure we have any apps that can do a screen capture. But I've never tried. Is there any freeware or common apps we might have that can do that?

Posted by Icarus (Member # 3162) on :

You can do a screen capture by pressing ALT and PRTSC at the same time, or by pressing CTRL and PRTSC at the same time. One captures just the window, and one captures your whole desktop; I always forget which is which. PRTSC is usually to the right of F12, or elsewhere along the top right side of your keyboard.

Posted by Strider (Member # 1807) on :

you should have a "print screen" button on your keyboard.

hit that, then open up whatever photo editing program you have. if you use photoshop, start a new image, then just paste the screen capture into it. Or at the very least(assuming you're using a PC), open up the microsoft "paint" program and paste the screen capture in there. then save it as .jpg.

obviously crop out the area you don't need.

Posted by Icarus (Member # 3162) on :

After you do the screen capture, assuming you don't have any nice software like Photoshop, go to Start -> All Programs -> Accessories -> Paint. There isn't a good crop tool, but you can roughly crop the image by either selecting the part you want and opening a new image, or by selecting the parts you don't want and deleting them. You can then save in whatever graphics format you want.

Posted by Icarus (Member # 3162) on :

Heh . . . cross posting.

Posted by Strider (Member # 1807) on :

ALT captures just the window. CTRL captures everything, though is unnecessary as just hitting the prtsc button will do the same job.

I didn't know about the ALT trick though...pretty cool.

Posted by Strider (Member # 1807) on :

I was in an Icarus sandwich.

Posted by Jutsa Notha Name (Member # 4485) on :

quote:
Originally posted by KetchupPrinceConsort:
Does anyone know how to convert an excel table to .jpg?

I am trying to load an excel table onto a website, but it only accepts .jpg or .gif images. I tried saving it as .jpg and then uploading it, but that didn't work. I also was going to try to print to file, but my only option was to print to Microsoft Office Document Image Writer. In that format I cannot use any other program to edit it.

I even tried printing and then scanning, but our printer is not working right (image comes out blurry). I don't know enough HTML code to create one with the colors and data I want in it.

Any ideas?

Honorable PrinceConsort of things that are Ketchup, I do believe that you may find this program helpful for creating a document in a format more easily transported to most other machines. While this handy software has only very limited 'editing' (more like mark-up) capabilities, which may or may not serve the needs that your highness may have, that product does have a commercial version that has a significantly lower price point than its more common competitor WhoShallRemainNameless.

I do hope that I have been able to offer to you, sir, the slightest bit of help for you within your tomato-pasty kingdom.

Posted by Jutsa Notha Name (Member # 4485) on :

quote:
Originally posted by ketchupqueen:
I'm not sure we have any apps that can do a screen capture. But I've never tried. Is there any freeware or common apps we might have that can do that?

*presents humbly to the queen of ketchup*

Posted by ketchupqueen (Member # 6877) on :

Wow! Do you know I've been using a computer since I was 4 and I have honestly rarely noticed the "PrtScr" button, and when I have noticed it I have never wondered what it does?

Hatrack is teh awesome, and I apologize for my computerly ineptitude. In my defense, I am an awesome cook. And I have it on good authority that I make beautiful babies. And I'm an okay singer. And at least I know how to send pictures to my family. [Wink]

JNN, the links are also cool.

KPC will be thrilled to have all this information when he and the Princess come back from vaccuming the car.

(((hugs Hatrack)))

You all have been more help than you know. This information is for KPC's new business. He's unemployed again and this time he decided that he's just going to take odd jobs here and there as he can and start a small business to get us over the hump, since he is so close to graduation. We will let you all see the finished product. [Smile]

Posted by Strider (Member # 1807) on :

quote:
In my defense, I am an awesome cook

prove it.*

*proof can be delivered by mail or in person(preferably the latter for the sake of freshness), otherwise your defense is inadmissable.

Posted by ketchupqueen (Member # 6877) on :

[ROFL]

You could make one of my recipes yourself (posted on the Jatraquero recipe site.) Then imagine it three times better (because there's always that certain something that turns out different when it is your own recipe.) [Razz]

If not, I'll take you up on that challenge any time you come out here. I love to cook for Hatrack. [Big Grin]

Posted by Nato (Member # 1448) on :

quote:
Originally posted by Icarus:
After you do the screen capture, assuming you don't have any nice software like Photoshop, go to Start -> All Programs -> Accessories -> Paint. There isn't a good crop tool, but you can roughly crop the image by either selecting the part you want and opening a new image, or by selecting the parts you don't want and deleting them. You can then save in whatever graphics format you want.

A note for anybody who doesn't have an image editor they're happy with (for windows): Use Paint.NET --It's excellent, and free!

Posted by ketchupqueen (Member # 6877) on :

We actually have a photo editor that came with our camera. It's not the best, but it's decent, and I know how to do things with it. [Smile]

Posted by ketchupqueen (Member # 6877) on :

Um.

So I'm trying to do a screen capture and I'm following your directions and it doesn't work. Is there a setting I should check or anything?

Posted by ketchupqueen (Member # 6877) on :

(To clarify, I hit the buttons as directed and absolutely nothing happens.)

Posted by Strider (Member # 1807) on :

it "looks" like nothing happened, but that screen capture is actually saved. after doing it did you open up the photo editing program and try to paste the picture in there?

but yeah, to clarify, hitting the screen capture button won't make any noise or any special screen pop up or anything like that. it won't signify in any way to you that it actually did what you wanted it to do! it's just saved...in the ether...waiting to be pasted into an unsuspecting photo program.

Posted by ketchupqueen (Member # 6877) on :

I looked everywhere, including my clipboard. (I can't paste into my editing program, only import.)

But I will try it one more time. I restarted the computer and it's running faster now.

Posted by ketchupqueen (Member # 6877) on :

Okay. This time it saved. Now I just have to find out how to make it go where I want it.

I think I will paste it into paint and then import the Paint file to my photo editing program.

Posted by ketchupqueen (Member # 6877) on :

Haha! Got it! Thanks, all!

I guess the re-start did it.

Posted by ketchupqueen (Member # 6877) on :

Thank you much, Hatrack!

KPC is asleep already or I'm sure he would thank you, too. [Smile]

Posted by TomDavidson (Member # 124) on :

Why is this a .jpg? This data is much happier as a table in HTML, believe me.

Posted by Bokonon (Member # 480) on :

What Tom said. This is one of the times when using a table in HTML makes sense [Smile]

-Bok

Posted by Jon Boy (Member # 4284) on :

If you're going to do it as an image, I'd go with a .gif—it'll look sharper.

Posted by vonk (Member # 9027) on :

Hey, I didn't know about ALT-PrintScrn either! Thanks guys and KPC for starting this shabang!

Posted by Lyrhawn (Member # 7039) on :

I also didn't know about ATL-PrntScrn. Useful information.

The last person I showed the PrntScrn button to spent three days making LJ icons. It can be quite useful.

Posted by ketchupqueen (Member # 6877) on :

KPC says he doesn't know enough HTML to do the table the way he wants it himself, and the table setup they have on the website builder he is using has a table thing but it is not working well. I will try saving it as a .gif instead, thanks!

Posted by brojack17 (Member # 9189) on :

There is also a free application named PrintKey 2000. http://www.webtree.ca/newlife/printkey_info.htm
It is pretty handy.

Posted by James Tiberius Kirk (Member # 2832) on :

Glad to see everyone's learned something. PrtSc is infinitely useful.

This is somewhat late, but the other method is to select the chart, and then hold down SHIFT while you click the Edit menu at the top of the window. There should be an option to "Copy Picture" (or Copy Image, or something like that). Click on it, click OK in the dialog that comes up, and paste the result into your favorite image editor.

--j_k

Posted by TomDavidson (Member # 124) on :

Here's the code for a table similar to your .jpg, modified slightly to be of more use for learning basic HTML methods:

code:

<TABLE cellpadding=4 cellspacing=0 border=1>
<TR><TD colspan=5 align=center>MONTHLY COST</td></TR>
<TR>
<TD bgcolor="#099FF">Visits per<br/>week</TD>
<TD valign="bottom" bgcolor="#099FF">1 dog</TD>
<TD valign="bottom" bgcolor="#099FF">2 dogs</TD>
<TD valign="bottom" bgcolor="#099FF">3 dogs</TD>
<TD valign="bottom" bgcolor="#099FF">4 dogs</TD>
</TR>
<TR>
<TD bgcolor="Yellow"><font color="red">1 visit</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$35</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$45</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$55</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$65</font></TD>
</TR>
<TR>
<TD bgcolor="Yellow"><font color="red">2 visits</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$60</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$80</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$105</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$120</font></TD>
</TR>
<TR>
<TD bgcolor="Yellow"><font color="red">3 visits</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$90</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$110</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$125</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$145</font></TD>
</TR>
<TR>
<TD bgcolor="Yellow"><font color="red">4 visits</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$110</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$135</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$150</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$170</font></TD>
</TR>
<TR>
<TD bgcolor="Yellow"><font color="red">5 visits</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$145</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$170</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$190</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$225</font></TD>
</TR>
<TR>
<TD bgcolor="Yellow"><font color="red">6 visits</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$185</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$210</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$240</font></TD>
<TD bgcolor="#99fff" align=right><font color="green">$265</font></TD>
</TR>
</TABLE>

Posted by KetchupPrinceConsort (Member # 8047) on :

Thanks Tom!

That was really helpful and I was able to put it where I needed. That was really nice of you, thanks again.

Hatrack is so cool!

Posted by Strider (Member # 1807) on :

kq, as a general rule you want to use a .jpg when it's an actual photo and .gif when it's a computer generated image.

Posted by ketchupqueen (Member # 6877) on :

Yeah, I have usually got no use for computer generated images, but that's good to know, thanks. [Smile]