Sorry if you've already tried this, but what about just going to the
FILE menu (at the top) and depending on your version of Excel
selecting "Save As Webpage" or "Save As" and specifying .html as file
type. This can be handy but the only word of caution I'd add is that
Microsoft programs tend to throw a lot of garbage into the code, so if
you go this route you might want to look at the page and clean things
up after you've converted it to .html.
Holly
On Sun, Nov 14, 2010 at 8:01 AM, Belinda Slocumb <b.slocumb(a)gmail.com> wrote:
What HTML text editor are you using? Some may allow for importing the
tables and
and might even let you just highlight/copy the excel sheet and paste it into
the body of the page you are working on and might format it accordingly
itself. Always worth a try. I know I have pasted a pre-existing table into a
page before and then was able to adjust the widths if it was needed. See
what happens if you paste the tables into the body, and then check the code
to see how it writes it. It might just need a little tweaking of the tags to
get it to sort itself out right. There may also be some free tutorials
online that can help. You might try Googling something like "Excel to html"
or something like that.
Hope that helps,
Belinda
On Sat, Nov 13, 2010 at 11:03 PM, Linda Blum-Barton <lblumb(a)gmail.com>wrote:
> Dan,
>
> Thanks for that idea. I'll play with it and see if it will help. I
> thought
> maybe the data option of text to columns might solve it but so far I
> haven't
> made that work either. I have a spreadsheet with 2005 lines in it and I
> am
> trying to get it posted with the least amount of work - <g>. It should fit
> well within a normal screen width without having to scroll over which is
> what's frustrating me at the moment.
> Thanks again,
> Linda B.
>
> ----- Original Message -----
> From: "Two Run" <tworun.rw(a)charter.net>
> To: <gagen(a)rootsweb.com>
> Sent: Saturday, November 13, 2010 9:14 PM
> Subject: Re: [GAGEN] Excel Help...
>
>
> > Linda,
> >
> > I don't have any experience with what you are talking about, but I wonder
> > if
> > the Print settings might have any influence on how it gets saved to html.
> >
> > While on the desired worksheet, first go to the Print Setup and set it to
> > Fit-To-Page.
> >
> > Then try setting a Print Area around your data. You can highlight the
> > block
> > of cells you want, then File | Print Area | Set Print Area. Or you can
> > switch to View | Page Break Preview, and drag the borders of the Print
> > Area
> > wherever you want them.
> >
> > Try it with the Print Area fitting the data, and alternatively with extra
> > blank columns and rows on either side of your data.
> >
> > Hopefully it will effect what you see in html.
> >
> > Dan Pierce
> >
> >
> >
> > -----Original Message-----
> > From: Linda Blum-Barton
> > Sent: Saturday, November 13, 2010 3:42 PM
> > To: gagen(a)rootsweb.com
> > Subject: [GAGEN] Excel Help...
> >
> > Can anyone help me solve an issue I am having trying to turn an excel
> file
> > into html? I have done it before but apparently I need written
> > instructions
> > rather than those trapped in my mind........sigh.
> >
> > I have saved it as html and also saved the data into a table......but in
> > both cases I am having problems controlling the width of it and am not
> > sure
> > if there is something I can do in Excel to control that before converting
> > it......
> >
> > Any help greatly appreciated!
> >
> > Linda B.
> >
> >
> > -------------------------------
> > To unsubscribe from the list, please send an email to
> > GAGEN-request(a)rootsweb.com with the word 'unsubscribe' without the
> quotes
> > in
> > the subject and the body of the message
> >
> >
> > -------------------------------
> > To unsubscribe from the list, please send an email to
> > GAGEN-request(a)rootsweb.com with the word 'unsubscribe' without the
> quotes
> > in the subject and the body of the message
>
>
> -------------------------------
> To unsubscribe from the list, please send an email to
> GAGEN-request(a)rootsweb.com with the word 'unsubscribe' without the quotes
> in the subject and the body of the message
>
-------------------------------
To unsubscribe from the list, please send an email to GAGEN-request(a)rootsweb.com with the
word 'unsubscribe' without the quotes in the subject and the body of the message
--
'Deus, dona mihi serenitatem
accipere res quae non possum mutare,
fortitudinem mutare res quae possum,
atque sapientiam differentiam cognoscere.'
-Reinhold Niebuhr (July 1, 1943)