converting excel files into clean web pages

Moderator: MOD_nyhetsgrupper

Svar
Jill

converting excel files into clean web pages

Legg inn av Jill » 5. mars 2006 kl. 12.06

I am collecting ! a number of excel files of census transcriptions, BMD data
etc which I would like to include on to a website about the area
Does anyone know a clean way of doing this that does not involve hundreds of
<tr> <td></td> <td></td> </tr> etc
Or that inserts the tags automatically?

I am looking for simple clean pages of information - preferably searchable
by google

thanks
--

regards Jill Bowis
Surnames search http://www.bowis.co.uk
Senior, Ashworth, Pulman, Crossland, Ambler, Neutkens, Hebblethwaite
Bowis, Lister, Vaughn, Palin, Stewart, Newlove, Yabbicom, Goodall,
Stewart [Paisley], MacKinlay, Watt, Green, Smith
Mair, Brown, Lawrie, Sutherland, Rainey, Hunter, Pittendriech
Sumner, Moss, Houghton, Hampson, Owen,
tentative one name : Bowis One place: Ardchattan, Argyll
http://www.benderloch.org.uk

Joe Makowiec

Re: converting excel files into clean web pages

Legg inn av Joe Makowiec » 5. mars 2006 kl. 13.08

On 05 Mar 2006 in soc.genealogy.computing, Jill wrote:

I am collecting ! a number of excel files of census transcriptions,
BMD data etc which I would like to include on to a website about the
area Does anyone know a clean way of doing this that does not
involve hundreds of <tr> <td></td> <td></td> </tr> etc
Or that inserts the tags automatically?

I am looking for simple clean pages of information - preferably
searchable by google

The short answer is that Excel will export HTML. I don't have a copy
here to check, but I seem to recall that there are two HTML export
options - one includes all kinds of cruft that Excel would need to
recreate the file as a spreadsheet; the other exports fairly clean
HTML. Be careful with this one; Excel's proprietary HTML is awful.

Other options:
- Some HTML editors will import a CSV file, which Excel can also
export, as a table. I use DreamWeaver (although I'm a web developer by
profession, and DW isn't cheap). I've heard 1stPage recommended; it's
free:

http://www.evrsoft.com/1stpage3.shtml

As is Composer, which comes with Mozilla:

http://mozilla.org/

If your hosting supports databases, that's also an option, though it
requires some programming.

--
Joe Makowiec
http://makowiec.org/
Email: http://makowiec.org/contact/?Joe

Jill

Re: converting excel files into clean web pages

Legg inn av Jill » 5. mars 2006 kl. 13.10

"Joe Makowiec" <[email protected]> wrote in message
news:[email protected]...
On 05 Mar 2006 in soc.genealogy.computing, Jill wrote:

I am collecting ! a number of excel files of census transcriptions,
BMD data etc which I would like to include on to a website about the
area Does anyone know a clean way of doing this that does not
involve hundreds of <tr> <td></td> <td></td> </tr> etc
Or that inserts the tags automatically?

I am looking for simple clean pages of information - preferably
searchable by google

The short answer is that Excel will export HTML. I don't have a copy
here to check, but I seem to recall that there are two HTML export
options - one includes all kinds of cruft that Excel would need to
recreate the file as a spreadsheet; the other exports fairly clean
HTML. Be careful with this one; Excel's proprietary HTML is awful.

that is what I found -- hence my question :~)))

Other options:
- Some HTML editors will import a CSV file, which Excel can also
export, as a table. I use DreamWeaver (although I'm a web developer by
profession, and DW isn't cheap). I've heard 1stPage recommended; it's
free:


I use Homesite - I will look

http://www.evrsoft.com/1stpage3.shtml

As is Composer, which comes with Mozilla:

http://mozilla.org/

If your hosting supports databases, that's also an option, though it
requires some programming.


thanks for some starters

--

regards Jill Bowis
Surnames search http://www.bowis.co.uk
Senior, Ashworth, Pulman, Crossland, Ambler, Neutkens, Hebblethwaite
Bowis, Lister, Vaughn, Palin, Stewart, Newlove, Yabbicom, Goodall,
Stewart [Paisley], MacKinlay, Watt, Green, Smith
Mair, Brown, Lawrie, Sutherland, Rainey, Hunter, Pittendriech
Sumner, Moss, Houghton, Hampson, Owen,
tentative one name : Bowis One place: Ardchattan, Argyll
http://www.benderloch.org.uk

bella fortuni

Re: converting excel files into clean web pages

Legg inn av bella fortuni » 5. mars 2006 kl. 16.09

Take a look at T2T -- works quite well

http://home.hccnet.nl/s.j.francke/t2t/text2table.htm

Wm Voss

On Sun, 5 Mar 2006 11:06:16 -0000, " Jill"
<[email protected]> wrote:

I am collecting ! a number of excel files of census transcriptions, BMD data
etc which I would like to include on to a website about the area
Does anyone know a clean way of doing this that does not involve hundreds of
tr> <td></td> <td></td> </tr> etc
Or that inserts the tags automatically?

I am looking for simple clean pages of information - preferably searchable
by google

thanks

singhals

Re: converting excel files into clean web pages

Legg inn av singhals » 5. mars 2006 kl. 17.10

Jill wrote:

I am collecting ! a number of excel files of census transcriptions, BMD data
etc which I would like to include on to a website about the area
Does anyone know a clean way of doing this that does not involve hundreds of
tr> <td></td> <td></td> </tr> etc
Or that inserts the tags automatically?

I am looking for simple clean pages of information - preferably searchable
by google

thanks


No matter who generates, there will be hundreds of <tr> <td></td>
<td></td> </tr> in there if you want columns.

I've simply created extra columns in the right place, typed the <tr>
<td></td> <td></td> </tr> stuff on the first row, then copied it to the
end of the column. Save. Print-to-file.txt rename file to .htm and
away we go. Letting Excel do it puts in all those nasty font-calls for
each cell. :(

Cheryl

Jill

Re: converting excel files into clean web pages

Legg inn av Jill » 6. mars 2006 kl. 0.18

"singhals" <[email protected]> wrote in message
news:[email protected]...
Jill wrote:

I am collecting ! a number of excel files of census transcriptions, BMD
data etc which I would like to include on to a website about the area
Does anyone know a clean way of doing this that does not involve hundreds
of <tr> <td></td> <td></td> </tr> etc
Or that inserts the tags automatically?

I am looking for simple clean pages of information - preferably
searchable by google

thanks


No matter who generates, there will be hundreds of <tr> <td></td
td></td> </tr> in there if you want columns.

I've simply created extra columns in the right place, typed the <tr
td></td> <td></td> </tr> stuff on the first row, then copied it to the
end of the column. Save. Print-to-file.txt rename file to .htm and away
we go.

Now that is blooming cunning
Thank you

--

regards Jill Bowis
Surnames search http://www.bowis.co.uk
Senior, Ashworth, Pulman, Crossland, Ambler, Neutkens, Hebblethwaite
Bowis, Lister, Vaughn, Palin, Stewart, Newlove, Yabbicom, Goodall,
Stewart [Paisley], MacKinlay, Watt, Green, Smith
Mair, Brown, Lawrie, Sutherland, Rainey, Hunter, Pittendriech
Sumner, Moss, Houghton, Hampson, Owen,
tentative one name : Bowis One place: Ardchattan, Argyll
http://www.benderloch.org.uk

Letting Excel do it puts in all those nasty font-calls for
each cell. :(

Cheryl


Jill

Re: converting excel files into clean web pages

Legg inn av Jill » 6. mars 2006 kl. 0.19

"bella fortuni" <[email protected]> wrote in message
news:[email protected]...
Take a look at T2T -- works quite well

http://home.hccnet.nl/s.j.francke/t2t/text2table.htm

Wm Voss



cheers
I will explore

--

regards Jill Bowis
Surnames search http://www.bowis.co.uk
Senior, Ashworth, Pulman, Crossland, Ambler, Neutkens, Hebblethwaite
Bowis, Lister, Vaughn, Palin, Stewart, Newlove, Yabbicom, Goodall,
Stewart [Paisley], MacKinlay, Watt, Green, Smith
Mair, Brown, Lawrie, Sutherland, Rainey, Hunter, Pittendriech
Sumner, Moss, Houghton, Hampson, Owen,
tentative one name : Bowis One place: Ardchattan, Argyll
http://www.benderloch.org.uk

On Sun, 5 Mar 2006 11:06:16 -0000, " Jill"
[email protected]> wrote:

I am collecting ! a number of excel files of census transcriptions, BMD
data
etc which I would like to include on to a website about the area
Does anyone know a clean way of doing this that does not involve hundreds
of
tr> <td></td> <td></td> </tr> etc
Or that inserts the tags automatically?

I am looking for simple clean pages of information - preferably searchable
by google

thanks

singhals

Re: converting excel files into clean web pages

Legg inn av singhals » 6. mars 2006 kl. 16.32

Jill wrote:

"singhals" <[email protected]> wrote in message
news:[email protected]...

Jill wrote:


I am collecting ! a number of excel files of census transcriptions, BMD
data etc which I would like to include on to a website about the area
Does anyone know a clean way of doing this that does not involve hundreds
of <tr> <td></td> <td></td> </tr> etc
Or that inserts the tags automatically?

I am looking for simple clean pages of information - preferably
searchable by google

thanks


No matter who generates, there will be hundreds of <tr> <td></td
td></td> </tr> in there if you want columns.

I've simply created extra columns in the right place, typed the <tr
td></td> <td></td> </tr> stuff on the first row, then copied it to the
end of the column. Save. Print-to-file.txt rename file to .htm and away
we go.


Now that is blooming cunning
Thank you



If there's an easy way to do it, I find it. (g)

Note that </td><td> can go in ONE column and so can </td></tr>

Cheryl

71073511

Re: converting excel files into clean web pages

Legg inn av 71073511 » 6. mars 2006 kl. 18.12

Hello Jill,

On my copy of excel under the category File it shows the command, "Save as
web page".

have you tried these functions.

Stephen


" Jill" <[email protected]> wrote in message
news:[email protected]...
|I am collecting ! a number of excel files of census transcriptions, BMD
data
| etc which I would like to include on to a website about the area
| Does anyone know a clean way of doing this that does not involve hundreds
of
| <tr> <td></td> <td></td> </tr> etc
| Or that inserts the tags automatically?
|
| I am looking for simple clean pages of information - preferably searchable
| by google
|
| thanks
| --
|
| regards Jill Bowis
| Surnames search http://www.bowis.co.uk
| Senior, Ashworth, Pulman, Crossland, Ambler, Neutkens, Hebblethwaite
| Bowis, Lister, Vaughn, Palin, Stewart, Newlove, Yabbicom, Goodall,
| Stewart [Paisley], MacKinlay, Watt, Green, Smith
| Mair, Brown, Lawrie, Sutherland, Rainey, Hunter, Pittendriech
| Sumner, Moss, Houghton, Hampson, Owen,
| tentative one name : Bowis One place: Ardchattan, Argyll
| http://www.benderloch.org.uk
|
|

Jill

Re: converting excel files into clean web pages

Legg inn av Jill » 6. mars 2006 kl. 23.17

"71073511" <[email protected]> wrote in message
news:[email protected]...
Hello Jill,

On my copy of excel under the category File it shows the command, "Save as
web page".

have you tried these functions.

Stephen

have you seen what it does ?
bloated yucky horrid html

:~))


--

regards Jill Bowis
Surnames search http://www.bowis.co.uk
Senior, Ashworth, Pulman, Crossland, Ambler, Neutkens, Hebblethwaite
Bowis, Lister, Vaughn, Palin, Stewart, Newlove, Yabbicom, Goodall,
Stewart [Paisley], MacKinlay, Watt, Green, Smith
Mair, Brown, Lawrie, Sutherland, Rainey, Hunter, Pittendriech
Sumner, Moss, Houghton, Hampson, Owen,
tentative one name : Bowis One place: Ardchattan, Argyll
http://www.benderloch.org.uk

Dave Hinz

Re: converting excel files into clean web pages

Legg inn av Dave Hinz » 6. mars 2006 kl. 23.27

On Mon, 6 Mar 2006 22:17:13 -0000, Jill <[email protected]> wrote:
"71073511" <[email protected]> wrote in message
news:[email protected]...

On my copy of excel under the category File it shows the command, "Save as
web page".

have you seen what it does ? bloated yucky horrid html

Yeah, Microsoft's generated HTML has always been obscenely bad. Renders
(in IE), but shockingly bad. I would think exporting it to a CSV file
from excel, and running it through a (unix/linux) shell script would be
the way I would do it, myself. Maybe perl is another option. Someone
has probably done "csv2html" already. (googles)

Yup, a couple of .cgi, and a couple of .pl. I'd start there.
Kind of the lazy way to do it, but for an obvious need like this,
chances are very good that people have already written what you want.
the naming convention of "format2format" is typcally used, so if you
need, say, jpg2pdf, that's probably out there too. (checks...yup)

Dave Hinz

T.M. Sommers

Re: converting excel files into clean web pages

Legg inn av T.M. Sommers » 7. mars 2006 kl. 6.44

Dave Hinz wrote:
On Mon, 6 Mar 2006 22:17:13 -0000, Jill <[email protected]> wrote:
"71073511" <[email protected]> wrote in message
news:[email protected]...

On my copy of excel under the category File it shows the command, "Save as
web page".

have you seen what it does ? bloated yucky horrid html

Yeah, Microsoft's generated HTML has always been obscenely bad. Renders
(in IE), but shockingly bad. I would think exporting it to a CSV file
from excel, and running it through a (unix/linux) shell script would be
the way I would do it, myself.

If you have Unix, use tidy to tidy it up.

--
Thomas M. Sommers -- [email protected] -- AB2SB

Dave Hinz

Re: converting excel files into clean web pages

Legg inn av Dave Hinz » 7. mars 2006 kl. 15.39

On Tue, 07 Mar 2006 00:44:31 -0500, T.M. Sommers <[email protected]> wrote:
Dave Hinz wrote:
I would think exporting it to a CSV file
from excel, and running it through a (unix/linux) shell script would be
the way I would do it, myself.

If you have Unix, use tidy to tidy it up.

Ah, that's very nice, haven't run into that before. Installing now;
thank you.

Dave

Robert Heiling

Re: converting excel files into clean web pages

Legg inn av Robert Heiling » 7. mars 2006 kl. 16.30

Dave Hinz wrote:
On Tue, 07 Mar 2006 00:44:31 -0500, T.M. Sommers <[email protected]> wrote:
Dave Hinz wrote:
I would think exporting it to a CSV file
from excel, and running it through a (unix/linux) shell script would be
the way I would do it, myself.

If you have Unix, use tidy to tidy it up.

Ah, that's very nice, haven't run into that before. Installing now;
thank you.

Likewise just downloaded to use with fc4, but I noticed during the process that
there is also a current version for Windows 95/98/ME/2000/XP.
http://tidy.sourceforge.net/

Bob

Robert G. Eldridge

Re: converting excel files into clean web pages

Legg inn av Robert G. Eldridge » 8. mars 2006 kl. 23.03

On Mon, 06 Mar 2006 10:32:37 -0500, singhals <[email protected]>
wrote:

Jill wrote:

"singhals" <[email protected]> wrote in message
news:[email protected]...

Jill wrote:


I am collecting ! a number of excel files of census transcriptions, BMD
data etc which I would like to include on to a website about the area
Does anyone know a clean way of doing this that does not involve hundreds
of <tr> <td></td> <td></td> </tr> etc
Or that inserts the tags automatically?

I am looking for simple clean pages of information - preferably
searchable by google

thanks


No matter who generates, there will be hundreds of <tr> <td></td
td></td> </tr> in there if you want columns.

I've simply created extra columns in the right place, typed the <tr
td></td> <td></td> </tr> stuff on the first row, then copied it to the
end of the column. Save. Print-to-file.txt rename file to .htm and away
we go.


Now that is blooming cunning
Thank you



If there's an easy way to do it, I find it. (g)

Note that </td><td> can go in ONE column and so can </td></tr

Cheryl

I actually use the method you described to maintain the Members
Surname Interests at http://www.lmfhg.hl.com.au/interests.html

I do however skip the save as text step by directly copying the data
from Excel and pasting between <tbody> and </tbody> in the existing
..html file, after deleting the existing content that I'm updating.

Then it's just a matter of doing a search/replace in the text editor
to replace all the tabs, added by the copy from Excel, with nothing.
I use UltraEdit but any decent text editor will do.

Note I use <thead> content so that the headings are at the top of each
page when printed from modern Web browsers (as distinct from operating
system components that are not proper Web browsers such as IE).

Whilst talking about editing .html files does anyone know if there is
some setting or otherwise in Word so that it will open a .html file as
text instead of rendering it as Web content. Surely there must be some
other option to changing the file name to .txt and then back to .html
for people who want to use Word as a text editor.




--
Robert G. Eldridge Toronto NSW Australia
http://www2.hunterlink.net.au/~ddrge/
Now researching ELDRIDGE families world wide
1000's at my Web site * Wanted * Any Eldridge related information

Joe Makowiec

Re: converting excel files into clean web pages

Legg inn av Joe Makowiec » 9. mars 2006 kl. 2.53

On 08 Mar 2006 in soc.genealogy.computing, Robert G. Eldridge wrote:

Whilst talking about editing .html files does anyone know if there is
some setting or otherwise in Word so that it will open a .html file as
text instead of rendering it as Web content. Surely there must be some
other option to changing the file name to .txt and then back to .html
for people who want to use Word as a text editor.

My first reaction, and I'm not trying to be wise, is why would anybody
want to use Word as a text editor?

If it's for search/replace capacity, there are a number of vi(m) ports
for Windows; if they're done right, they allow for search/replace using
regular expressions. Some will even do code highlighting.

--
Joe Makowiec
http://makowiec.org/
Email: http://makowiec.org/contact/?Joe

Denis Beauregard

Re: converting excel files into clean web pages

Legg inn av Denis Beauregard » 9. mars 2006 kl. 7.11

On Thu, 09 Mar 2006 01:53:46 GMT, Joe Makowiec
<[email protected]> wrote in soc.genealogy.computing:

On 08 Mar 2006 in soc.genealogy.computing, Robert G. Eldridge wrote:

Whilst talking about editing .html files does anyone know if there is
some setting or otherwise in Word so that it will open a .html file as
text instead of rendering it as Web content. Surely there must be some
other option to changing the file name to .txt and then back to .html
for people who want to use Word as a text editor.

My first reaction, and I'm not trying to be wise, is why would anybody
want to use Word as a text editor?

If it's for search/replace capacity, there are a number of vi(m) ports
for Windows; if they're done right, they allow for search/replace using
regular expressions. Some will even do code highlighting.

There are much more Word users than vi users :o)

And I think emacs is less ported but easier to use.

For multi-file editing and to work on many html files at the time,
I prefer to use brief which is an old DOS text editor with
regular expressions. I presume when I will switch 100% to linux,
I will use emacs to replace brief.


Denis

Leif B. Kristensen

Re: converting excel files into clean web pages

Legg inn av Leif B. Kristensen » 9. mars 2006 kl. 9.48

Denis Beauregard skrev:

There are much more Word users than vi users :o)

And I think emacs is less ported but easier to use.

For multi-file editing and to work on many html files at the time,
I prefer to use brief which is an old DOS text editor with
regular expressions. I presume when I will switch 100% to linux,
I will use emacs to replace brief.

For the vi/emacs-challenged Linux users, there's a wonderful editor in
KDE called Kate (KDE Advanced Text Editor). Former Windows users will
feel immediately at home here.

When I'm forced to do editing in Windows, I'm using Edit Plus
<http://editplus.com/>. For 30 bucks, it's a very capable editor.
--
Leif Biberg Kristensen
http://solumslekt.org/

Doug McDonald

Re: converting excel files into clean web pages

Legg inn av Doug McDonald » 9. mars 2006 kl. 15.17

Joe Makowiec wrote:

If it's for search/replace capacity, there are a number of vi(m) ports
for Windows; if they're done right, they allow for search/replace using
regular expressions.

So will Word, to some extent. Actually works very well.

AND ...***** NOONE ***** who is not an IDIOT will use
a real vi or real vi clone for any purpose whatsoever.
Non-idiots use Emacs :-)

Doug McDonald

Dale DePriest

Re: converting excel files into clean web pages

Legg inn av Dale DePriest » 9. mars 2006 kl. 15.42

Leif B. Kristensen wrote:
Denis Beauregard skrev:


There are much more Word users than vi users :o)

And I think emacs is less ported but easier to use.

For multi-file editing and to work on many html files at the time,
I prefer to use brief which is an old DOS text editor with
regular expressions. I presume when I will switch 100% to linux,
I will use emacs to replace brief.


For the vi/emacs-challenged Linux users, there's a wonderful editor in
KDE called Kate (KDE Advanced Text Editor). Former Windows users will
feel immediately at home here.

When I'm forced to do editing in Windows, I'm using Edit Plus
http://editplus.com/>. For 30 bucks, it's a very capable editor.

There is a perfectly good emacs for windows. I use it a lot.

Dale
--
_ _ Dale DePriest
/`) _ // http://users.cwnet.com/dalede
o/_/ (_(_X_(` For GPS and GPS/PDAs

Dave Hinz

Re: converting excel files into clean web pages

Legg inn av Dave Hinz » 9. mars 2006 kl. 15.44

On Thu, 09 Mar 2006 08:17:16 -0600, Doug McDonald <mcdonald@SnPoAM_scs.uiuc.edu> wrote:

AND ...***** NOONE ***** who is not an IDIOT will use
a real vi or real vi clone for any purpose whatsoever.

There's a lot of negatives in that, you seem to have the wrong number.

Non-idiots use Emacs :-)

Hm. Let's see. of the 400+ unix boxes I have, how many of them will
have emacs available when I need it? Let's see....none. Yeah, sure, I
could install it, but why use a programmer's text editor when I'm a
sysadmin?

Robert Melson

Re: converting excel files into clean web pages

Legg inn av Robert Melson » 9. mars 2006 kl. 17.38

In article <[email protected]>,
Doug McDonald <mcdonald@SnPoAM_scs.uiuc.edu> writes:
Joe Makowiec wrote:

If it's for search/replace capacity, there are a number of vi(m) ports
for Windows; if they're done right, they allow for search/replace using
regular expressions.

So will Word, to some extent. Actually works very well.

AND ...***** NOONE ***** who is not an IDIOT will use
a real vi or real vi clone for any purpose whatsoever.
Non-idiots use Emacs :-)

Doug McDonald

Gee, the start of a flame war!

Opinions, they say, are like certain portionns of the anatomy - everybody has
one. IMNSHO, emacs is on a par with Word - bloated, unusable, obscure. While
vi and clones aren't perfect, they have the virtue of simple command sets,
easy customization and reliability.

Now, lest you jump on me over this, let me say I used emacs exclusively for
about 20 years and finally became disgusted with it and its "alt-meta-control-
3-turns-widdershins" commands and went back to a much improved vi.

Bob Melson

--
Robert G. Melson | Rio Grande MicroSolutions | El Paso, Texas
-----
"One of the greatest delusions in the world is the hope that the evils in this world are to be cured by legislation." Thomas Reed
-----

Leif B. Kristensen

Re: converting excel files into clean web pages

Legg inn av Leif B. Kristensen » 9. mars 2006 kl. 18.15

Dale DePriest skrev:

Leif B. Kristensen wrote:
For the vi/emacs-challenged Linux users, there's a wonderful editor
in KDE called Kate (KDE Advanced Text Editor). Former Windows users
will feel immediately at home here.

When I'm forced to do editing in Windows, I'm using Edit Plus
http://editplus.com/>. For 30 bucks, it's a very capable editor.

There is a perfectly good emacs for windows. I use it a lot.

Then you're probably not among the emacs-challenged of us ;-)

For my part, I became fed up with the Ctrl-Shift-Twiddlestick command
paradigm way back when I moved from WordStar to WordPerfect, and had to
relearn everything about how to edit a document. I've tried emacs
several times since around 1990, and every time I've went away with the
feeling that life is too short to learn how to handle this beast.
--
Leif Biberg Kristensen
http://solumslekt.org/

Dennis Lee Bieber

non sequitur: (Re: converting excel files into clean web pag

Legg inn av Dennis Lee Bieber » 9. mars 2006 kl. 18.18

On Thu, 09 Mar 2006 09:48:01 +0100, "Leif B. Kristensen"
<[email protected]> declaimed the following in
soc.genealogy.computing:

For the vi/emacs-challenged Linux users, there's a wonderful editor in

It is definitely too early to be reading Usenet... On first glance I
saw "vile macs" <G>
--
==============================================================
[email protected] | Wulfraed Dennis Lee Bieber KD6MOG
[email protected] | Bestiaria Support Staff
==============================================================
Home Page: <http://www.dm.net/~wulfraed/
Overflow Page: <http://wlfraed.home.netcom.com/

Dave Hinz

Re: non sequitur: (Re: converting excel files into clean web

Legg inn av Dave Hinz » 9. mars 2006 kl. 18.32

On Thu, 09 Mar 2006 17:18:35 GMT, Dennis Lee Bieber <[email protected]> wrote:
On Thu, 09 Mar 2006 09:48:01 +0100, "Leif B. Kristensen"
[email protected]> declaimed the following in
soc.genealogy.computing:


For the vi/emacs-challenged Linux users, there's a wonderful editor in

It is definitely too early to be reading Usenet... On first glance I
saw "vile macs" <G

And what's the problem with that? It's a good description.

Leif B. Kristensen

Re: non sequitur: (Re: converting excel files into clean web

Legg inn av Leif B. Kristensen » 9. mars 2006 kl. 18.35

Dennis Lee Bieber skrev:

It is definitely too early to be reading Usenet... On first glance I
saw "vile macs" <G

vilemacs is Steve Jobs' new ultimate open source editor.
--
Leif Biberg Kristensen
http://solumslekt.org/

Robert Melson

Re: converting excel files into clean web pages

Legg inn av Robert Melson » 9. mars 2006 kl. 21.02

In article <[email protected]>,
[email protected] (Robert Melson) writes:
In article <[email protected]>,
Doug McDonald <mcdonald@SnPoAM_scs.uiuc.edu> writes:
Joe Makowiec wrote:

If it's for search/replace capacity, there are a number of vi(m) ports
for Windows; if they're done right, they allow for search/replace using
regular expressions.

So will Word, to some extent. Actually works very well.

AND ...***** NOONE ***** who is not an IDIOT will use
a real vi or real vi clone for any purpose whatsoever.
Non-idiots use Emacs :-)

Doug McDonald

Gee, the start of a flame war!

Opinions, they say, are like certain portionns of the anatomy - everybody has
one. IMNSHO, emacs is on a par with Word - bloated, unusable, obscure. While
vi and clones aren't perfect, they have the virtue of simple command sets,
easy customization and reliability.

Now, lest you jump on me over this, let me say I used emacs exclusively for
about 20 years and finally became disgusted with it and its "alt-meta-control-
3-turns-widdershins" commands and went back to a much improved vi.

Bob Melson


I'll add that only the masochistic use emacs.

Sadistic Ol' Bob

Apropos nothing, you know the definition of a masochist is one who says "hurt
me". A sadist, on the other hand, is one who says "no" to the masochist.

SOB

--
Robert G. Melson | Rio Grande MicroSolutions | El Paso, Texas
-----
"One of the greatest delusions in the world is the hope that the evils in this world are to be cured by legislation." Thomas Reed
-----

Robert M. Riches Jr.

OT: editor wars; [was Re: converting excel files into clean

Legg inn av Robert M. Riches Jr. » 9. mars 2006 kl. 21.50

On 2006-03-09, Robert Melson <[email protected]> wrote:
In article <[email protected]>,

Now, lest you jump on me over this, let me say I used emacs exclusively for
about 20 years and finally became disgusted with it and its "alt-meta-control-
3-turns-widdershins" commands and went back to a much improved vi.

Bob Melson


I'll add that only the masochistic use emacs.

Sadistic Ol' Bob

Apropos nothing, you know the definition of a masochist is one who says "hurt
me". A sadist, on the other hand, is one who says "no" to the masochist.

SOB

I don't consider myself masochistic, and I have used emacs
for about 20 years. To each his/her own, but with vi I
can't stand having to remember which mode the editor is in
and how many times I will have to press ESC to get it back
to the baseline mode so I can get out of it.

Now, what's the topic of this newsgroup? :-)

--
Robert Riches
[email protected]
(Yes, that is one of my email addresses.)

Robert G. Eldridge

Re: converting excel files into clean web pages

Legg inn av Robert G. Eldridge » 10. mars 2006 kl. 5.54

On Thu, 09 Mar 2006 01:53:46 GMT, Joe Makowiec
<[email protected]> wrote:

On 08 Mar 2006 in soc.genealogy.computing, Robert G. Eldridge wrote:

Whilst talking about editing .html files does anyone know if there is
some setting or otherwise in Word so that it will open a .html file as
text instead of rendering it as Web content. Surely there must be some
other option to changing the file name to .txt and then back to .html
for people who want to use Word as a text editor.

My first reaction, and I'm not trying to be wise, is why would anybody
want to use Word as a text editor?

The situation arose when I created a web page for my partners
genealogy where the content is done using <pre> formatted text.

I thought she could use Word, as she was used to using it, for
maintaining the <pre> content, especially as Word has a show/hide
spaces facility which is handy when using preformatted text with a
fixed pitch font.

If it's for search/replace capacity, there are a number of vi(m) ports
for Windows; if they're done right, they allow for search/replace using
regular expressions. Some will even do code highlighting.

As I know as use UltraEdit myself.

I was just surprised that Word didn't open what is essentially a text
file as text but, as is the want of a lot of Gatesware, tries to be
too clever by half and opened the file as a Web page.

--
Bob

Dale DePriest

Re: converting excel files into clean web pages

Legg inn av Dale DePriest » 10. mars 2006 kl. 6.52

Leif B. Kristensen wrote:
Dale DePriest skrev:


Leif B. Kristensen wrote:

For the vi/emacs-challenged Linux users, there's a wonderful editor
in KDE called Kate (KDE Advanced Text Editor). Former Windows users
will feel immediately at home here.

When I'm forced to do editing in Windows, I'm using Edit Plus
http://editplus.com/>. For 30 bucks, it's a very capable editor.

There is a perfectly good emacs for windows. I use it a lot.


Then you're probably not among the emacs-challenged of us ;-)

For my part, I became fed up with the Ctrl-Shift-Twiddlestick command
paradigm way back when I moved from WordStar to WordPerfect, and had to
relearn everything about how to edit a document. I've tried emacs
several times since around 1990, and every time I've went away with the
feeling that life is too short to learn how to handle this beast.

You no longer have to do that if you don't want to. Emacs for windows
now has drop down menus and all the other bells and whistles.

Dale
--
_ _ Dale DePriest
/`) _ // http://users.cwnet.com/dalede
o/_/ (_(_X_(` For GPS and GPS/PDAs

Joe Makowiec

Re: converting excel files into clean web pages

Legg inn av Joe Makowiec » 10. mars 2006 kl. 15.45

On 09 Mar 2006 in soc.genealogy.computing, Doug McDonald wrote:

Joe Makowiec wrote:

If it's for search/replace capacity, there are a number of vi(m)
ports for Windows; if they're done right, they allow for
search/replace using regular expressions.

So will Word, to some extent. Actually works very well.

AND ...***** NOONE ***** who is not an IDIOT will use
a real vi or real vi clone for any purpose whatsoever.
Non-idiots use Emacs :-)

In defense of vi(m):

I just used vim to do a quick edit on a php script I've been playing
with on and off for about a year. I'd created it on a PC, uploaded it
to a FC4 box, and it never worked. When I loaded it in vim, which does
code coloring, I noticed that two lines which I though I had right were
not colored as PHP functions. Corrected the spelling (jpg -> jpeg);
the functions lit up; resaved; and bam! - it worked.

ObGenealogy: PHP is the basis for PHPGedView, the marvelous open source
system for displaying your genealogy online:

http://www.phpgedview.net/

--
Joe Makowiec
http://makowiec.org/
Email: http://makowiec.org/contact/?Joe

singhals

Re: converting excel files into clean web pages

Legg inn av singhals » 10. mars 2006 kl. 18.36

Robert G. Eldridge wrote:
snip

I was just surprised that Word didn't open what is essentially a text
file as text but, as is the want of a lot of Gatesware, tries to be
too clever by half and opened the file as a Web page.


You'd be surprised how many people actually like that. I'm not among
'em, but an awful lot of folks wanted that so they could do WYSIWYGs.

Cheryl

Steve Hayes

Re: converting excel files into clean web pages

Legg inn av Steve Hayes » 10. mars 2006 kl. 23.24

On Fri, 10 Mar 2006 12:36:41 -0500, singhals <[email protected]> wrote:

Robert G. Eldridge wrote:
snip

I was just surprised that Word didn't open what is essentially a text
file as text but, as is the want of a lot of Gatesware, tries to be
too clever by half and opened the file as a Web page.


You'd be surprised how many people actually like that. I'm not among
'em, but an awful lot of folks wanted that so they could do WYSIWYGs.

Well it is useful if you want tom save an HTML file as a word processing
documennt.


--
Steve Hayes from Tshwane, South Africa
http://www.geocities.com/Athens/7734/stevesig.htm
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

KittyCooper

Re: converting excel files into clean web pages

Legg inn av KittyCooper » 11. mars 2006 kl. 5.57

A really nice free HTML editor which lets you see the source codes and
text is HTML-kit from Chami.com. It also includes the tidy function
(remove all font tags, strip surplus word200 tags). It would probably
do a nice job cleaning up the excell generated HTML as well.

Kitty
http://OpenSkyWebDesign.com

Steve Hayes

Re: converting excel files into clean web pages

Legg inn av Steve Hayes » 11. mars 2006 kl. 7.23

On 10 Mar 2006 20:57:04 -0800, "KittyCooper" <[email protected]> wrote:

A really nice free HTML editor which lets you see the source codes and
text is HTML-kit from Chami.com. It also includes the tidy function
(remove all font tags, strip surplus word200 tags). It would probably
do a nice job cleaning up the excell generated HTML as well.

I sometimes pull those MS generated html files into my word processor and type

change /&nbsc//

That can sometimes reduce the file size by half.


--
Steve Hayes from Tshwane, South Africa
http://www.geocities.com/Athens/7734/stevesig.htm
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

Jill

thank you Re: converting excel files into clean web pages

Legg inn av Jill » 13. mars 2006 kl. 10.00

"KittyCooper" <[email protected]> wrote in message
news:[email protected]...
A really nice free HTML editor which lets you see the source codes and
text is HTML-kit from Chami.com. It also includes the tidy function
(remove all font tags, strip surplus word200 tags). It would probably
do a nice job cleaning up the excell generated HTML as well.

Kitty
http://OpenSkyWebDesign.com


Thank you all for the interesting replies and useful snippets
This little software is especially neat for stripping word tags
- yes I understand the discussion about word ! but sometimes its just there
! <big grin>
So once again thank you - its all been very useful

--

regards Jill Bowis
Surnames search http://www.bowis.co.uk
Senior, Ashworth, Pulman, Crossland, Ambler, Neutkens, Hebblethwaite
Bowis, Lister, Vaughn, Palin, Stewart, Newlove, Yabbicom, Goodall,
Stewart [Paisley], MacKinlay, Watt, Green, Smith
Mair, Brown, Lawrie, Sutherland, Rainey, Hunter, Pittendriech
Sumner, Moss, Houghton, Hampson, Owen,
tentative one name : Bowis One place: Ardchattan, Argyll
http://www.benderloch.org.uk

T.M. Sommers

Re: converting excel files into clean web pages

Legg inn av T.M. Sommers » 13. mars 2006 kl. 11.17

Robert Melson wrote:
IMNSHO, emacs is on a par with Word - bloated, unusable, obscure.

Twenty years ago one could justifiably call emacs bloated, but it
hardly compares with the likes of Word in the bloat category:

-rwxr-xr-x 1 root wheel 3558672 Jan 3 2003 xemacs

and from top:

PID USERNAME PRI NICE SIZE RES STATE TIME WCPU
CPU COMMAND
809 tms 96 0 12208K 4160K select 2:33 0.00%
0.00% xemacs-21.1.1

How big is Word?

--
Thomas M. Sommers -- [email protected] -- AB2SB

Svar

Gå tilbake til «soc.genealogy.computing»