Excel data to the web

[William]

I have several excel price sheets that I want to publish to the web.
What I have done for now is to print them as pdf's and then open them
in Photoshop and save them as jpg's.
It works, but the text is not as crisp as I would like it.
When I use the save for the web feature in Excel, a lot of the
formatting goes bad.
Is there a preferred method of converting excel documents to be viewed
on the web?
I'm usiing Excel 2004 for the Mac.
Any suggestions would be appreciated.

 

[JE McGimpsey]

I have several excel price sheets that I want to publish to the web.
What I have done for now is to print them as pdf's and then open them
in Photoshop and save them as jpg's.
It works, but the text is not as crisp as I would like it.
When I use the save for the web feature in Excel, a lot of the
formatting goes bad.
Is there a preferred method of converting excel documents to be viewed
on the web?
I'm usiing Excel 2004 for the Mac.

Well, I'd guess that the *preferred* method is to Save the
sheet/workbook as a web page. I do this regularly with simple sheets,
and have had no particular formatting problems. The html isn't as
efficient as I'd like, but it displays fine in Safari, Firefox, and
WinIE.

What formatting is going bad for you?

The nice thing about saving as a web page is that I can automate the
file to update my web server every time I save it (update on save within
XL, and a Folder Action to upload to my web server).

Other options:

- Press CMD-SHIFT-4 and drag the pointer over the portion of the
window you want to capture. This will produce a .png image on the
desktop.

- Use the Grab app to produce a .tiff file of the selection or window.

I'm not a graphics expert, but I'd think that either should give you
higher fidelity than the pdf->jpg conversion.

 

[little_creature]

Hello,
That mmuch depends on what exactly you want:

****If you want people to demonstrate some calculation, to see how some
formula is done, then I will let then download then. Then I would either
leave the excel as *.xls or zip them.

****If you want people to see your charts, I would click on that particular
chart with holding ctrl and pick save as picture and then I would choose
either png or jpg. Note that jpg is compression where some of the data are
being loosed, so that's why you do not see the text so sharp.

****If you want just show people part of the data I would leave in PDF for
download.

****If you want to do a table on web, it's quite easy to do it by HMTL tags.
<table >
<tr>
<td>1st row, 1st column</td>
<td>1st row, 2nd column</td>
</tr>

<tr>
<td>2nd row, 1st colum</td>
<td>2nd row, 2nd colum</td>
</tr>


<tr>
<td>3rd row, 1st colum</td>
<td>3rd row, 2nd colum</td>
</tr>
</table>

<table> starts the table and </table> closes the table, you can add as
much as rows/colums as you'd like in between, according the example
That's what I would do if I need table.

**** If I will just need some illustration of the screen I would use print
scree-grab it as tiff and ten carefully convert it in Photoshop to jpg.
Photoshop is quite efficient in doing good looking jpgs.
The another option is to print it into Postsript from Excel, then open in
the Photoshop and do jpg.

Before doing jpg from any source where the result is not very good, you can
try resampling in Photoshop and sharpening.

 

[William]

Well, I'd guess that the *preferred* method is to Save the
sheet/workbook as a web page. I do this regularly with simple sheets,
and have had no particular formatting problems. The html isn't as
efficient as I'd like, but it displays fine in Safari, Firefox, and
WinIE.

What formatting is going bad for you?

The nice thing about saving as a web page is that I can automate the
file to update my web server every time I save it (update on save within
XL, and a Folder Action to upload to my web server).

Other options:

- Press CMD-SHIFT-4 and drag the pointer over the portion of the
window you want to capture. This will produce a .png image on the
desktop.

- Use the Grab app to produce a .tiff file of the selection or window.

I'm not a graphics expert, but I'd think that either should give you
higher fidelity than the pdf->jpg conversion.

 

[Jim Gordon MVP]

Hi William,

If you wish to be able to save graphs in higher resolution make them in
PowerPoint. The web options in PowerPoint let you save up to 1600 dpi using
PICT format.

-Jim Gordon
Mac MVP


--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info